Forum Discussion

Anne1305's avatar
Anne1305
Copper Contributor
Nov 19, 2020

Spreadsheet disappears from print preview

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?

excel

3 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Nov 19, 2020
    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)?
    • Anne1305's avatar
      Anne1305
      Copper Contributor
      Nov 19, 2020

      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.

Resources