A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Can't change print area



 
 
Thread Tools Display Modes
  #1  
Old October 19th 07, 06:34 PM posted to microsoft.public.excel.misc
Phil James
external usenet poster
 
Posts: 3
Default 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


Ads
  #2  
Old October 19th 07, 07:33 PM posted to microsoft.public.excel.misc
JP[_3_]
external usenet poster
 
Posts: 168
Default 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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
File, print area, clear area, is not working cblind New Users to Excel 2 September 12th 07 04:51 PM
set area in excel not giving me option to set print area? J Littlebear Excel Discussion (Misc queries) 3 May 30th 07 12:49 AM
print area across the freeze panes area tom Excel Worksheet Functions 2 January 6th 07 06:23 PM
I want to change the selected print area but it will not allow me jeclss Excel Worksheet Functions 1 December 29th 05 12:41 AM
How do you turn off a print area for a page? (no print area) Grunen Excel Discussion (Misc queries) 4 October 8th 05 07:46 PM


All times are GMT +1. The time now is 02:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.