Step 2: Open the Excel workbook containing the column that you would like to hide. Step 1: Navigate to Excel Online at and sign into your Microsoft Account. For example, the column C was hidden previously, so select the columns B and D. Select the columns that are around the hidden column. To unhide the column, perform the following steps. Additionally, columns can be unhidden later if you decide that you would like to display the information again. How to unhide a column in Excel Similar to hiding the column or rows, unhiding the column too is a fairly simple step. Step 1: Select the row header beneath the used working area in the worksheet. Note that a hidden column is not deleted from a spreadsheet, and that you can still use formulas to reference cells in hidden columns. We can hide an entire row or column by Hide & Unhide command, and can hide all blank rows and columns with this command too. These steps will also work in other desktop Web browsers like Microsoft Edge and Firefox. The steps in this article were performed in the desktop version of Google Chrome. Right click on chart -> Select Data -> Hidden and Empty Cells (a button at bottom left) -> Check Show data in hidden rows and columns. Select the rows or columns you wish to hide, and then carry out this command: Excel 2007 or later: Click the Group icon in the Outline section of the Data ribbon. Re: Hide columns, still use data in charts. Our tutorial below will show you how to hide a column in Excel Online. Excel's Group feature is an effective alternative to manually hide or unhide rows and columns. This removes that data from view, but leaves it in the spreadsheet so that you can use it later, or if you are referencing it with a formula. But deleting that data might not be something that you want to do in the event that you find out you need it later.įortunately Excel Online has a feature that lets you hide entire columns of data. Sometimes this data might be a little too extensive, meaning that you have entire columns of information that you don’t need. It’s very likely that you will eventually be working with a spreadsheet that contains a lot of data. We perform these steps in Excel Online, but they will work in other Excel versions as well. This guide is going to show you how to hide columns in Excel.

Hide columns in excel