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? Excel 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |