![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.germanpearls.com/wp-content/uploads/2016/10/17oct2016_how-to-hide-and-unhide-columns-in-excel_1-1024x545.png)
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. 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. Hiding Columns in Excel 2010 (Guide with Pictures) Our article continues below with additional information on hiding spreadsheet columns in Microsoft Excel 2010, including pictures of these steps. Right-click the selected column and choose Hide.Select the column heading of the column to hide.Open the spreadsheet with the columns to hide.
#How to hide and unhide a column in excel how to#
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.ġ0 See also How to Hide a Column (or 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.Īll of the columns retain their original lettering, just not all of them can be seen. 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. 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. This is not a fault of Microsoft Excel, however. But if you haven’t had to hide something before, especially a lot of data, then you may be wondering how to hide a column in Excel.ĭealing with large amounts of data in Microsoft Excel 2010 can be a bit of a headache. This is the perfect situation for using the “hide” feature in Microsoft Excel, which will keep the data in the sheet, but remove it from view. With the entire sheet selected, it doesn't matter where in the headings you right-click.Sometimes you will have data in a spreadsheet that you don’t need to display, but you don’t want to delete.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://www.top-password.com/blog/wp-content/uploads/2018/08/hide-a-row-in-excel-2016.png)
You can then right-click on row and column headings and select Unhide for each. If you'd like to unhide all rows and columns in a worksheet, first, select the entire worksheet.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://cdn.wallstreetmojo.com/wp-content/uploads/2018/11/Unhide-Column-step-14.jpg)
Then, right-click in the row selection and choose Unhide from the menu. Notice the gap in row numbers when rows are hidden.Īs with columns, you need to select rows on both sides of the rows you want to unhide. Or, you can use the right-click menu, which is faster. You can hide and unhide rows using Hide Rows and Unhide Rows in the Format menu. Rows work in much the same way as columns. Then, right-click and choose Unhide from the menu. To unhide the columns, make sure to select columns on both sides of the hidden columns. Select one or more columns, right-click in the selection, and choose Hide from the menu. You can also hide and unhide columns using the right-click menu. Then, choose Unhide Columns from the Format menu.
![how to hide and unhide a column in excel how to hide and unhide a column in excel](https://cdn.extendoffice.com/images/stories/doc-excel/unhide-all-sheets/doc-unhide-worksheets-01.png)
To unhide a column, you need to select columns on both sides of the hidden column. Notice that when a column is hidden, its heading is also hidden, so that there is a gap in the column letters that run across the top of the worksheet. One way to hide a column is to choose Hide Columns from the Format menu on the home ribbon. Hiding rows or columns is a good way to visually simplify a worksheet without removing important information. In this lesson, we'll look at how to hide and unhide columns and rows.