Forum Discussion
I am out of practice. I need help saving print area in Excel.
I am failing to clear an existing choice of print area and so I am prevented from entering my choice.
Here is an illustration of my problem. I want to print only lines 1-30 of a large spreadsheet. So, I marked out these 30 rows and I used the “set print area” instruction. When I asked for “print”, only rows 1-20 appeared. So, I used the “clear print area” instruction, and marked out rows 1-30 as before, reused the “set print area” instruction and asked for “print” a second time. But again only rows 1-20 appeared, so the “clear print area” instruction had not worked.
Trevor
Is that for any file or for some specific one? If for any perhaps you could share it with print area set.
- Thanks, Sergei. The problem is solved. I had failed to save the print option I had chosen.
Td1932 , great to know, thank you for the feedback