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.
HOW DO I HIDE COLUMNS IN EXCEL HOW TO
Note that you can also quickly select multiple columns that are next to one another by clicking the leftmost letter of the column you want to hide, holding down the Shift key, then clicking the rightmost letter of the column you want to hide.įind out how to remove borders in Excel if you currently have borders but don’t want them.Once hidden, you can right-click on a visible sheet and select Unhide. Step 4: Right-click one of the selected column letters, then choose the Hide option. Step 3: Continue holding down the Ctrl key, then click the column letters of other columns you want to hide. Step 2: Hold down the Ctrl key on your keyboard, then click the column letter of the first column you want to hide. Step 1: Open the Excel file containing the columns you want to hide. The steps in this article were performed in Microsoft Excel for Office 365, but will work in most other versions of Excel as well. Can I Hide More than One Column at a Time in Excel? Our guide below is going to show you how to use the Hide functionality in Microsoft Excel for Office 365 so that you can hide more than one column at a time. This is helpful if you are trying to consolidate your data to make it easier for readers to understand, but you don’t want to delete that data. Microsoft Excel for Office 365 gives you the ability to hide more than one column at a time. Right-click one of the selected column letters, then choose the Hide option.Click additional column letters to select them, then release the Ctrl key when you’re done.Click the column letter of the first column you wish to hide.Hold down the Ctrl key on your keyboard.This guide is going to show you how to hide more than one column in your Excel spreadsheet.
0 kommentar(er)
