ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't change print area (https://www.excelbanter.com/excel-discussion-misc-queries/162798-cant-change-print-area.html)

Phil James

Can't change print area
 

On one spreadsheet I'm unable to change the print area. On the window where
that would be done, the print area doesn't appear; the line in which it
would appear is filled with a light blue bar, and no entry can be made. The
same is true for the lines where one would normally enter the columns to
appear to the left and the rows at the top of all pages.

This is true for this spreadsheet only; all others work fine.

Anybody got any ideas?

Phil James



JP[_3_]

Can't change print area
 
Hello,

Is your worksheet protected?



HTH,
JP

On Oct 19, 1:34 pm, "Phil James" wrote:
On one spreadsheet I'm unable to change the print area. On the window where
that would be done, the print area doesn't appear; the line in which it
would appear is filled with a light blue bar, and no entry can be made. The
same is true for the lines where one would normally enter the columns to
appear to the left and the rows at the top of all pages.

This is true for this spreadsheet only; all others work fine.

Anybody got any ideas?

Phil James





All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com