Forum home » Delegate support and help forum » Microsoft Excel Training and help » Saving spreadsheets without formulae
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Saving spreadsheets without formulae
Resolved · Medium Priority · Version 2003
Reply Tue 16 Dec 2008, 15:04Delegate Sarah said...
Sarah has attended:
Project Intro Intermediate course
Saving spreadsheets without formulae
how to you save an entire workbook/spreadsheet without formulae? And with the formulae shown to external links but without the links to minimise problems with corruption.
For upcoming training course dates see: Pricing & availability
RE: Saving spreadsheets without formulae
Hi Sarah
Thank you for your question:
In response;
You have two questions here and to my knowledge they will not operate simultaneously, lets just take the first one, save worksheet without formulae;
Select your entire worksheet; little button between A and 1 top left of worksheet will do this or keyboard command CTRL+A.
Keyboard CTRL+C to copy then to Menu command Edit, choose the Paste Special Option and choose Values from the dialog box. All your formulae will be changed to Values including all links to other worksheets/books.
To display your formula in a workbook choose the keyboard command CTRL+Pipe key (above Tab, Below Esc and to the left of 1) this is a toggle switch so it will switch on or off as required.
I hope that has helped, Pete
|