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 ?

Remove confidential data and replace with pseudo data. Post example workbook.

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.

Oh, forgot one. If you select a range of rows starting above and ending beneath the invisible ones, try Format/Row/Unhide. The button is the Format button on the Home ribbon. Keystrokes "ALT+ O, R, U" (holding down the ALT key, typing and releasing O, then R, then U for unhide [H for hide to reverse the command]) is how I usually do it.