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
Excel shortcut: Save as
Author: A Danielsen
Excel shortcut: Save document
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
Excel shortcut: Switch between tabs
If you want to switch to another worksheet tab in Excel, you can use your mouse and click on the tab you want to open, or you can use these shortcuts:
Ctrl+PageUp
Ctrl+PageDown
FULL POST
Excel shortcut: Hide Row
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
Excel shortcut: Hide Column
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
Excel shortcut: Insert current time
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
Excel shortcut: Insert today’s date
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
Excel shortcut: Format Cells
If you want to format the selected cell or range in Excel, you can click on the small arrow symbol in the number section on the Home tab, or you can use this shortcut:
Ctrl+1
Excel shortcut: Copy Cell Above
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
Excel shortcut: Open Go To Dialog Box
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