When you have a large spreadsheet you may not to see all the column all the time, or if you have created columns that have data which is used in calculations but you don’t really want them to be seen you can hide the columns.

Hidden columns or rows can still be referenced and used within calculations, just not visible in the spreadsheet unless they are unhidden. They basically have a column or row height/width of 0.

A quick way to do this is to right mouse click on the column or row heading (number or letter) and select Hide Column/Row.

You will notice that the numbering skips the hidden one. So if you have hidden column B you will see A then C columns. To get the hidden row or column back you can drag across the previous and following rows or columns. For example drag and select columns A and C which will automatically select hidden B as well.

Then right mouse click and select unhide.

Another way is to resize the