Article View: comp.apps.spreadsheets
Article #119Re: Help! Paste Special in Excel (v2.2, Mac)
From: halsema pb 64533
Date: Tue, 25 Aug 1992 18:31
Date: Tue, 25 Aug 1992 18:31
33 lines
2165 bytes
2165 bytes
redgers@ee.ic.ac.uk (Adrian Redgers) writes:
: In MS Excel 2.2 for the Macintosh, after you've done a calculation and
: you want the the results - *not* the formulae - how do you get at them?
:
: For example I might want to take the results and "Save As..." an MS
: Word document. Currently I get the formulae :-{
Try doing "Save As..." and setting the file type to text (use the options
button to get at that). This will save the values as tab delimited text.
: In MS Works there is a command called "Paste Special..." (spreadsheet,
: Edit menu). In Excel "Clear..." (Edit menu) looks a bit similar but
: clearing formulae clears the results as well. Grrrr!
"Clear..." is used for just that, clearing fields. "Paste Special..." can
be used to paste the values only (i.e. no formulas) into another worksheet.
This won't help you get into Word, unless you want to:
1) select range of interest
2) copy
3) go to a blank space or new worksheet
4) select "Paste Special..." values
5) copy
6) go to Word and paste
Depending on what you're doing either this approach or the save as
approach will do the job.
---Paul
_______________________________________________________________ _________
Paul Halsema \\ AT&T: (407) 729-3536 | _ _ |
Harris Corp., GASD \\ INTERNET: |_| |_| | |
MS 102-4827 PO Box 94000 \\ phalsema@x102a.ess.harris.com |_/\/\/\|_|
Melbourne, FL 32902 \\ | |_| |_| |
_______________________________________________________________ |_________|
Technical Details
Message-ID:
<1992Aug25.183141.18851@mlb.semi.harris.com>Path:
arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!mlb.semi.harris.com!x102a!phalsemaReferences:
<1992Aug25.115108.22993@cc.ic.ac.uk>Show Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!mlb.semi.harris.com!x102a!phalsema From: phalsema@x102a.ess.harris.com (halsema pb 64533) Subject: Re: Help! Paste Special in Excel (v2.2, Mac) References: <1992Aug25.115108.22993@cc.ic.ac.uk> Date: Tue, 25 Aug 1992 18:31:41 GMT Nntp-Posting-Host: x102a.ess.harris.com X-Newsreader: Tin 1.1 PL4 Organization: Harris ESS, Melbourne, Fla. Sender: news@mlb.semi.harris.com Message-ID: <1992Aug25.183141.18851@mlb.semi.harris.com> Lines: 33