Hi,
I have made up a spreadsheet on Excel and I have added a dotted line down the middle to seperate 2 different parts. However, when I have added the line, it has increased my number of pages from 1 of 1 to 1 of 1726.
I know I can overcome this when printing by just selecting print page 1 of 1, but is there a simple way I can delete the 1725 extra pages from my sheet?
Thanks in advance
Last edited by Paul_F; 09-02-2009 at 12:11 PM.
Did you add a dotted line down the ENTIRE sheet? Shorten the line so it is less long than page 1.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Sorted....Thanks!!
I wasn't sure if it would clear the other pages if I did that, but it has
Why not set the cell borders to a dotted line type?
You could even use Conditional Formatting to apply the line format based on data in the cells and somwhat automate the process by extending line only as far as the data exist.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks