For example, if Column B is hidden, you would need to select column A and column C and then right-click and choose Unhide to unhide it. To unhide a row or column, you need to select the row/column before and the row/column after the hidden row/column. You can easily tell there are hidden rows and columns in Excel because the numbers or letters skip and there are two visible lines shown to indicate hidden columns or rows. To hide a column or multiple columns, you need to right-click on the column letter at the very top. To hide a row or multiple rows, you need to right-click on the row number at the far left. If you want to hide an entire row or column, right-click on the row or column header and then choose Hide. You can also click on the Page Layout tab and uncheck the View box under Gridlines. To hide all gridlines, you can click on the View tab and then uncheck the Gridlines box. When hiding gridlines, you can either hide all gridlines on the entire worksheet or you can hide gridlines for a certain portion of the worksheet. Hide GridlinesĪ common task in Excel is hiding gridlines to make the presentation of the data cleaner. Also, whatever original value was in the hidden cell will be replaced when typing into the hidden cell.

Note that if you type anything into those cells, it will automatically be hidden after you press Enter. To unhide the cells, follow the same procedure above, but this time choose the original format of the cells rather than Custom. You can click on the cell and you should see the cell remains blank, but the data in the cell shows up in the formula bar. On the Number tab, choose Custom at the bottom and enter three semicolons ( ) without the parentheses into the Type box.Ĭlick OK and now the data in those cells is hidden. You can hide entire rows and columns in Excel, which I explain below, but you can only blank out individual cells. Right-click on a cell or multiple selected cells and then click on Format Cells.

It can only blank out a cell so that it appears that nothing is in the cell, but it can’t truly “ hide” a cell because if a cell is hidden, what would you replace that cell with? All hidden sheets will be shown in a list and you can select the one you want to unhide.Įxcel does not have the ability to hide a cell in the traditional sense that they simply disappear until you unhide them, like in the example above with sheets. Once hidden, you can right-click on a visible sheet and select Unhide.

How do i hide columns in excel