Thus, it becomes essential to unhide the data for facilitating a complete data view. Later, we may again need to see the hidden data for further work or corrections.
In such a case, we typically hide certain rows or columns. However, we need to show a person the summarized analysis or the stored data results in the sheet. The unhide feature can help unhide the desired row(s)/ column(s) easily.įor example, suppose we have an Excel sheet where some rows have data that we don't want to display to another person. It is nothing but the opposite process of the hide feature in Excel. The unhide feature helps users to display the hidden data within the sheet. What is Unhide feature in Excel for Rows and Columns? The article explains all the steps and the relevant examples. In this article, we discuss some quick shortcuts to unhide the hidden data in excel. For such a case, the unhide feature is the solution. However, we might later need to unhide it. In such cases, we hide the data using the Hide feature in Excel. There may be cases when we need to hide some data that is unimportant to show others. Excel can easily store vast amounts of data.
#HOW DO I UNHIDE FIRST COLUMN IN EXCEL SOFTWARE#
Choose “Unhide”.MS Excel is currently the most popular spreadsheet software for data analysis and many other business-related tasks.
Next, right-click anywhere in the column label green area. Once clicked, you’ll see all row labels and column labels have a green background. Note the white cross instead of the black arrow. Again the cursor is close to the square, but not quite there. Cursor is close to the square, but not quite there. You’ll know you’re in the right area to click when your mouse cursor turns to a white cross. This area is a bit difficult to describe, so see the screenshots below. To select all cells in a spreadsheet, click on the square connecting the gray row labels and the gray column labels. Selecting all cells in the spreadsheet will ensure that all columns will be unhidden. But for larger spreadsheets it will be more difficult to spot every fold mark indicating hidden columns. You could easily select column ranges with missing letters and then unhide columns as you normally would. To unhide all columns, you’ll need to select all cells in the spreadsheet.
The second clue is the fold marks between consecutive visible columns.
One clue that columns are hidden is the letters in the column labels skip around. There are two visual clues that some states are hidden. When you open the file, you notice that only a few of the states are visible. Let’s say you’re working with a data set showing certain facts by state.
#HOW DO I UNHIDE FIRST COLUMN IN EXCEL DOWNLOAD#
If you would like to work with my example Excel file, you can download it here from Google Drive. Let’s break that down with some screenshots. Then right-click in the green area of the column labels and choose “Unhide”. All cells in the spreadsheet should be selected now. To unhide all columns in Excel, click on the square connecting the first column and first row. Thankfully, there is a quick way to unhide all columns in Excel. You scan the lettering of the column labels and see that the letters are skipping around. Sometimes you’ll open an Excel file and have a feeling that something is missing.
0 kommentar(er)
