- Move to next cell in row – Tab
- Move to previous cell in row - Shift + Tab
- Up one screen - Page Up
- Down one screen - Page Down
- Move to next worksheet - Ctrl + Page Down
- Move to previous worksheet - Ctrl + Page Up
- Go to first cell in data region - Ctrl + Home
- Go to last cell in data region - Ctrl + End
- Bold toggle for selection - Ctrl + B
- Italic toggle for selection - Ctrl + I
- Underline toggle for selection - Ctrl + U
- Strikethrough for selection - Ctrl + 5
- Change the font - Ctrl + Shift + F
- Change the font size - Ctrl + Shift + P
- Apply outline borders - Ctrl + Shift + 7
- Remove all borders - Ctrl + Shift + Underline
- Wrap text in same cell - Alt + Enter
- Format cells - Ctrl + 1
- Select font - Ctrl + Shift + F
- Select point size - Ctrl + Shift + P
- Format as currency - Ctrl + Shift + 4
- Format as general - Ctrl + Shift + # (hash sign)
- Format as percentage - Ctrl + Shift + 5
- Format as number - Ctrl + Shift + 1
- Autosum a range of cells - Alt + Equals Sign
- Insert the date - Ctrl +; (semi-colon)
- Insert the time - Ctrl + Shift +; (semi-colon)
- Insert columns/rows - Ctrl + Shift + + (plus sign)
- Insert a new worksheet - Shift + F11
- Read Monitor Cell One - Alt + Shift + 1
- Read Monitor Cell Two - Alt + Shift + 2
- Read Monitor Cell Three - Alt + Shift + 3
- Read Monitor Cell Four - Alt + Shift + 4
- List Visible Cells With Data - Ctrl + Shift + D
- Lists Data In Current Column - Ctrl + Shift + C
- List Data In Current Row - Ctrl + Shift + R
- Select Hyperlink - Ctrl + Shift + H
- Move To Worksheet Listbox - Ctrl + Shift + S
- Move To Monitor Cell - Ctrl + Shift + M
- Select Worksheet Objects - Ctrl + Shift + O
0 comments:
Post a Comment