Why cant I hide rows in Google Sheets?
|
I am using google sheets, for a client. There are some rows hidden. I can not unhide them. If I hide some rows myself, then I get a little updown arrow, that I can click to unhide them. However this is not present on the ones that are already hidden. Show
Is there another way that they could be hidden, that I can investigate? asked May 25, 2018 at 14:57
ctrl-alt-delorctrl-alt-delor 4061 gold badge3 silver badges15 bronze badges 2 It was filters. I turned them off. Go to Menu → Data → filters, you can turn them off, you may want to adjust them some other way. answered May 25, 2018 at 15:04
ctrl-alt-delorctrl-alt-delor 4061 gold badge3 silver badges15 bronze badges I had a similar, but different, problem: I had narrowed the column to the point where I could not see anything in the column and I could not grab it and make it wider. (hope this is useful for people that search for this.) Solution:Highlight the column to the left or right of the column you can not see the data in, then highlight the column you can not see the data in and then right click and Resize. Now you can see both columns. This only took me 30 minutes to figure out, hope it helps.
answered May 16, 2019 at 17:35
DavidDavid 311 bronze badge Do you want to hide rows/columns? I do this when publishing or sharing a sheet for people to view and I don't want them to see email addresses or other confidential information. To hide a column:
To hide a row:
Warning: If you share this document with someone using &newcopy, they will be able to see the columns and rows you have hidden. Updated on November 8, 2021 This article explains how to hide or unhide rows in the desktop version of Google Sheets, which is accessed through a web browser. This instructions do not apply to the Google Sheets mobile app. Spreadsheets can help you examine information in various configurations to consider different possibilities. If you use Google Sheets, hiding rows is one of the features that help you do this. In this example, the salespeople are listed from the longest to the shortest time with the company. We want to see sales figures without those of the two most recent hires, Allison and Mike. Here's how to do it.
How to Unhide Rows in Google SheetsWhen you're done viewing information with some of the rows hidden, it's easy to see them again.
How to Find Hidden Information in Google SheetsAnother way data can be hidden in Google Sheets is with filters. Say your boss shares a Google Sheets file with you and asks you to run an analysis on information that you just can’t find, even by using the search function. In this example, we’re missing the "Tom" row. It's possible this is happening because there's a filter in place. If you see different coloring (usually dark gray) and filter information above the columns, and different coloring in the numbered column to the left of the rows, you're dealing with a filter. To reverse this condition, click the X on the right side of the bar with the filter information. Now you should be able to find your "missing" data with no problem. Tara Moore/Getty ImagesAnother Trick to Try: Freezing Rows in Google Docs Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe How do I hide rows in Google Sheets?To hide a row, right click on the row number on the left of the spreadsheet and choose Hide row. To hide multiple rows in a Google Spreadsheet, click on the first row and drag across the rows you wish to hide, or hold the Shift key and click on the last row you want to hide.
Why I Cannot unhide rows in Google Sheets?Here's how:. Click the Data menu from the menu bar.. Select the option that says 'Turn off filter'.. This should remove filters from your sheet and you should be able to see all your previously hidden rows again.. Why can't I hide columns in Google Sheets?To hide columns on Google Sheets
Click View > Show Columns, then uncheck any columns that you don't need, then hit OK. Click on the column header on top of the working area to select the column (or columns), you want to hide.
How do you unlock hidden rows in Google Sheets?In the top left corner of the page, hit the gray rectangle and the entire page will be selected. Now, right-click anywhere on the page. In the menu, you will see the “Unhide rows” option if there are hidden rows present in the sheet. If you don't see such an option, it clearly shows there are no hidden rows.
|
