Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
alnav89
 
Posts: n/a
Default EDIT FORMULA BAR in excel 2003? why not? where is it?

IN EXCEL 2003 IN THE FORMULA BAR THERE IS AN INSERT FUNCTION BUTTON THAT
GIVES YOU A DIALOG BOX. IN EXCEL 2000 THERE IS A EDIT FORMULA BUTTON THAT
GIVES YOU A EDIT FORMULA BAR WHEN ACTIVATED.
I FIND THIS EDIT FORMULA BAR VERY HELPFUL WITH MY NEW STUDENTS TO EXCEL. I
HAVE THEM MOVE THE BAR JUST BELOW THE ROW THEY ARE WORKING ON AND IT KEEPS
THEM FROM GETTING CONFUSED WHEN SELECTING CELLS FOR FORMULAS. I HAVE THEM
USE THIS UNTIL THEY GET USED TO THE COLUMNS AND ROWS AND IT SEEMS TO WORK.

NOW WITH 2003 THERE IS NO EDIT FORMULA BAR, OR IS THERE ONE THAT CAN BE
ACTIVATED.

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Please turn off the Caps Lock next time you post.

Very hard to read and looks like you are angry with us.

The = sign "edit formula" went away when XL2002 was introduced.

Maybe will return in next version of Excel. Many have asked for its return.

The fx is all you get for now.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 06:44:02 -0700, "alnav89"
wrote:

IN EXCEL 2003 IN THE FORMULA BAR THERE IS AN INSERT FUNCTION BUTTON THAT
GIVES YOU A DIALOG BOX. IN EXCEL 2000 THERE IS A EDIT FORMULA BUTTON THAT
GIVES YOU A EDIT FORMULA BAR WHEN ACTIVATED.
I FIND THIS EDIT FORMULA BAR VERY HELPFUL WITH MY NEW STUDENTS TO EXCEL. I
HAVE THEM MOVE THE BAR JUST BELOW THE ROW THEY ARE WORKING ON AND IT KEEPS
THEM FROM GETTING CONFUSED WHEN SELECTING CELLS FOR FORMULAS. I HAVE THEM
USE THIS UNTIL THEY GET USED TO THE COLUMNS AND ROWS AND IT SEEMS TO WORK.

NOW WITH 2003 THERE IS NO EDIT FORMULA BAR, OR IS THERE ONE THAT CAN BE
ACTIVATED.


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
Why does Excel 2003 freeze when saving a workbook that has importe NeedToKnow Excel Worksheet Functions 0 February 18th 05 11:07 PM
How do I get the formula bar in excel 2003 unionhall Excel Discussion (Misc queries) 1 February 17th 05 11:10 AM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM
Saving Customized Toolbars in Excel 2003 MIKE MEDLIN Excel Discussion (Misc queries) 5 January 13th 05 03:03 AM
Excel 2003 - cells in formula? Tom Walker Excel Discussion (Misc queries) 1 December 24th 04 02:14 AM


All times are GMT +1. The time now is 07:59 PM.

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

About Us

"It's about Microsoft Excel"