Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 30
Default Unlocking The Positioning Grid And Printing Question

Hello,

Thanks for previous help.
Using Excel 97.

Two questions, please.

a. Something new; never had showup before.

On the page that has the data for a chart, I now have blue dashed lines
showing, I guess, what the actual page boundaries would be if I printed this
data.

How do I get rid of this, and also the light grey "Page No.s" that also show
up ?

b. On my chart, I have some text boxes.
They seem to be locked to a specific grid spacing limiting the exact spots I
would like them to be.

How can I remove this locking, and move them, smoothly, to "anywhere I'd
like to put them ?

Much thanks,
Bob


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,856
Default Unlocking The Positioning Grid And Printing Question

You seem to be viewing the sheet in Page-break mode. Click on View
then select Normal.

Hope this helps.

Pete

On Nov 22, 2:23 pm, "Robert11" wrote:
Hello,

Thanks for previous help.
Using Excel 97.

Two questions, please.

a. Something new; never had showup before.

On the page that has the data for a chart, I now have blue dashed lines
showing, I guess, what the actual page boundaries would be if I printed this
data.

How do I get rid of this, and also the light grey "Page No.s" that also show
up ?

b. On my chart, I have some text boxes.
They seem to be locked to a specific grid spacing limiting the exact spots I
would like them to be.

How can I remove this locking, and move them, smoothly, to "anywhere I'd
like to put them ?

Much thanks,
Bob


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 860
Default Unlocking The Positioning Grid And Printing Question

Hi Bob,

For the second part of your question,

At the bottom left of your screen on the drawing toolbar
click on Draw point to Snap and click on Snap to Grid.

If the drawing toolbar is not showing you will need to
bring it up from ViewToolbarsDrawing.

HTH
Martin


"Robert11" wrote in message
. ..
Hello,

Thanks for previous help.
Using Excel 97.

Two questions, please.

a. Something new; never had showup before.

On the page that has the data for a chart, I now have blue dashed lines
showing, I guess, what the actual page boundaries would be if I printed
this data.

How do I get rid of this, and also the light grey "Page No.s" that also
show up ?

b. On my chart, I have some text boxes.
They seem to be locked to a specific grid spacing limiting the exact spots
I would like them to be.

How can I remove this locking, and move them, smoothly, to "anywhere I'd
like to put them ?

Much thanks,
Bob



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 30
Default From OP: Unlocking The Positioning Grid And Printing Question

Hi,

Just a quick thanks for help.

That did it.

Thanks,
Bob


-----------------------
"Robert11" wrote in message
. ..
Hello,

Thanks for previous help.
Using Excel 97.

Two questions, please.

a. Something new; never had showup before.

On the page that has the data for a chart, I now have blue dashed lines
showing, I guess, what the actual page boundaries would be if I printed
this data.

How do I get rid of this, and also the light grey "Page No.s" that also
show up ?

b. On my chart, I have some text boxes.
They seem to be locked to a specific grid spacing limiting the exact spots
I would like them to be.

How can I remove this locking, and move them, smoothly, to "anywhere I'd
like to put them ?

Much thanks,
Bob



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unlocking A Grid For Moving Text Around In A Chart: How, Please ? Robert11 Charts and Charting in Excel 1 May 3rd 07 05:45 PM
text box positioning, printing and between loads Pauline Charts and Charting in Excel 1 September 27th 06 11:34 PM
Printing a Grid With Nothing in the Cells TomBrooklyn Excel Discussion (Misc queries) 3 June 10th 06 06:55 AM
Grid printing for worksheets wanda Excel Discussion (Misc queries) 1 May 25th 06 08:41 PM
printing grid lines when grid lines is checked fergos Setting up and Configuration of Excel 1 October 4th 05 02:55 AM


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

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

About Us

"It's about Microsoft Excel"