Spreadsheet disappears from print preview

%3CLINGO-SUB%20id%3D%22lingo-sub-1907132%22%20slang%3D%22en-US%22%3ESpreadsheet%20disappears%20from%20print%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1907132%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20five%20page%20spreadsheet%20set%20up%20on%20a%20Windows%2010%20laptop%20which%20is%20displayed%20on%20the%20screen%20but%20disappears%20to%20nothing%20but%20a%20one%20line%20header%20on%20one%20page%20on%20print%20preview%20and%20therefore%20doesn't%20print%20all%20five%20pages.%20Can%20anybody%20tell%20me%20how%20to%20get%20it%20back%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1907132%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1907154%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20disappears%20from%20print%20preview%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1907154%22%20slang%3D%22en-US%22%3Ereally%20hard%20to%20guess%20without%20the%20sheet%20but%20make%20sure%20it%20isn't%20the%20'print%20area'%20setting.%20Go%20to%20Page%20Layout%20-%26gt%3B%20Print%20Area%20-%26gt%3B%20Clear%20Print%20Area.%3CBR%20%2F%3EIf%20that%20isn't%20it%2C%20can%20you%20send%20a%20copy%20of%20the%20workbook%20(without%20personal%2Fconfidential%20info)%3F%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a five page spreadsheet set up on a Windows 10 laptop which is displayed on the screen but disappears to nothing but a one line header on one page on print preview and therefore doesn't print all five pages. Can anybody tell me how to get it back please?

3 Replies
Highlighted
really hard to guess without the sheet but make sure it isn't the 'print area' setting. Go to Page Layout -> Print Area -> Clear Print Area.
If that isn't it, can you send a copy of the workbook (without personal/confidential info)?
Highlighted

@mtarler  Thank you so much, you’ve solved my problem and are now my hero! I’ve no idea how the issue happened as I’ve been using it for three years without any problems.

Highlighted
so glad that helped