Re: Excel formula bar

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 7/18/08 1:10 PM, in article 59b548b2.1@xxxxxxxxxxxxxxxxxxxxxxx,
"rharrill" <rharrill> wrote:

Thank you for your help. I hope Excel addresses this is the future as it is
really hard to edit a hugh formula.

Rose
What is the problem? As the formula length increases, the formula bar
expands to multiple lines. I, and I'm sure Microsoft also, are not at all
clear on what problem you are having. If you are hoping for a change in a
future version, your best bet is to select Send feedback from the help menu,
and explain your problem, the solution you'd like to see and how it will
help you work more efficiently.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

.

Relevant Pages

  • RE: Problem writing numbers and dates to spreadsheet using ADO
    ... When I click on the cell I ... "Edit in Formula Bar" ... Apparently Excel thinks there is a problem with the data. ...
    (microsoft.public.excel.programming)
  • Re: Excel Chart Data Range editing
    ... click in the formula bar ... Then edit this new formula and hit Enter. ... then Y columncan be anything, AA, BA, etc. so this drag and grab, one ... adding cells when trying to edit a range line? ...
    (microsoft.public.excel.charting)
  • Re: Permanent Cell Formula?
    ... Microsoft MVP - Excel ... I know it is possible to simply edit the ... | number in the formula bar, but I was wondering if there was a way to ... | in the number as they would a regular cell and not have to worry about ...
    (microsoft.public.excel.misc)
  • Re: how do i use the sum if formula with a date range?
    ... FALSE and choose edit / paste special - ADD ... and then it should behave. ... > Yes thats it. ... >> formula bar? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Document expands to thousands of pages
    ... Endless repagination could be a sign of document corruption. ... Ludwig72 wrote: ... Whenever I edit the paragraphs immediately before certain figures, the document instantly expands by adding thousands of blank pages. ...
    (microsoft.public.word.application.errors)