Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting up a worksheet | Excel Worksheet Functions | |||
Setting page length to 60 lines? (How do?) | Excel Discussion (Misc queries) | |||
Setting up a worksheet for LOG LOG analysis | Excel Worksheet Functions | |||
Too many markers on line chart makes it a thick line and individual markers cannot be seen | Excel Discussion (Misc queries) | |||
Novice needs help setting up a worksheet | New Users to Excel |