Forum Discussion
Excel - Hiding Rows with no values
Hi all, I was hoping for some help please... I have an excel spreadsheet which is for our accounting purposes. 12 monthly columns are group in to financial years. Rows are a list of projects and the cells for each month are our fees. We are finding that our list of projects (rows is growing) despite no fees or values being entered in each column. I wanted to be able to create a formula or perform an operation that will automatically hide each row with no values in them for each 12 month period. Can anyone help me with this please?
Thanks, Ajay
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.
