Ctrl + Numbers
Ctrl + 0 | Hides the columns in the current selection. |
Ctrl + 1 | Displays the Format Cells dialog box (not using the keypad). |
Ctrl + 2 | Toggles bold on the current selection. |
Ctrl + 3 | Toggles italics on the current selection. |
Ctrl + 4 | Toggles underlying on the current selection. |
Ctrl + 5 | Toggles the strikethrough of text on the current selection. |
Ctrl + 6 | Toggles between showing all objects or showing no objects in the active workbook. This option can be found under (Advanced, Display options for this workbook - For objects show). |
Ctrl + 7 | Allows you to move/reposition the entire Excel window using the arrow keys. |
Ctrl + 8 | Toggles the display of Outline Symbols on the active worksheet. |
Ctrl + 9 | Hides the rows in the current selection. |
Ctrl + Shift + 0 | Unhides the columns in the current selection. |
Ctrl + Shift + 1 | Applies the Comma separated format "#,##0.00" to the selection. |
Ctrl + Shift + 2 | Enters the value from the cell directly above into the active cell. |
Ctrl + Shift + 4 | Applies the Currency format "£#,##0.00" to the selection. |
Ctrl + Shift + 5 | Applies the Percentage format "0%" to the selection. |
Ctrl + Shift + 6 | Applies the Exponential format "#,##E+02" to the selection. |
Ctrl + Shift + 7 | Applies a thin black border around the outside of the selected cells. |
Ctrl + Shift + 8 | Selects the Current Region (surrounded by blank rows and columns). |
Ctrl + Shift + 9 | Unhides the rows in the current selection. |
Ctrl + 0 Hides the columns in the current selection. |
Ctrl + 1 Displays the Format Cells dialog box (not using the keypad). |
Ctrl + 2 Toggles bold on the current selection. |
Ctrl + 3 Toggles italics on the current selection. |
Ctrl + 4 Toggles underlying on the current selection. |
Ctrl + 5 Toggles the strikethrough of text on the current selection. |
Ctrl + 6 Toggles between showing all objects or showing no objects in the active workbook. This option can be found under (Advanced, Display options for this workbook - For objects show). |
Ctrl + 7 Allows you to move/reposition the entire Excel window using the arrow keys. |
Ctrl + 8 Toggles the display of Outline Symbols on the active worksheet. |
Ctrl + 9 Hides the rows in the current selection. |
Ctrl + Shift + 0 Unhides the columns in the current selection. |
Ctrl + Shift + 1 Applies the Comma separated format "#,##0.00" to the selection. |
Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell. |
Ctrl + Shift + 4 Applies the Currency format "£#,##0.00" to the selection. |
Ctrl + Shift + 5 Applies the Percentage format "0%" to the selection. |
Ctrl + Shift + 6 Applies the Exponential format "#,##E+02" to the selection. |
Ctrl + Shift + 7 Applies a thin black border around the outside of the selected cells. |
Ctrl + Shift + 8 Selects the Current Region (surrounded by blank rows and columns). |
Ctrl + Shift + 9 Unhides the rows in the current selection. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext