Your favorite Excel "Trick"

CephasOz

Board Regular
Joined
Feb 18, 2020
Messages
188
Office Version
365, 2016
Platform
Windows
Ctrl + ; for the current date, and Ctrl + : for the current time. (Also Ctrl + D and Ctrl + R.) I had never before come across the Shift + F2 that @starl mentioned - so useful!
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

ashakantasharma

Board Regular
Joined
May 28, 2020
Messages
81
Office Version
365, 2019
Platform
Windows, Mobile, Web
Pressing ALT for accessing all features without a mouse.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,545
Messages
5,487,494
Members
407,603
Latest member
jortronm

This Week's Hot Topics

Top