Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default setting up a4 demarcation lines or markers in a worksheet

hi all,

xp pro, office 2003 pro,

i don't know whether i wanted is possible. i have tried to search this group
as well as the general 'google' approach but could not find an answer. i
wanted to set-up a marker of some sort e.g. demarcation bold lines the size
of an a4 landscape page within the worksheet that i am working on covering x
rows and y columns to remind me at all time to work within these rows &
columns area.

the motive, in my mind, eventually when i do print out the worksheet
containing my work, it will be exactly within an a4 landscaped page. what
usually happened in the past was when i do print i discovered that i have
exceeded the a4 and only by trial and error thereafter managed to get my work
into an a4 sized page on printing.

i hope it all make sense - what i wanted to achieve. thank you all for your
advise and help.

jes
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 209
Default setting up a4 demarcation lines or markers in a worksheet

I don't think you can get a big, bold marker but...

First, verify that you have your Page Breaks set.
From the top menu, select TOOLS then OPTIONS then the VIEW tab.
In the 'Window Options' section of the VIEW tab, make sure that the 'Page
Breaks' option is checked.

Next, from the top menu, select FILE then PRINT PREVIEW. When you CLOSE out
of this window, you should now see black hypenated lines at your page breaks.
This should solve your issue of staying inside the lines :O.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"xppuser" wrote:

hi all,

xp pro, office 2003 pro,

i don't know whether i wanted is possible. i have tried to search this group
as well as the general 'google' approach but could not find an answer. i
wanted to set-up a marker of some sort e.g. demarcation bold lines the size
of an a4 landscape page within the worksheet that i am working on covering x
rows and y columns to remind me at all time to work within these rows &
columns area.

the motive, in my mind, eventually when i do print out the worksheet
containing my work, it will be exactly within an a4 landscaped page. what
usually happened in the past was when i do print i discovered that i have
exceeded the a4 and only by trial and error thereafter managed to get my work
into an a4 sized page on printing.

i hope it all make sense - what i wanted to achieve. thank you all for your
advise and help.

jes

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
Setting up a worksheet Setting a Mileage Expense Report Excel Worksheet Functions 1 November 14th 07 07:44 PM
Setting page length to 60 lines? (How do?) Chet Excel Discussion (Misc queries) 7 July 30th 07 03:16 PM
Setting up a worksheet for LOG LOG analysis David Stamm Excel Worksheet Functions 1 September 14th 06 07:39 PM
Too many markers on line chart makes it a thick line and individual markers cannot be seen denzel Excel Discussion (Misc queries) 2 August 2nd 06 04:06 PM
Novice needs help setting up a worksheet KC New Users to Excel 3 June 23rd 06 03:59 PM


All times are GMT +1. The time now is 12:42 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"