While preparing reports and dashboard in Excel, it’s time-consuming to select an entire column using the mouse
These excel shortcuts are useful to save time and help you do your work faster using the keyboard shortcut keys.
How to select the entire column in excelSelecting cells is a very common function in Excel
It performs many tasks like addition, deletion and width adjustment of multiple rows and columns while applying the formula on data in Excel
1. Select one or more cells Using Shortcut (Shift+Arrow)2. How to Select Column in Excel Using Keyboard Shortcuts (CTRL+SPACE)3. How to Select Entire Row Using Keyboard Shortcuts in Excel (SHIFT+SPACE)
The full column can be selected by clicking on the letter at the column’s header. You can also use the Ctrl+Space keyboard shortcut after selecting a column cell.