Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default adjusting columns at the end of a document

I have created a checklist which contains 3 columns and is 4 pages long. At
the bottom of the last page I would like to add 6 columns that are a
different width from all the ones above. How do I do that?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default adjusting columns at the end of a document


A column in Excel has a constant width. So a different width at the bottom
is not possible. Possible alternatives a
1. using merged cells (sometimes creates problems)
2. using "center across selection"
3. adding your data to the worksheet footer
4. placing a picture of your data at the bottom of sheet.
(the picture can be linked to the data and automatically reflect changes)
5. redesign your worksheet layout.

Helpful posting tips here... http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - check out "Rows to Repeat at Bottom")




"Jimmy M"
wrote in message
I have created a checklist which contains 3 columns and is 4 pages long. At
the bottom of the last page I would like to add 6 columns that are a
different width from all the ones above. How do I do that?
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
Automatically adjusting columns jfg Excel Discussion (Misc queries) 9 May 23rd 07 01:02 AM
adjusting columns in multiple worksheets of workbook with one step carole Excel Discussion (Misc queries) 2 July 8th 06 03:07 AM
Macro / VBA adjusting variable columns PaulW Excel Discussion (Misc queries) 1 April 23rd 06 08:25 AM
Center document titles over several columns Maggie B. Excel Discussion (Misc queries) 1 March 18th 06 07:31 PM
How do you split one document into two columns? joanster00 Excel Worksheet Functions 1 August 30th 05 04:43 PM


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