Your favorite Excel "Trick"

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
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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.
 
That is also true, but I have to use Ctrl+D in most of my tasks, due to manual data entry.
 
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
 
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)
 

Forum statistics

Threads
1,212,927
Messages
6,110,733
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top