You can identify hidden columns by looking for two lines between column letters. Your cursor needs to be to the right of the two lines for this method. Placing the cursor to the left will increase the column size of the left adjacent column.
Hold down the ⇧ Shift key while you click both letters above the column Click the left column next to the hidden columns. Click the right column next to the hidden columns. The columns will be highlighted when you successfully select them. For example, if column B is hidden, you should click A and then C while holding down ⇧ Shift.
For more helpful excel tricks, check out our intro guide to Excel.
Hiding columns can be useful for when you have data you don’t need at the moment, but want to keep in the spreadsheet. For example, if you’re tracking your bills in Excel, you might want to hide purchase categories when you’re only working with the sum totals.
