| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying all formats from worksheet to worksheet
How do I copy the header row from one tabbed worksheet such that it will
paste all formats, ESPECIALLY CELL WIDTH, to each tabbed worksheet? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying all formats from worksheet to worksheet
You dont say which version you are using but Excel 2k+ has an option on Paste
Special to Paste Column Widths. Alternatively if you copy the entire sheet by clicking the box above row 1 and to the left of Column A it will paste everything 'as is' HTH Sheila "Gary" wrote: How do I copy the header row from one tabbed worksheet such that it will paste all formats, ESPECIALLY CELL WIDTH, to each tabbed worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formats for emailing worksheet | Excel Discussion (Misc queries) | |||
| Looking to copy a worksheet with all formats and formulas without coping inputed data | Excel Discussion (Misc queries) | |||
| copying excel chart formats from one chart to another | Excel Discussion (Misc queries) | |||
| Can I copy a worksheet with its page setup and print formats? | Excel Discussion (Misc queries) | |||
| copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
