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.
0 kommentar(er)
