How to select entire column with gaps in Excel - Excel Tips and Tricks

Learn how to select entire column with gaps in Excel. Or how to select entire columns with blank cells.

Here are the steps outlined in my video.

METHOD 1
For None Table
1) Ctrl + Shift + End
2) Shift + Left Arrow

METHOD 2
For None Table
1) Select full column
2) Ctrl + Shift + Down Arrow
3) Shift + Right Arrow
4) Tab
5) Shift + Right Arrow

For Table
Ctrl + Space

#tips #excel #shorts #fyp