Search : in
By :

Copy Excel 07 sheet to other & keep formulas?

Last answer on Aug 22, 2009 6:55:34 pm BST Linda, on Aug 21, 2009 3:16:55 pm BST 
 Report this message to moderators

Hello,
Is it possible to copy an Excel 07 spreadsheet to another window spreadsheet (not another tab but completely different spreadsheet) and keep the formulas in tact?

I can keep the formatting but the formulas and calculations always disappear.

Configuration: Windows XP
Firefox 3.0.12

Best answers for « copy Excel 07 sheet to other & keep formulas? » in :
[Excel]changing cell formula to text Show [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Copying data from one Excel sheet to another. Show
Excel Formulas Show
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
How to convert a numeric value into english Word? ShowHow to convert a numeric value into english Word? To convert a numeric value into eng. Word, here is the formula you will need This is a post from the forum, thanks to rajput391 Below code enter in excel sheet: 1. Press Alt+F11 >...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

venkat1926, on Aug 22, 2009 1:39:18 am BST

Quote
not another tab but completely different spreadshee
unquote
You mean to a different workbooks(file).

keep the file to which you want the sheet is to be copied, open

right click the sheet stab. click "move or copy"
in the move or copy window check "create a copy" at the bottom
go the to the arrow at the top next to "to book" window.
your other file name will be there. click it
you will be asked where do you want to copy after sheet1 etc or at the end
choose.
and click ok

   
Reply to venkat1926

2

 lvoss, on Aug 22, 2009 6:55:34 pm BST

Thank you for your reply. I was able to get it to work.

   
Reply to lvoss
Ask your question Reply
They need your help