Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
Searching a column and copying rows | Excel Worksheet Functions | |||
copying conditional formats to a whole column | Excel Worksheet Functions |