How do I copy spreadsheet data as shown to another spreadsheet?
How can I copy data from one Excel spreadsheet to another without losing the
formulas, number formats, colors and column/row widths and heights? |
How do I copy spreadsheet data as shown to another spreadsheet?
<Ctrl<C and <Ctrl<V will take it across as is, except for row heights and
column widths. After <Ctrl<V, right click in the selection, click on Paste Special, and click column widths to set column widths. "trainer07" wrote: How can I copy data from one Excel spreadsheet to another without losing the formulas, number formats, colors and column/row widths and heights? |
How do I copy spreadsheet data as shown to another spreadsheet?
Użytkownik "trainer07" napisał w wiadomości ... How can I copy data from one Excel spreadsheet to another without losing the formulas, number formats, colors and column/row widths and heights? right click on sheet tag and choose copy to another file./ new file mcg |
All times are GMT +1. The time now is 11:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com