Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 24th 05, 01:49 PM
Don't be a pain in the ass
 
Posts: n/a
Default revert formula insertion to old method

inserting a formula using the shortcut from the menu bar has become a real
pain in the ....... in office XP. trying to change from one formula type to
another makes it impossible to get the expanded menu, and in addition, when
the formula expands into adjoining blocks, it makes it impossible to select
those blocks as part of the formula. It is the most common scenario that the
adjoining blocks are the ones involved in the formula. The same problem
occurs when the formula is lengthy and requires two lines in the formula
review box in the header area. I blocks the next row down and makes it
impossible to see or select that row. How about moving the whole sheet down
a row when the formula block expands to cover it.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with a formula Richard F Excel Discussion (Misc queries) 1 January 20th 05 09:56 PM
Simple formula doesn't quite add up circeo Excel Discussion (Misc queries) 3 January 17th 05 09:04 PM
how do I make a formula NOT change when the data range is moved? Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM
I want the results of a formula to show in cell, NOT THE FORMULA! ocbecky Excel Discussion (Misc queries) 4 December 10th 04 08:39 PM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017