Copy Excel 07 sheet to other & keep formulas?
Solved/Closed
Related:
- Copy Excel 07 sheet to other & keep formulas?
- How to screenshot excel sheet - Guide
- Mark sheet in excel - Guide
- Little alchemy cheat sheet - Guide
- Date formula in excel dd/mm/yyyy - Guide
- How to open excel sheet in notepad++ - Guide
4 responses
but while copying to another workbook, it does not keep the formulas, it just copied the values. In my case I want to retain the forumula as well.
Kindly suggest
Kindly suggest
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 21, 2009 at 08:39 PM
Aug 21, 2009 at 08:39 PM
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
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
lvoss
Posts
1
Registration date
Thursday August 20, 2009
Status
Member
Last seen
August 22, 2009
Aug 22, 2009 at 01:55 PM
Aug 22, 2009 at 01:55 PM
Thank you for your reply. I was able to get it to work.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Feb 3, 2012 at 08:16 PM
Feb 3, 2012 at 08:16 PM
"window spreadsheet" what I thought was another excel spreadsheet either in the same file or another file
