Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Automatic Row and column sizing

I have created a form that I would like to easily add more sheets that are
exactly like the main form, so that I can quickly adjust the form to fit the
size of job I am doing.

The first page has an area for job info, followed by 9 seperate tables for
data entry and calculating results. The second page has 12 of the same
tables. I took quite a bit of time sizing and formatting the tables to fit on
the page and appear nice.

My issue is, when I have a job that requires more than 21 tables, I am
unable to quickly copy and paste the second page to the third and any other
subsequent pages I need. I can copy and paste, but then I have to resize each
page, rows and columns, individually to match the appearance of page two.

Is there a way to copy everything, cell formatting, colors, cell sizing,
etc., onto following pages so I don't have to individually resize everything?

Thanks in advance for any help you can provide.
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
plotarea restore automatic sizing Werner News Charts and Charting in Excel 2 September 26th 11 04:01 PM
Pivot Table column sizing shaunap Excel Discussion (Misc queries) 0 July 14th 08 10:09 PM
automatic picture sizing? Alex Excel Discussion (Misc queries) 1 July 9th 08 01:17 PM
Column Auto Sizing oranskeer Excel Discussion (Misc queries) 3 December 15th 06 03:24 PM
sizing different cells in same column cmkogos2 Excel Discussion (Misc queries) 2 May 2nd 05 09:48 PM


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