How can I copy all data from one spreadsheet and paste those valu.

[sunn(O))creeper]

I am working on a 12-month 2005 budget and I have all of the base-data
entered into the January sheet. How can I copy the entire data and paste it
into the clean Feb sheet?

 

[thelightners]

Use the Table select button (top Left by A1) . Use Copy (under Edit)
Select A1, paste the data if you want the formulas or use paste specia
if you want the data or formating. Play around with it a little

 

[thelightners]

I'm sorry that should be "Select A1 in the new worksheet and paste..."

 

[Arvi Laanemets]

Hi

Let's assume you have January sheet only (when you have an empty February
sheet, delete it).

Right-click on January sheet's tab at bottom of Excel window and select
'Move or Copy'.
Check 'Create a copy' and press OK.
Rename new sheet as 'February'


Arvi Laanemets