Ctrl+0 to 9 using Excel

Dear All,
Below are some more keyboard shortcuts of excel to speedup and reduce analysis duration.

Ctrl+0 to 9

Function Use
Ctrl+0 Hides all secelcted columns
Ctrl+1 Changes the format of the selected cells
Ctrl+2 Bolds all cells in the highlighted section or vice versa
Ctrl+3 Puts italics all cells in the highlighted section or vice versa
Ctrl+4 Underlines all cells in highlighted section or vice versa
Ctrl+5 Puts a strikethrough all cells in the highlighted section
Ctrl+6 Shows or hides objects
Ctrl+7 Shows or hides the toolbar
Ctrl+8 Toggles the outline symbols
Ctrl+9 Hides all selected rows

1 Like