This time, there will be an option Hide rows 5 – 11 (the row numbers listed will depend on which rows have been selected). As with the single row, right mouse click on any of the selected rows to bring up the context menu. Any rows in between, will also have been selected. To select contiguous, successive rows, select the first of the desired rows, hold down the shift key, and select the last row in the group. While the above process has hidden a single row, the same procedure holds true for multiple rows. Both the missing row number and up/down arrows are an indication that a row has been hidden. There are also an up arrow on the left of row number 3 and a down arrow on the left of row number 5.
The row numbering shows row 3 and then row 5 immediately below, but no row 4. To confirm that the row is truly hidden, check the row numbering on the very left of the sheet on the row grid, looking for row 4. In the context menu that pops up, select Hide row. As can be seen in the following figure, the sheet requires us to scroll both vertically and horizontally in order to view all information.Īssuming we want to hide the fourth row, select that row and right mouse click anywhere in the selected row.
#HOW TO UNHIDE A COLUMN IN EXCEL MANUALLY HOW TO#
We’ll start by seeing how to hide a single row in our test spreadsheet. While this article is about how to unhide rows and columns in a sheet, knowing how rows and columns are hidden will make it easier to understand and find hidden rows and columns. Google Sheets, a web based spreadsheet application, allows the user to temporarily hide unwanted rows (or columns), so that the desired bits of information appear in consecutive rows or in adjacent columns.
Scrolling up and down, or left and right, can make it very inconvenient when trying to compare entries, especially when there are hundreds of rows of information. In some cases, it may also be necessary to scroll horizontally, when there are more columns than can fit in the width of the screen. Almost always, the user will need to scroll vertically to view all rows.
Why Hide Rows or Columns in Sheets?ĭespite the flexibility offered by spreadsheets, no matter how well organized the information in the spreadsheet may be, large amounts of information can sometimes make it difficult to display everything on a computer screen. Sheets can be independent of each other, or they can help to break down complex information structures into manageable, related components. Spreadsheets comprise sheets, each sheet acting as a compartment for a particular collection of information. The same is also possible with rows, but it is not as common, it simply depends on what information will be saved in the spreadsheet and how to best organize it. It is customary to give columns labels or titles for easy identification, usually in the first row. Almost any type of information can be entered in a cell, including numeric, currency, date, time, and of course various text formats. Information is represented in a two dimensional matrix, with the axes commonly referred to as rows and columns.Įach piece of information is contained in a cell, and its coordinates are given as the row and column at which the cell resides. This version removes filters and then unhides any rows and columns previously hidden.Computer users have been using spreadsheets to organize and manipulate information ever since the appearance of the first personal desktop computers. If there are other rows and columns that are manually hidden and that you want displayed, you can use the following version of the macro: If the hidden rows and columns are a result of the filters you applied, those rows and columns should be visible after removing all the filters. If wks.AutoFilterMode Then wks.AutoFilterMode = False Here is a short little macro that will remove any filters applied to any worksheets in the workbook: This means that you must use a macro to do the work-unless you want to remove filters one worksheet at a time. While you can use this approach for unhiding rows, you cannot affect filters-once you select more than a single worksheet, the Filter tool (on the Data tab of the ribbon) is no longer selectable. One would think that it would be possible to do this manually by building a "selection set" of all the worksheets you want to affect, and then removing filters. He would like to know the easiest way to remove filters and unhide rows and columns in all the worksheets at once. Rob has a workbook that contains multiple worksheets.