|
Forum home »
Delegate support and help forum »
Microsoft Excel Training and help » How to save a data file mutiple sheet togather without formulla
How to save a data file mutiple sheet togather without formulla
The UK's most regular instructor-led training courses.
Training information: excel microsoft training
· Excel training london
· Microsoft Excel Training UK
See also
· excel-courses-london
· excel courses in london
· excel microsoft training  Resolved · Low Priority · Version Standard
How to save a data file mutiple sheet togather without formulla
 by - delegate Junaid [4 posts] (2008 Feb 28 Thu, 22:26)  Reply
how to save a data file multiple sheet together without formula just values in excel
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
RE: how to save a data file mutiple sheet togather without formu
by - delegate Junaid [4 posts] (2008 Mar 9 Sun, 22:53) Reply
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
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
Related articles
· Advanced Excel Training - takes you to the next level
· Improve Performance Of Your Excel Macros
· Tips for Transitioning to Excel 2007
· Customized Financial Excel Courses in London
· Basic Excel Training
Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses. | Excel tip:
Create a hyperlink navigation sheet
In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.
Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.
To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.
View all Excel hints and tips |
| 
Add to favourites
Printable version
Bookmark this page
Excel Intermediate 1 day course
[73 posts] (2008 Mar 8 Sat, 19:08) 
