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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
I'm sorry that should be "Select A1 in the new worksheet and paste..."
 
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
 
You must log in or register to reply here.

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

Macro to copy value in field and insert it into filter 2
Problem Pasting Data 2
2 dimensional date sort 1
Copying formula vertically, to pick up horizontal cell values 3
Splitting data from one spreadsheet into multiple spreadsheets 2
Alt codes 4
Lookups - how to obtain data from a master spreadsheet into another 5
Return Value from a Range (depends on input to determind month) 2

Back
Top