Category: Excel Shortcuts

The shortcut Ctrl+3 is to italicize text or remove italic formatting, same as the shortcut Ctrl+I. Step 1: Select the data range you want to italicize (e.g., B2:D4); Step …

The shortcut Ctrl+2 is to bold the text or to remove the bold format. This is the same as the shortcut "Ctrl+B". Step 1: Select the data range you …

The shortcut Ctrl+0 is to hide the selected columns. Please check shortcut "Ctrl+Shift+)" to see how to unhide columns. Step 1: click any cell in the worksheet (e.g., A1); …

The shortcut Ctrl+1 is to format a cell using the "Format Cells" dialog box. Step 1: Click any cell in the worksheet (e.g., cell A1); Step 2: Press and …

The shortcut Shift+Up Arrow is to extend the selection by one cell up. Step 1: Click anywhere in a worksheet, e.g., C5; Step 2: Press and hold the "Shfit" …

The shortcut Shift+Space Bar is to select the entire row in a worksheet. Please refer to "Ctrl+Space Bar" if you want to use the shortcut to select the column. …