How to save a data file mutiple sheet togather without formulla

Resolved · Low Priority · Version Standard

Thu 28 Feb 2008, 22:26 Delegate Junaid said...

Junaid has attended:
Excel Advanced course

How to save a data file mutiple sheet togather without formulla

how to save a data file multiple sheet together without formula just values in excel

Sat 8 Mar 2008, 19:08 Trainer Mara said...

RE: how to save a data file mutiple sheet togather without formu

Hello Junaid,
I hope you enjoyed your Excel training session with us.

In response to your question, I'm not sure I quite understand exactly what you are asking. Can you elaborate what is it you are looking to do?

Regards,
Mara
Microsoft Office Specialist Master Trainer

Sun 9 Mar 2008, 22:53 Delegate Junaid said...

RE: how to save a data file mutiple sheet togather without formu

Hi Mara

What i meant in my question is how to save a file which has a multiple excel sheet all linked and have data through advance formula's. I want to save save this file with all the data but no formula. i mean is there a way to save the whole file as values in which the file format remain the same.

Regards

Junaid

Mon 10 Mar 2008, 00:48 Trainer Mara said...

RE: how to save a data file mutiple sheet togather without formu

Hi Junaid,
Thank you for your reply. I think I understand what you are asking. You would like to keep the values in a worksheet, but not keep the links to other sources. Is that correct?

If so, there is a simple way to do this. Simply copy the entire worksheet (you can click on the grey box between column A and row 1), and then right click, choose Paste Special, then choose "Values." This will keep only the values in the cells, but will remove all formulas. Of course, if you decide you only want to keep values in some cells, and keep the formulas in others, copy only the individual cells where you want the values, and then paste special / paste values. You can then save your worksheet/workbook as normal.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips