Help
My problem is to retain all FORMULAS on a Spreadsheet file when Save As to any other location, particularly to CD discs. Save easily, but without a single formula, and there are in excess of a hundered of them. At my inexperience level I avoid anything drastic such as reinstalling Office or whatever. The method I have used successfully is: 1. Highlight any cell with a formula.2. Go to any empty cell and Edit/Copy.3. Right click/select Paste Special.4. Click Formulas.5. Click Escape twice.6. Click keyboard Delete to empty that cell. But now all is lost by inability to use the Paste Special grayed out item. I do hope one of you experts can help with this. And if, in addition, you have another means of retaining spreadsheet formulas when saving elsewhere so much the better. Thanks!
Page 1 of 1
How To Retain Spreadsheet Formulas When Saving To Disc? WinXP IE7 Copy/Paste difficulty
#1
- Member
-
- Group: Members
- Posts: 21
- Joined: 05-July 05
Posted 14 October 2007 - 05:57 PM
My problem is to retain all FORMULAS on a Spreadsheet file when Save As to any other location, particularly to CD discs. Save easily, but without a single formula, and there are in excess of a hundered of them. At my inexperience level I avoid anything drastic such as reinstalling Office or whatever. The method I have used successfully is: 1. Highlight any cell with a formula.2. Go to any empty cell and Edit/Copy.3. Right click/select Paste Special.4. Click Formulas.5. Click Escape twice.6. Click keyboard Delete to empty that cell. But now all is lost by inability to use the Paste Special grayed out item. I do hope one of you experts can help with this. And if, in addition, you have another means of retaining spreadsheet formulas when saving elsewhere so much the better. Thanks!
Back to top
#2
- Lord Spam Magnet
-
- Group: Site Admin
- Posts: 18,567
- Joined: 06-May 04
- Gender:Male
- Location:SW Louisiana
Posted 15 October 2007 - 08:27 AM
If you want to give Firefox a try, here's an extension that might do what you need:
Table2Clipboard
Table2Clipboard
Quote
Mozilla applications allow to select rows and columns from a table simply pressing Control key and picking rows/columns with left mouse button.
The selection can be copied to clipboard but the original table disposition is lost making ugly results when you paste the text on data sheet applications (eg excel).
If you want to paste data in Microsoft Excel on OpenOffice Calc with correct disposition simply use Table2Clipboard.
The selection can be copied to clipboard but the original table disposition is lost making ugly results when you paste the text on data sheet applications (eg excel).
If you want to paste data in Microsoft Excel on OpenOffice Calc with correct disposition simply use Table2Clipboard.
MOBO: GIGABYTE GA-MA790X-UD4P, CPU: Phenom II X4 955 Deneb BE, HS/F: CoolerMaster V8, RAM: 2 x 1G Kingston HyperX DDR2 800, GPU: eVGA GeForce 9800 GTX+, PSU: Antec TruePower Modular 750W, Soundcard: Asus Xonar D1, Case: CoolerMaster COSMOS 1000, Storage: Internal - 2 x Seagate 250GB SATA, 2 x WD 1TB SATA; External - Seagate 500GB USB, WD 640GB eSATA, 3 x WD 1TB eSATA
Become a BleepingComputer fan: Facebook
Become a BleepingComputer fan: Facebook
Share this topic:
Page 1 of 1