Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DavidBr318
 
Posts: n/a
Default Copying formats - column widths, formats, outlining to worksheets

I very often use worksheets to create a master workbook - it is tedious to
re-create the formating of the master worksheet to each subsequent worksheet
- In one column it may be formated with at date, the next with general
infromation, the next with numbers, various calcuations, each column having
its own specific widths, etc. along with outlining of various cells.
Is there a way I can have Excel copy the formating of a worksheet to other
worksheets

Thanks,
David
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

Copy the master worksheet and on new spread sheet go to edit -paste special
and select formats and then again paste special and select column width

"DavidBr318" wrote in message
...
I very often use worksheets to create a master workbook - it is tedious to
re-create the formating of the master worksheet to each subsequent
worksheet
- In one column it may be formated with at date, the next with general
infromation, the next with numbers, various calcuations, each column
having
its own specific widths, etc. along with outlining of various cells.
Is there a way I can have Excel copy the formating of a worksheet to other
worksheets

Thanks,
David



  #3   Report Post  
Alan
 
Posts: n/a
Default

Highlight the whole of the formatted master worksheet by clicking the top
left hand square above row 1 and to the left of column A, and click the
format painter on the toolbar. Go to the unformatted sheet and click in the
same place,
Regards,
Alan.
"DavidBr318" wrote in message
...
I very often use worksheets to create a master workbook - it is tedious to
re-create the formating of the master worksheet to each subsequent
worksheet
- In one column it may be formated with at date, the next with general
infromation, the next with numbers, various calcuations, each column
having
its own specific widths, etc. along with outlining of various cells.
Is there a way I can have Excel copy the formating of a worksheet to other
worksheets

Thanks,
David



  #4   Report Post  
DavidBr318
 
Posts: n/a
Default

Alan - Thank you - it worked perfectly .... what a time saver.

David

"Alan" wrote:

Highlight the whole of the formatted master worksheet by clicking the top
left hand square above row 1 and to the left of column A, and click the
format painter on the toolbar. Go to the unformatted sheet and click in the
same place,
Regards,
Alan.
"DavidBr318" wrote in message
...
I very often use worksheets to create a master workbook - it is tedious to
re-create the formating of the master worksheet to each subsequent
worksheet
- In one column it may be formated with at date, the next with general
infromation, the next with numbers, various calcuations, each column
having
its own specific widths, etc. along with outlining of various cells.
Is there a way I can have Excel copy the formating of a worksheet to other
worksheets

Thanks,
David




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 87
Default Copying formats - column widths, formats, outlining to workshe

Thanks Heaps Alan, that worked a treat...so much better now :-)

"Alan" wrote:

Highlight the whole of the formatted master worksheet by clicking the top
left hand square above row 1 and to the left of column A, and click the
format painter on the toolbar. Go to the unformatted sheet and click in the
same place,
Regards,
Alan.
"DavidBr318" wrote in message
...
I very often use worksheets to create a master workbook - it is tedious to
re-create the formating of the master worksheet to each subsequent
worksheet
- In one column it may be formated with at date, the next with general
infromation, the next with numbers, various calcuations, each column
having
its own specific widths, etc. along with outlining of various cells.
Is there a way I can have Excel copy the formating of a worksheet to other
worksheets

Thanks,
David




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
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
Counting Rows/Columns for Copying Formulas SamDev Excel Discussion (Misc queries) 0 June 24th 05 04:13 AM
Copying the contents of a column into a chart Richard Excel Worksheet Functions 1 November 16th 04 03:39 PM
Searching a column and copying rows davidshin Excel Worksheet Functions 1 November 10th 04 08:29 PM
copying conditional formats to a whole column Markitos Excel Worksheet Functions 0 November 2nd 04 12:23 AM


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