How To Select A Whole Column In Excel
By
SpreadCheaters
Page last updated:
18/11/2022 |
Next review date:
18/11/2024
You can watch a video tutorial here.
Efficiency will always be key when you want to make the most of your time. When selecting an entire column in Excel, there are 2 ways to do it, and it will always be up to the user which ever option they prefer.
Step 1 – Choose the column you want to select
For this example, column F will be chosen.
Step 2 – Click on the top most part of the column or use the shortcut.
There are 2 options when selecting an entire column:
– Click on the top most part of the column, which are the alphabets that sit on top.
– Click anywhere on the column and press Ctrl + spacebar
