Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel: jump to the formula bar

Posted on 2000-04-20
23
Medium Priority
?
644 Views
Last Modified: 2008-02-20
I need by a keystroke to jump the carret to the formula bar so I can edit the cell content.

I don't want to use the mouse for  that.

Anyone can help ?

Yair
0
Comment
Question by:yairy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
  • 6
  • +2
23 Comments
 
LVL 13

Expert Comment

by:cri
ID: 2734021
F2
0
 
LVL 22

Expert Comment

by:ture
ID: 2734045
One of the shortest (and best) answers I have seen in a long time...
0
 
LVL 13

Expert Comment

by:cri
ID: 2734050
I mean press F2 function key.

For additional shortcuts: See this site: There are two superb overviews, one for Excel, one for Word. Some are worth remembering.
http://notofthisworld.com/cnei/class.htm#Excel 97
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 22

Expert Comment

by:ture
ID: 2734107
Cri,
Why confuse us with a lot of additional details? 'F2' was a perfectly good answer!
/Ture
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2734177
What is even more amazing, simultanuous question & answer.

A lot of things happened at 12:21 (CEST). !
0
 
LVL 2

Author Comment

by:yairy
ID: 2736383
Sorry to be the bad guy, but this wasn't my question:

I want the switch the cursor to the
formula bar, NOT to edit the cell.
Ofcourse I could so after the cursor will be there.

so try again... ;-)

Yair


0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2736410
Sorry Yairy, but unless you have a very special version of Excel, hitting F2 puts your cursor in the formula bar, ready to edit the cell.

I'm afraid I do not understand here ?
0
 
LVL 2

Author Comment

by:yairy
ID: 2736433
Well, my Excel just put the cursor in the focused cell ready to edit the cell.

I am using Excell 97, Hebrew enabled.


0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2736440
Oh I see (Sorry)

You have to go to Tools/Options/Tab 'Edit' and uncheck the box 'Edit directly in cell'

Calacuccia
0
 

Expert Comment

by:DrewD1
ID: 2736495
Alt, T, O, arrow key to the edit tab, tab, E to turn off edit in cell, Enter, then F2. After deselecting the option, F2 will edit in the formula bar every time.
0
 
LVL 17

Accepted Solution

by:
calacuccia earned 80 total points
ID: 2736502
What did I just say, DrewD1 ?
0
 
LVL 2

Author Comment

by:yairy
ID: 2736515
DrewD1 just repeaeted calacuccia words.

0
 
LVL 2

Author Comment

by:yairy
ID: 2736519
So the points go to the winner !

Yair
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2736537
Thanks Yairy !

(now I really feel like crying for cri)
0
 
LVL 13

Expert Comment

by:cri
ID: 2736546
Today is really not my day in E-E... >8-|
yairy: I want my URL back... >8-P
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2736561
Cri, as compensation for this and your C of today (or was it yesterday), get some points for the good link.

http://www.experts-exchange.com/jsp/qShow.jsp?ta=msoffice&qid=10331809 

0
 
LVL 13

Expert Comment

by:cri
ID: 2736597
calacuccia, thank you for your support, but I kindly ask to delete it, this could be interpreted as point feeding. Actually I am sore that the amount of unresolved questions (Awaiting/ToBeGraded) is getting out of hand, despite we spending more time here than is actually good for us.

The awarding here was technically correct, although asking back before rejecting would not have hurt either.

yairy, sorry to use your question as info board but this is the price for a free service (especially as you got a discount of 60% as the min. wage is 50 points...)
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2736637
You're right, cri, question deleted.

0
 
LVL 13

Expert Comment

by:cri
ID: 2736654
Thanks again.
0
 
LVL 2

Author Comment

by:yairy
ID: 2737337
yairy, sorry to use your question as info board but this is the price for a free service (especially as you got a discount of 60% as the min. wage is 50 points...)


True, but I am a poor man....
BTW, I already GAVE you 200 points for the same question "Excel: Change carret mode" at the 31.3.00
then your answer was much longer:
"Press F2"

Have a good weekend all, and don't
take the points issue to hard !

Yair

0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2737346
Yairy, :-)

In the future you'd better specifiy in the old question (the 200 pointer you mention), I'm sure Cri would have helped you out for 0 points. After questions have been accepted, discussion can go on, and I know cri always wants to assure the problem is solved to the bottom.

Calacuccia
0
 
LVL 13

Expert Comment

by:cri
ID: 2739831
yairy, I am not that 'point horny'...

I  have skipped the word 'Press' (I knew ture et al waiting to pounce...) but you even got the URL (again, did not remember your login).

As long you stay within the asked question most experts will _continue_ the discussion in an accepted answer. However, to keep the number of contributors as big as possible, do not accept an answer unless you tested it.  
0
 
LVL 2

Author Comment

by:yairy
ID: 2739919
My remark was with a smile.
I am an expert too, and I know all about this stuff.

the wider picture here is an application I am writting in VC6.
I want by a keystroke to do a simple select and copy operation threw the application.

In most interfaces it's very easy.
excel is built differently.
I thought at first that emulate a F2 stroke will be enough. but its seem I need to jump to the formula bar because its a simpler edit-control.

It seems now there no trivial solution.

:-)
Best in all,
Yair
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question