Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Page numbering dilemma

Does anybody know how to print a table that's in landscape format, but
have the page numbering in the bottom right corner as if the page were
portrait? I've tried dozens of things and spent hours trying to figure
this out but have yet to find an acceptable solution.

Much thanks in advance!

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 213
Default Page numbering dilemma

Does anybody know how to print a table that's in landscape format, but
have the page numbering in the bottom right corner as if the page were
portrait? I've tried dozens of things and spent hours trying to figure
this out but have yet to find an acceptable solution.


You might think this silly, but instead of rotating the page number you
could make all the cells of the sheet sideways using
Format Cells Alignment Orientation
and rotating 90 degrees.

Then the header/footer would be perpendicular to the data.

This makes the data harder to work with. Still, the appearance is what you
want.
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
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
start page numbering after table of contents J. Williams Excel Discussion (Misc queries) 1 February 4th 06 12:07 PM
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM


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

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

About Us

"It's about Microsoft Excel"