Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doen't PasteSpecial, Formulas not display formula in cell?
I want to paste the formul's from a cell into another cell. Other
spreadsheet programs allow this for a single cell. I'm aware of paste special , select formula button but the value is displayed. I can make this work by copying the text in a fourmul and preceeding the past in another cell with a ', but this is very cumbersom when I have to do it hundreds of times in a column, and the result is not associative with the source. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doen't PasteSpecial, Formulas not display formula in cell?
PasteSpecial, Formulas is intended to paste ONLY the formulas; that is, it
excludes formatting, comments, validation, etc. If you want to see the formula in another cell, you can paste and then add the ' in front as you described. OR, to see all the formulas, go to the menu bar and select Tools Options, click on the View tab and select Formulas (a shortcut to toggle this option is ctrl+~). "BrianW" wrote: I want to paste the formul's from a cell into another cell. Other spreadsheet programs allow this for a single cell. I'm aware of paste special , select formula button but the value is displayed. I can make this work by copying the text in a fourmul and preceeding the past in another cell with a ', but this is very cumbersom when I have to do it hundreds of times in a column, and the result is not associative with the source. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why doen't PasteSpecial, Formulas not display formula in cell?
Hi Brian,
You can use a User Defined Function to display the formula used in another cell see the GetForumla user defined function in http://www.mvps.org/dmcritchie/excel/formula.htm this way you don't have to keep copying and pasting as text if you change things because you will be picking up the formula actually in use. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "BrianW" wrote in message ... I want to paste the formul's from a cell into another cell. Other spreadsheet programs allow this for a single cell. I'm aware of paste special , select formula button but the value is displayed. I can make this work by copying the text in a fourmul and preceeding the past in another cell with a ', but this is very cumbersom when I have to do it hundreds of times in a column, and the result is not associative with the source. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell display is 38727.4101273148 Formula Bar is 1/10/2006 9:50 | Excel Discussion (Misc queries) | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |