Forum Discussion
Excel - Hiding Rows with no values
You just want to hide, correct? Not eliminate the row; just hide it.
A simple way to do that would be to
- have an extra column off to the side that shows annual total (maybe you already do have one like that)
- Then use Data....Filter... to filter out all rows where Annual Total = 0
Hello anyone -
My spreadsheet is A1 - F18. I want to hide the remaining rows and columns that are not part of my work. Please, how would I do that? Is there a quick way to select the remaining rows and columns?
gaynel13
My spreadsheet is A1 - F18. I want to hide the remaining rows and columns that are not part of my work.
I read that to mean that all of the work is in the range A1-F18. Is that correct?
If so, the "want to hide the remaining rows and columns" raises the question "From whom, exactly?"
To hide ALL of the remaining rows and columns of a standard Excel worksheet can take several forms. If you just are looking to print the range A1-F18, make that your selection and nobody will see any of the adjacent rows/columns in the printout.
You could also go to File...Preferences -- View and set the color of the gridlines to white, and then use formatting to make the cell borders IN your range to gray or black.
That way the rows and columns won't show, despite being there.
But to hide from view within the spreadsheet itself, seems an odd request. Before we take it further, could you explain the "Why?" of this briefly.