Thread: How do I copy spreadsheet data as shown to another spreadsheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
  
Posts: 268
Default 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?
Reply With QuoteReply With Quote