Insert shortcuts
- Insert dialog box > ctrl +
- Insert current date > ctrl + ;
- Insert current time > ctrl + Shift + ;
Delete shortcuts
- Delete dialog box > ctrl + –
Formatting shortcuts
- Format cells dialog box > ctrl + 1
- Bold > ctrl + b
- Italics > ctrl + i
- Underline > ctrl + u
- Indent (increase) > alt + h + 6
- Indent (decrease) > alt + h + 5
Formula shortcuts
Paste shortcuts
- Paste as value > alt + e + s + v + enter
Other shortcuts
- Copy text above active cell > ctrl + d
- Select entire row > shift + spacebar
- Select entire column > ctrl + spacebar
- Navigate through worksheets > ctrl + page up / page down
- Filter > ctrl + shift + l
- Insert/convert data to table > ctrl + t
Leave a Reply