When you are working in an Excel spreadsheet you have the option of entering data or a formula directly into the cell you are working in, or you can use the formula bar that is situated just above the work area of the spreadsheet. You may often find it easier to enter or edit the data using the formula bar, which you can access by simply clicking on it, or an easier option is to use your keyboard
You can activate a cell by pressing the F2 button, this will allow you to edit the data in the cell, but if you want to be able to activate the formula bar when you press F2, you can make this possible by setting it up in the Excel options dialogue box.
Open up the Excel options box and then click on the Advance button. You will now be presented with a list of editing options.
Now go down to the Allow Editing Directly in Cell and make sure you untick the box. Then click OK to exit the options dialogue.
Now, when you want to edit a cell by going directly to the formula bar, pressing F2 will activate the formula bar straight away.
To provide the best user experience, our site uses cookies to to store and/or access information about how visitors use the site for the purpose of site diagnostics and analytics. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
Cookies that have functional purpose for displaying website content.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
Cookies used to record data exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
Cookies used to display marketing/advertising. The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
