Excel Shortcuts

If you want to save a new copy of your active Excel file, you can go to File > Save as, or you can use this shortcut:

F12

If you want to save your work in Excel, you can go to File > Save, or you can use this shortcut:

Ctrl+S

FULL POST

If you want to hide a row in Excel, you can select the row by clicking on the row header (the number 1, 2, 3 etc. to the left), right-click and choose Hide.

Or you can select any cell in the row you want to hide and use this shortcut:

Ctrl+9

FULL POST

If you want to hide a column in Excel, you can select the column by clicking on the column header (the letter A, B, C etc.), right-click and choose Hide.

Or you can select any cell in the column you want to hide and use this shortcut:

Ctrl+0

FULL POST

If you want to insert the current time in a cell in Excel, you can use this shortcut:

Ctrl+Shift+. (dot)

Note that this is static. If you want the value to update, you should use the NOW function, which returns date and time, or =NOW()-TODAY() to return the time (apply time format).

FULL POST

If you want to insert today’s date in a cell in Excel, you can use this shortcut:

Ctrl+Shift+, (comma)

Note that this is static, ie. it will remain the same tomorrow. If you want the value to update every day, you should use the TODAY function.

FULL POST

If you want to copy the cell above the active cell, you can select that cell, copy it, select the cell below again, and paste. Or you can simply use this shortcut:

Ctrl+D

FULL POST

If you want to open the Go To Dialog Box, you can go to Home > Find & Select > Go To, or you can use one of these shortcuts:

Ctrl+G
F5

FULL POST