Your favorite Excel "Trick"

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

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,869
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)
 

h2o2sail

New Member
Joined
Jun 1, 2010
Messages
0
CTRL + d or CTRL + r to fill down or fill right without using the mouse. Simple but mostly unused by those trying to fill cells with the same formula.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,165
Messages
5,442,782
Members
405,195
Latest member
Mike Neal

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top