Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Alt + Shift +F1 Insert new worksheet
Shift + F3 Open the Excel formula window
Shift +F5 Bring up search box
Ctrl + Tab Switch between two or more open Excel files
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into the current cell
Ctrl + Shift + ! Format number in comma and decimal form
Ctrl + Shift + $ Format number in currency form
Ctrl + Shift + # Format number in date form
Ctrl + Shift + % Format number in percentage form
Ctrl + Shift + ^ Format number in scientific form
Ctrl + Shift + @ Format number in time form
Ctrl + W Close a workbook
Ctrl + O Open a workbook
Alt + H Go to the Home tab
Ctrl + S Save a workbook
Ctrl + C Copy selection
Ctrl + V Paste selection
Ctrl + O Open a workbook
Alt + H Go to the Home tab
Ctrl + S Save a workbook
Ctrl + C Copy selection
Ctrl + V Paste selection
Ctrl + Z Undo recent selection
Delete remove cell contents
Choose a fill colour Alt + H, H
Cut selection Ctrl + X
Go to the Insert tab Alt+N
Apply bold formatting Ctrl+Bb
Center align cell contents Alt+H, A, C
Go to the Page Layout tab
Go to the Data tab Alt+A
Go to the View tab Alt+W
Open the context menu Shift+F10 or Windows menu key
Add borders Alt+H, B
Delete column Alt+H, D, C
Go to the Formula tab Alt+M
Hide the selected rows Ctrl+9
Hide the selected columns Ctrl+0
Cheers,
The Table Originals team
.png)
Comments