ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   EDIT FORMULA BAR in excel 2003? why not? where is it? (https://www.excelbanter.com/excel-worksheet-functions/23655-edit-formula-bar-excel-2003-why-not-where.html)

alnav89

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.


Don Guillett

You are shouting so loud we can't hear you. Pls type in proper case or lower
even.

--
Don Guillett
SalesAid Software

"alnav89" wrote in message
...
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.




Gord Dibben

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.




All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com