Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying and pasting table info and cell formating in one hit
G'day, I am having a 'fro mo' (frustrating moment) in trying to copy and
paste a table I have set up in the first sheet of a workbook with specific formatting i.e column widths, row heights and column headings... and pasting this table template into other worksheets in one hit. I have copied and pasted the table into another worksheet then used 'paste special' for the 'Column Widths'... but I don't know how to paste the formatting of the row heights (there is not an option). Anyhow, is there a way to copy and paste the whole table exactly 'as is' in the first worksheet into another worksheet in one hit? Thanks who can help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying and pasting table info and cell formating in one hit
Is the table the only thing on the worksheet? or nearly so? It might be much
easier and less frustrating to copy the entire worksheet. Right click on the sheet tab and choose Move or Copy... If you're creating a new workbook using that sheet, click the drop list under To book: and choose (new book). If you want to copy to another workbook, make sure you have it open so it appears on the list and choose it instead. Make sure you click Create a copy or you will be moving the sheet from the first to the second workbook. When you copy the worksheet, you not only keep the proper column and row formatting, but you also get to keep the page setup... have fun! "Sam at JWP" wrote: G'day, I am having a 'fro mo' (frustrating moment) in trying to copy and paste a table I have set up in the first sheet of a workbook with specific formatting i.e column widths, row heights and column headings... and pasting this table template into other worksheets in one hit. I have copied and pasted the table into another worksheet then used 'paste special' for the 'Column Widths'... but I don't know how to paste the formatting of the row heights (there is not an option). Anyhow, is there a way to copy and paste the whole table exactly 'as is' in the first worksheet into another worksheet in one hit? Thanks who can help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying and pasting table info and cell formating in one hit
Thanks BoniM... worked like a charm... so easy and simple, yet eluded me for
so long!! I can now be at peace! Thank you. "BoniM" wrote: Is the table the only thing on the worksheet? or nearly so? It might be much easier and less frustrating to copy the entire worksheet. Right click on the sheet tab and choose Move or Copy... If you're creating a new workbook using that sheet, click the drop list under To book: and choose (new book). If you want to copy to another workbook, make sure you have it open so it appears on the list and choose it instead. Make sure you click Create a copy or you will be moving the sheet from the first to the second workbook. When you copy the worksheet, you not only keep the proper column and row formatting, but you also get to keep the page setup... have fun! "Sam at JWP" wrote: G'day, I am having a 'fro mo' (frustrating moment) in trying to copy and paste a table I have set up in the first sheet of a workbook with specific formatting i.e column widths, row heights and column headings... and pasting this table template into other worksheets in one hit. I have copied and pasted the table into another worksheet then used 'paste special' for the 'Column Widths'... but I don't know how to paste the formatting of the row heights (there is not an option). Anyhow, is there a way to copy and paste the whole table exactly 'as is' in the first worksheet into another worksheet in one hit? Thanks who can help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying and pasting table info and cell formating in one hit
Glad I could help, thanks for letting me know it worked for you.
"Sam at JWP" wrote: Thanks BoniM... worked like a charm... so easy and simple, yet eluded me for so long!! I can now be at peace! Thank you. "BoniM" wrote: Is the table the only thing on the worksheet? or nearly so? It might be much easier and less frustrating to copy the entire worksheet. Right click on the sheet tab and choose Move or Copy... If you're creating a new workbook using that sheet, click the drop list under To book: and choose (new book). If you want to copy to another workbook, make sure you have it open so it appears on the list and choose it instead. Make sure you click Create a copy or you will be moving the sheet from the first to the second workbook. When you copy the worksheet, you not only keep the proper column and row formatting, but you also get to keep the page setup... have fun! "Sam at JWP" wrote: G'day, I am having a 'fro mo' (frustrating moment) in trying to copy and paste a table I have set up in the first sheet of a workbook with specific formatting i.e column widths, row heights and column headings... and pasting this table template into other worksheets in one hit. I have copied and pasted the table into another worksheet then used 'paste special' for the 'Column Widths'... but I don't know how to paste the formatting of the row heights (there is not an option). Anyhow, is there a way to copy and paste the whole table exactly 'as is' in the first worksheet into another worksheet in one hit? Thanks who can help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting Word table info into Excel | Excel Discussion (Misc queries) | |||
Info pasting into one cell?? | Excel Discussion (Misc queries) | |||
copying table with cond.formating using value and resulting color | Excel Discussion (Misc queries) | |||
pasting a range of info based on the value in a particular cell | Excel Discussion (Misc queries) | |||
Copying & Pasting from Pivot Table | Excel Discussion (Misc queries) |