PLEASE! How do i cut and paste sheet5 with out loosing all the values on it (that were formulated fr

  • Thread starter Thread starter Earl Kiosterud
  • Start date Start date
E

Earl Kiosterud

Kinky,

Copy/Paste instead of Cut/Paste. Then if necessary delete (Delete key, not
Edit - Delete or Right-Click - Delete) the originals.
 
Charles,

I think you want to use Paste Special instead of Paste. That way, you will
not lose the results of the formulas.

On Sheet 5, choose your data and select Edit menu, then choose Copy.

On your new spreadsheet, choose the proper cell, then select the Edit menu
and choose Paste Special. then choose "Values" and press OK.

Is that the result you were looking for?
 
Dear All

I Hope you can help me please, i have made up my price list for my business
on excel .
sheets 1 to 3 are materials and they are all added up together on sheet
4.(sheet 4 giving me my final materials cost)

now sheet 5 is my costs plus profit. this is all fine now my problem is.

i would like to cut and paste sheet 5 on to an other folder so i can email
it to clients.

But when i do this most of the values disappear as i have broken the formlas
to give those values,

so can some please help me and tell me how i can, cut and paste so i have
just my price list with all the values on it.

cheers i will be very greatful for any suggestions.

Best wishes

Charles
 
H Earl

thank you for your advise i have tried this and i keep loosing values, would
it be rude if me to ask if i could email you or post the folder and for you
to take a look please

cheers charles
 
Caesar,

You can email it if you wish. The highly encrypted email address is below.

I'm not sure what "paste to another folder" means. What are you pasting
into? If an Excel workbook sheet, have you tried Paste-Special - Values?
 
Back
Top