Copy Excel sheets

G

Guest

I have excels sheets for 2005 that I would like to keep the format and
formula and move them to 2006. I would like to copy without having to setup
all the excel sheets again for the new year. Have a workbook that would have
approx. 45 sheets with formulas and etc. I would like to keep formulas and
format. When I copy I get all values formula and format. I try to clear
contents. It clears all information.
 
B

Bernie Deitrick

Karen,

On each sheet, select all the cells and use Edit / Go To... Special Constants and pick your
type (numbers, likely). Exclude text to leave any labels alone. Then press Delete, and your old
entered data should be cleared, leaving formulas, labels, and formatting.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Merge Multiple workbook sheets into one workbook 0
clearing data but retaining formulas 10
Macro to copy value in field and insert it into filter 2
Excel shortcut options 0
Copy sheet 2
Copy Sheet to new Sheet and clear cells on original sheets 7
How do I reference the same cell in all previous sheets? 3

Top