LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan
 
Posts: n/a
Default Copying from one spreadsheet to another - formulas don't come alon

In Office 2000.

I have a spreadsheet, and I open another instance of Excel. In the first
spreadsheet I select some rows and columns and copy them. I then paste them
in the second spreadsheet.

The values copy, but the format and formulas do not.

Paste - Special gives me options to paste in the range of cells as an image.

So how do I copy the formulas from one spreadsheet to another?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying filtered data to another Excel Spreadsheet [email protected] Excel Discussion (Misc queries) 3 January 23rd 06 10:01 PM
Copying formulas to a different file without path in the formula? P3SAB$ Excel Worksheet Functions 1 January 5th 06 08:51 PM
Update all formulas on spreadsheet - Apr05! to May05! ~Valerie Excel Discussion (Misc queries) 2 June 23rd 05 11:04 PM
Copying A Spreadsheet sparklydaisy Excel Discussion (Misc queries) 4 June 22nd 05 04:26 PM
Copying Formulas sccspires Excel Worksheet Functions 1 June 10th 05 01:33 AM


All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"