Forum Discussion
Td1932
Jul 16, 2023Copper Contributor
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.
SergeiBaklan
Jul 16, 2023Diamond Contributor
- Td1932Jul 17, 2023Copper Contributor
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
- SergeiBaklanJul 17, 2023Diamond Contributor
Is that for any file or for some specific one? If for any perhaps you could share it with print area set.
- Td1932Jul 19, 2023Copper ContributorThanks, Sergei. The problem is solved. I had failed to save the print option I had chosen.