How to Hide Columns in Excel 2010

Dealing with large amounts of data in Microsoft Excel 2010 can be a bit of a headache. This is not a fault of Microsoft Excel, however. Most of the trouble lies in the size of the screen on which you are viewing the spreadsheet and the amount of data that you can see at once. When you get frustrated with scrolling right and left to keep finding the column of data that you need, you will inevitably wonder how to hide columns in Excel 2010. This is a very helpful method for optimizing the viewing screen in Excel 2010, and it does so without deleting any of your data. All of the columns retain their original lettering, just not all of them can be seen. So even if you have a formula that references a cell that is now hidden, the formula cell will still be showing the correct value.


Hiding Columns in Excel 2010


The procedure outlined below is best used on columns that contain data that you know you will either not be using, or will not need to change. Even though the column is hidden, the old expression “out of sight, out of mind” comes into play here, and there is a chance that you will forget that data exists. I have also found the ability to hide columns in Excel 2010 to be very beneficial when I am printing out my spreadsheets and I can exclude certain irrelevant columns of data from the printed copy.

Step 1: Open the spreadsheet in Microsoft Excel 2010 that contains the column(s) of data that you want to hide.

Step 2: Click the column heading at the top of the spreadsheet to select the entire column.

select a column in excel 2010


Step 3: Right-click the selected column, then click the Hide option.

how to hide columns in Excel 2010


Note that you can simultaneously hide multiple contiguous columns by clicking the leftmost column heading, then dragging your mouse to select the rest of the columns you want to hide. If the multiple columns you want to hide are not contiguous, then you can hold down the Ctrl key on your keyboard and click each individual column that you want to hide, then right-click one of the selected columns and click Hide.


You can unhide a column by selecting the two columns surrounding the column (for example, if you hid column B, you would select columns A and C), right-clicking one of the selected columns, then clicking the Unhide option.

Note that this method will also work on rows that you want to hide. Simply right-click the row heading at the left side of the window, then click the Hide option. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.