Your favorite Excel "Trick"

[My Aswer Is This]

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

 

[starl]

I'm using Excel 2013

Still works in Office 365

 

[danielcarrington]

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.

 

[Sialoquent]

Ctrl+T for me.

 

[Faysal Farooqui]

CTRL + D
Copy the above cell

 

[MARK858]

CTRL + D
Copy the above cell

You should also like CTRL + R as well then, copy cell to the right.

 

[Faysal Farooqui]

That is also true, but I have to use Ctrl+D in most of my tasks, due to manual data entry.

 

[snjpverma]

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.

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).

 

[Zack Barresse]

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]

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.