Hopefully this guide helps you better manage the large data sets that are inevitable when working with Excel on a daily basis.Learning how to unhide a row in Excel 2013 can help to solve some confusing situations that arise when you know data is in a spreadsheet, but you cannot see it. We tossed in the final section on hiding a single cell for you over achievers. We promised a quick, easy guide to hiding and unhiding rows and columns in Excel. Select OK and the contents of the cell will now be visible. Navigate to the Custom section of the Format Cells dialog box. To unhide the contents of the cell simply reverse the steps. To verify, look at the formula bar with the cell selected and you will be able to view the contents of the cell. As previously mentioned, while hidden, the data is still in the cell and can be referenced by formulas. Poof! The contents of cell D2 are now hidden. Select the Type box, which likely says General at first, and enter three semi-colons ( ). With the Format Cells dialog box open navigate to the Custom section at the bottom of the left side list. You can also access the dialog box by right clicking the cell and selecting Format Cells. Press Ctrl + 1 to open the Format Cells dialog box. Any formulas that reference the cell will still work as normal.įirst, select the cell you want to hide. This can be confirmed by selecting the cell and viewing the data in the formula bar. Note: while the contents of the cell will be hidden the data will still remain. In the following example we will hide the contents of cell D2. With Excel it is possible to hide the contents of a single cell without losing the data. When working with large data sets a spreadsheet can become confusing to look at and fast. Unhide a column: Ctrl + Shift + 0 Hiding a Single Cell The following can be used to unhide the row or column: Use the following keyboard shortcuts to hide a row or column: We’ve dedicated an entire page to exploring the various shortcuts that make working in Excel a breeze. Here at ExcelTraining we are all about making your Excel life easier. Keyboard Shortcuts to Unhide Rows and Columns Simply select the entire worksheet, right mouse click and select unhide rows or unhide columns. If you received a spreadsheet and notice some rows and columns are hidden it may be best to unhide everything so you know what you are working with. Click Format > Hide & Unhide > Unhide Rows or Unhide Columns. Select the unhide option from the drop down menu and the rows or columns will become visible.Ģ) Navigate to the Cells group on the Home tab. When this becomes necessary you have a few options:ġ) Right click on the thin double line that indicates a hidden row or column. You will see a thin double line in the spreadsheet that indicates the hidden rows or columns.Ī time will come when you will likely need to unhide the rows or columns previously hidden. Once done the rows or columns that you selected will now be hidden. For an even quicker option, simply right click and select hide. Click Format > Hide & Unhide > Hide Rows or Hide Columns. With your selection made, navigate to the Cells group on the Home tab. If the desired areas are not next to each other you can hold down the Control key (Command if on a Mac) and make your selection. To select consecutive rows or columns simply hold down the Shift key and select or use the mouse to highlight the options you wish to hide.
Selections can be next to each other, though this is not mandatory. You can select a single row or column or multiple rows or columns. How to Hide Rows and Columns in Excelįirst, select the rows or columns that you would like to hide. This quick guide will explore a few methods that can be used to hide and unhide rows and columns in Excel. This allows you to focus on only the data that is necessary for you to complete the task at hand. When dealing with large data sets in Excel it can be useful to hide rows and columns.
0 kommentar(er)
