From Sam Raheb:
This routine allows the user to convert the cell references of the formulas within the selected range of cells to any form of absolute reference. This can be useful in situations where you have two or more sheets linked together via formula functions. Keep in mind that you can do a compounded conversion by running this routine multiple times on the same set of cells to achieve the desired results. Convert some or all of the cells to and from A1, $A1, A$1, $A$1, or add or delete the sheet name to and from the formulas. To view all the formulas on a sheet at once, press the Control and keys at the same time. Repeat the keystrokes to toggle back to the previous view.
More Products to Consider
- Take an open-source approach to office productivity.
- Convert PDF files to Microsoft Word format.
- Open, edit, and save files using the new file formats in 2007 v...
- View, navigate, and print PDF files.
- Convert JPG, BMP, TIFF, PNG images to PDF files.
- Convert AutoCAD drawing files to PDF format.
- Get a comprehensive library of 4500 sample business letters and...
- Convert CSV stock data into MetaStock format.
- Prepare any business documents from 6000 professionally written...
- Convert currencies in your Excel files automatically.
- Create and share content with the help of a comprehensive set o...
- Convert files to PDF format and convert PDF files to Word forma...
- Transform PDF documents to Excel documents.
- Create, encrypt, and merge PDF files.
- Convert UTC and local date time into Moon phase, Day of Year, a...
- Save your time importing data from Excel into Access.
- Keep track of how you use your PC.
- Perform various financial calculations from within Excel worksh...
- Render PDF files within applications that support the print fun...
- Convert your Excel .XLS spreadsheets into a rotating and auto r...
- Perform various functions and avoid multiple keystrokes.
- Develop your own custom solutions visualizing various data.
- Turn your SWF files into MP3 format.
- Convert EML and MSG files into various formats.