Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 05, 03:18 PM
pbrookstx
 
Posts: n/a
Default Excel - turn a page number in a header from horizontal to vertical

Excel in office 2003
When printing charts that are horizontal we would like to continue our
paging scheme but on a vertical mode. The only way to print a page number in
excel is in a header or footer. But within the header, how can the number be
turned?

  #2   Report Post  
Old June 4th 05, 01:01 AM
John
 
Posts: n/a
Default

I had the same question. However, I was not able to figure out any way to do
it. So, I just tested the following VBA code to add a WordArt shape to all
charts. It rotates the text 90 degrees and places it in the lower left
corner. Since it names the shape it is easy to get back to it if need to
renumber the pages. I just delete it if it already exists and create a new
one.

It is pretty dumb, not including the the total number of pages. I set the
initial page number to 10.

A similar method could be used to add your own headers and footers anywhere
and with anything you wanted in them. Make sure to set the page margins
small to allow the added shapes to approach the edges of the page.

Good luck,
John

"pbrookstx" wrote:

Excel in office 2003
When printing charts that are horizontal we would like to continue our
paging scheme but on a vertical mode. The only way to print a page number in
excel is in a header or footer. But within the header, how can the number be
turned?



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
how do i turn off formulas in excel vachss Excel Discussion (Misc queries) 4 April 5th 05 01:43 AM
export excel to Front Page judithbear Excel Discussion (Misc queries) 0 March 27th 05 12:17 AM
Microsoft Excel tries to load front page on opening Excel and Front Page Excel Discussion (Misc queries) 1 March 21st 05 09:51 PM
In Excel 2000, can I print the header on the first page only? gwh Excel Worksheet Functions 1 January 14th 05 10:56 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 11:49 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017