What is the F2 key doing

P

psrs0810

Well-known Member
Joined
Apr 14, 2009
Messages
1,109
when I have a formula and hit enter and the formula is still showing. I know that I can hit F2 + enter and my formula will work. What is F2 doing?
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
F2 is basically the same as Double Clicking the Cell.
It just puts the cell into Edit Mode.
 
Upvote 0
F2 allows you to edit the cell value.
Very much like Rename works when you have selected a file in windows explorer.

If your formulas aren't working prior to doing that check that Calculation isn't set to manual.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
How to use F2 + F9 + Enter for entire Worksheet
2
Replies
11
Views
218
Alex Blakenburg
A
U
  • Solved
Vlookup won't see a number unless I press F2 and Enter
Replies
5
Views
237
Peter_SSs
Peter_SSs
R
  • Question Question
Need Macro/VBA code for a rotating list
Replies
3
Views
123
mumps
mumps
M
  • Question Question
Trouble removing formatting in vlookup area
2
Replies
14
Views
310
Peter_SSs
Peter_SSs
S
  • Question Question
Disappearing Cell Value
Replies
9
Views
403
RoryA
RoryA

Forum statistics

Threads
1,224,521
Messages
6,179,285
Members
452,902
Latest member
Knuddeluff

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top