Excel

  • Thread starter Thread starter mmc
  • Start date Start date
M

mmc

i want to copy jus the data not the whole invoice sheet any1 can help me
plzzzzzzzzzzzz

thnx
 
You could name the range that contains the data, then select and copy
that range when required.

To name the range:
Select all the cells that contain the data you want to copy
Click in the Name Box (to the left of the formula bar)
Type a one-word name for the range, e.g. InvoiceData
Press the Enter key

To select the range for copying:
Click the dropdown arrow to the right of the Name Box
Select the range name
 
Back
Top