I want to show only filled in cells in Excel

G

Guest

I have a spreadsheet that was sent to me that only contains 2 columns and 6
rows and the rest of the page is not active. I can click and expand them all
and when I go to undo it says row height or column width. I have not been
able to find the answer or duplicate it myself. I think it would be great to
clean up the clutter of my spreadsheets. Thanks for any help.
 
G

Gord Dibben

Go to row 7 and CTRL + SHIFT + Down Arrow.

Format>Rows>Hide

Select column C and CTRL + SHIFT + Right Arrow.

Format>Columns>Hide.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top