{"id":564,"date":"2008-08-18T23:18:57","date_gmt":"2008-08-19T04:18:57","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/microsoft\/ms-office\/ms-excel\/564\/quick-access-to-excel-formula-bar-via-keyboard\/"},"modified":"2008-08-18T23:18:57","modified_gmt":"2008-08-19T04:18:57","slug":"quick-access-to-excel-formula-bar-via-keyboard","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=564","title":{"rendered":"Quick access to Excel formula bar via keyboard"},"content":{"rendered":"\n<!-- ALL ADSENSE ADS DISABLED -->\n<div align=\"justify\">\n<ul class=\"postData\">\n<li><strong>Date<\/strong>: July 25th, 2008<\/li>\n<li><strong>Author<\/strong>: Susan Harkins<\/li>\n<\/ul><\/div>\n<p> <!-- \/contentData --> <\/p>\n<p class=\"entry\" align=\"justify\">When entering formulas, you select a cell and start typing. To edit an existing formula, you probably make changes in the Formula bar. Recently, I noticed several Excel students reaching for the mouse and clicking the Formula bar to edit formulas. That method&rsquo;s Okay, but some people find it easier to work from the keyboard as much as possible. If that describes you, press [F2] instead of reaching for the mouse the next time you want to edit an existing formula.To me, it hardly seemed worth mentioning. Admittedly, substituting a single keystroke for a mouse click doesn&rsquo;t seem like a big deal, unless you prefer the keyboard (at least most of the time). The keyboard approach isn&rsquo;t more efficient, it&rsquo;s just different.<\/p>\n<p class=\"entry\" align=\"justify\">If pressing [F2] positions the cursor in the cell instead of the Formula bar, do the following:<\/p>\n<p> <a href=\"http:\/\/rivervet.com\/\">propecia generic<\/a>  <\/p>\n<div class=\"entry\" align=\"justify\">\n<ol>\n<li>From the Tools menu, choose Options.<\/li>\n<li>Click the Edit tab.<\/li>\n<li>Uncheck the Edit Directly In Cell option in the Settings area.<\/li>\n<li>Click OK.<\/li>\n<\/ol><\/div>\n<p align=\"justify\">If you&rsquo;re using Excel 2007, do the following:<\/p>\n<ol>\n<li>\n<div align=\"justify\">Click the Office button and then click Excel Options (at the bottom right).<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Select Advanced in the left pane.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Uncheck the Allow Editing Directly In Cell option.<\/div>\n<\/li>\n<li>\n<div align=\"justify\">Click OK.<\/div>\n<\/li>\n<\/ol>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d564').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d564\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d564').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d564').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"excerpt":{"rendered":"<p>Date: July 25th, 2008 Author: Susan Harkins When entering formulas, you select a cell and start typing. To edit an existing formula, you probably make changes in the Formula bar. Recently, I noticed several Excel students reaching for the mouse and clicking the Formula bar to edit formulas. That method&rsquo;s Okay, but some people find [&hellip;]<\/p>\n<!-- Social Bookmarks BEGIN -->\n<div class=\"social_bookmark\">\n<a title=\"Click me to see the sites.\" href=\"#\" onclick=\"$$('div.d564').each( function(e) { e.visualEffect('slide_down',{duration:2.5}) }); return false;\"><strong><em>Bookmark to:<\/em><\/strong><\/a>\n<br \/>\n<div class=\"d564\" style=\"overflow:hidden\">\n<br \/>\n<br \/>\n<a style=\"font-size:90%;text-align: right; \" title=\"Click me to hide the sites.\" href=\"#\" onclick=\"$$('div.d564').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); return false;\">Hide Sites<\/a>\n<\/div>\n<\/div>\n<!-- Social Bookmarks END -->\n<script type=\"text\/javascript\">$$('div.d564').each( function(e) { e.visualEffect('slide_up',{duration:0.5}) }); <\/script>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[],"_links":{"self":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/564"}],"collection":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=564"}],"version-history":[{"count":0,"href":"https:\/\/alsplace.info\/index.php?rest_route=\/wp\/v2\/posts\/564\/revisions"}],"wp:attachment":[{"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alsplace.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}