Thread: Collapsed Cells
View Single Post
 
Old 10-14-2022, 06:39 AM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 361
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by kchris View Post
I have an excel file with cells that obviously have been moved to zero height.
If I try to print the document the cells are not visible inside the print-out.

I can not attach it because of confidential content.


If I select all cells and define a cell height manually for all, cells the relevant cells stay invisible. If I select all cells and choose to show cells, the relevant cells stay invisible too. Any ideas ?
I'm presuming you could tell whether those rows are filtered out and unfilter them.

Are those cells at the top of your worksheet? If so, you may have Freeze Panes set incorrectly. Try going to the View tab on the Ribbon, find Freeze Panes, and Unfreeze Panes.

Check to see if your worksheet is protected (under Review tab). That might explain why you can't change the row height.
Reply With Quote