If you’re like me, you want to get as much work done with as little effort expended as possible. When working in excel, I’m sure you’ve found instances where you need to select a lot of columns or rows at once. Most of the time we need to do that because we simply want to hide those columns or rows, or apply formatting to all of them at once.
There is a really easy way to do this though. If you need to hide a column or row you can go to the Format menu, choose the column from the there and then choose to hide it. But picture doing that for 100 or more columns or rows. There is a technique for solving that problem as well. The best thing about it is that you can do that with only a few easy clicks. Here they are:
First, you need to click the first cell of the first column which you want to select. Now click the shortcut keystroke F5. You’ll see the go to dialog box (many first time excel users might not be familiar with this). Now, enter the cell address of the last cell in the last column you want to select. Now, select all those cell addresses between the first cell and the last one. The best way to do that is to hold down the shift key. Next, hit OK. You’ll see that all of your cells are highlighted. Now, if you want to hide them, you just go to the Format menu, choose Columns and then hide them. All of the selected columns will be hidden.