{"id":356,"date":"2018-04-02T17:25:16","date_gmt":"2018-04-02T17:25:16","guid":{"rendered":"http:\/\/www.alandaletraining.com\/software-tips\/?p=356"},"modified":"2018-04-02T17:25:16","modified_gmt":"2018-04-02T17:25:16","slug":"how-to-collapse-the-formula-bar-in-excel","status":"publish","type":"post","link":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/","title":{"rendered":"How to collapse the Formula Bar in Excel"},"content":{"rendered":"

If you have formulas that reference cells in another workbook, the formulas can get quite long and a single row in the Formula Bar may not be sufficient to see the whole formula.<\/p>\n

In Excel 2007 Microsoft introduced a small drop-down arrow to the right of the Formula Bar that expands the size of the Formula Bar to several rows.<\/p>\n

This a great feature if you work with large formulas.<\/p>\n

I find though that people often have the Formula Bar expanded when it\u2019s not needed.\u00a0 This makes your use of Excel less efficient as you are taking up space on the screen that could otherwise be used to view data.<\/p>\n

Click on the button to collapse the Formula Bar or press Ctrl+Shift+U.\u00a0 This shortcut is a toggle as it will expand and collapse the Formula Bar.
\n\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

If you have formulas that reference cells in another workbook, the formulas can get quite long and a single row in the Formula Bar may not be sufficient to see …<\/p>\n","protected":false},"author":4,"featured_media":357,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-356","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\nHow to collapse the Formula Bar in Excel - Alandale Training Software Tips<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to collapse the Formula Bar in Excel - Alandale Training Software Tips\" \/>\n<meta property=\"og:description\" content=\"If you have formulas that reference cells in another workbook, the formulas can get quite long and a single row in the Formula Bar may not be sufficient to see ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Alandale Training Software Tips\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-02T17:25:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2018\/04\/Collapse-Formula-Bar.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"204\" \/>\n\t<meta property=\"og:image:height\" content=\"307\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"John Chandler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Chandler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to collapse the Formula Bar in Excel - Alandale Training Software Tips","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to collapse the Formula Bar in Excel - Alandale Training Software Tips","og_description":"If you have formulas that reference cells in another workbook, the formulas can get quite long and a single row in the Formula Bar may not be sufficient to see ...","og_url":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/","og_site_name":"Alandale Training Software Tips","article_published_time":"2018-04-02T17:25:16+00:00","og_image":[{"width":204,"height":307,"url":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2018\/04\/Collapse-Formula-Bar.jpg","type":"image\/jpeg"}],"author":"John Chandler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Chandler","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/"},"author":{"name":"John Chandler","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4"},"headline":"How to collapse the Formula Bar in Excel","datePublished":"2018-04-02T17:25:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/"},"wordCount":146,"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2018\/04\/Collapse-Formula-Bar.jpg","articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/","url":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/","name":"How to collapse the Formula Bar in Excel - Alandale Training Software Tips","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2018\/04\/Collapse-Formula-Bar.jpg","datePublished":"2018-04-02T17:25:16+00:00","author":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2018\/04\/02\/how-to-collapse-the-formula-bar-in-excel\/#primaryimage","url":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2018\/04\/Collapse-Formula-Bar.jpg","contentUrl":"https:\/\/www.alandaletraining.com\/software-tips\/wp-content\/uploads\/2018\/04\/Collapse-Formula-Bar.jpg","width":204,"height":307},{"@type":"WebSite","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website","url":"https:\/\/www.alandaletraining.com\/software-tips\/","name":"Alandale Training Software Tips","description":"Weekly Software Tips","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.alandaletraining.com\/software-tips\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/4354e1f8ae425698db32a15825a8ecb4","name":"John Chandler","sameAs":["http:\/\/AlandaleTraining.com"],"url":"https:\/\/www.alandaletraining.com\/software-tips\/author\/john1973\/"}]}},"_links":{"self":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/comments?post=356"}],"version-history":[{"count":1,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/356\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/356\/revisions\/358"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media\/357"}],"wp:attachment":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media?parent=356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/categories?post=356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/tags?post=356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}