Your favorite Excel "Trick"

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,762
Office Version
2013
Platform
Windows
Here is a trick you may not know about:
Tired of making Drop down Lists.

A trick I use is:
Enter a value in C1 Like "Alpha"
Then if you Enter "Allen" in "C2"
And "Allice in "C3"

And now you want "Alpha" in "C4" just Press The alt key then down arrow key. Release alt Key and select the value from the shown list and presto you have the value you selected in the active cell.
I'm using Excel 2013
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

danielcarrington

New Member
Joined
Mar 28, 2020
Messages
2
Office Version
365
Platform
Windows
Hi,
Alt+PrtSc (Alt + Print Screen)
Useful for capturing the active window or active userform when creating a set of instructions.
Probably one of the best tricks ever, not only in Excel but in all programs.

Also Ctrl + Arrow or Ctrl + Shift + End combos for quick selections.
 

Faysal Farooqui

New Member
Joined
Sep 25, 2017
Messages
4
Office Version
2016
Platform
Windows
CTRL + D
Copy the above cell
 

Faysal Farooqui

New Member
Joined
Sep 25, 2017
Messages
4
Office Version
2016
Platform
Windows
That is also true, but I have to use Ctrl+D in most of my tasks, due to manual data entry.
 

snjpverma

Well-known Member
Joined
Oct 2, 2008
Messages
1,383
Office Version
2016
Platform
Windows
One of my favorite tricks while working with Pivot Tables.
Select the cells that you want to deselect from filter and press Ctrl + minus.
Your filter has been applied.

In the below screenshot, I wanted to filter out Bellen and Carlota from my Pivot. So I selected them and pressed Ctrl +minus sign.
1585763365843.png


Output Screenshot, after pressing the keys. As highlighted, we can see that the filter has been applied and the two selected cells are no more visible (Deselected from filter).
1585763490324.png
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
365, 2010
Platform
Windows, Mobile, Web
Soooo many to choose from. The tricks I use are generally keyboard shortcuts. Some of my most used are:

Worksheet
CTRL+T : create Table
SHIFT+Spacebar : Select entire row (or Table row)
CTRL+Spacebar : Select entire column (or Table column

VBA
SHIFT+F2 : Goto Definition (like Starl said)
CTRL+SHIFT+F2 : Go back to last position
CTRL+F9 : Set next executed line (without stepping)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,546
Messages
5,487,489
Members
407,604
Latest member
jortronm

This Week's Hot Topics

Top