Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
The Formula bar, just above the work area in Excel, shows the formula or value in the currently selected cell. You can click on the formula bar to edit information within a cell, if desired. What if you want to activate the Formula bar by using the keyboard, however?
The quickest way to do this is simply to press F2. This tells Excel that you want to edit the contents of a cell. When you press F2, it is highly possible that Excel will simply expand the information in the cell and allow you to edit the information directly in the cell itself. If you don't like this behavior, but instead want F2 to activate the Formula bar, follow these steps:
These steps won't work in Excel 2007. Follow these steps, instead:
Now, whenever you press F2, the Formula bar is selected and you can edit the formula there.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2651) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.