| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying Formats between workbooks and worksheets
I have spent a reasonable amount of time setting up a spreadsheet with a
particular format. I have changed column widths, row heights and added some colours to certain cells. I want to copy the format between workseets and workbooks but when I use the paste function te format deosn't copy. A friend recommended 'paste special' but this doesn't seem to work either, even though I choose to retain all the formatting. Can someone help please. Geoff Cox |
|
#2
|
|||
|
|||
|
So, copying the whole sheet isn't what you need?
http://www.officearticles.com/excel/...ft_excel .htm Alternatively, have you tried using the format painter? While the article describes it in Word, it works exactly the same in Excel: http://www.officearticles.com/misc/f...oft_office.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "geoff_francis_cox" wrote in message ... I have spent a reasonable amount of time setting up a spreadsheet with a particular format. I have changed column widths, row heights and added some colours to certain cells. I want to copy the format between workseets and workbooks but when I use the paste function te format deosn't copy. A friend recommended 'paste special' but this doesn't seem to work either, even though I choose to retain all the formatting. Can someone help please. Geoff Cox |
|
#3
|
|||
|
|||
|
Geoff,
See my reply to tccc1219 on 30/6/05. Henry "geoff_francis_cox" wrote in message ... I have spent a reasonable amount of time setting up a spreadsheet with a particular format. I have changed column widths, row heights and added some colours to certain cells. I want to copy the format between workseets and workbooks but when I use the paste function te format deosn't copy. A friend recommended 'paste special' but this doesn't seem to work either, even though I choose to retain all the formatting. Can someone help please. Geoff Cox |
|
#4
|
|||
|
|||
|
"Henry" wrote in message ... Geoff, See my reply to tccc1219 on 30/6/05. Henry Correction. my reply was on 29/6/05 Henry "geoff_francis_cox" wrote in message ... I have spent a reasonable amount of time setting up a spreadsheet with a particular format. I have changed column widths, row heights and added some colours to certain cells. I want to copy the format between workseets and workbooks but when I use the paste function te format deosn't copy. A friend recommended 'paste special' but this doesn't seem to work either, even though I choose to retain all the formatting. Can someone help please. Geoff Cox |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheets and Workbooks | Excel Discussion (Misc queries) | |||
| Converting worksheets to workbooks. Is there an easy way? | Excel Discussion (Misc queries) | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
| Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
| Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
