{"id":258194,"date":"2021-05-24T17:24:07","date_gmt":"2021-05-24T14:24:07","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/"},"modified":"2021-05-24T17:24:07","modified_gmt":"2021-05-24T14:24:07","slug":"how-to-use-the-microsoft-excel-watch-window-for-formulas","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/","title":{"rendered":"#How to Use the Microsoft Excel Watch Window for Formulas"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a36ea5d17f1b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a36ea5d17f1b\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/#Add_Cells_to_Your_Watch_Window\" >Add Cells to Your Watch Window<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/#Watch_Certain_Cells_with_Formulas\" >Watch Certain Cells with Formulas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/#Watch_All_Cells_with_Formulas\" >Watch All Cells with Formulas<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/#Use_the_Watch_Window\" >Use the Watch Window<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/#Move_the_Watch_Window\" >Move the Watch Window<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/#Remove_Cells_from_Your_Watch_Window\" >Remove Cells from Your Watch Window<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Use the Microsoft Excel Watch Window for Formulas&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-725718\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?width=1200&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Tired of scrolling to see formulas and results in cells that aren\u2019t in view? With the Watch Window in Microsoft Excel, you can keep an eye on your formulas without constant spreadsheet scrolling.<\/p>\n<p>Available for all desktop versions of Excel, the Watch Window is a handy tool for seeing your formulas with their locations and results. You can view cells in your current workbook or another that you have open, which gives you the flexibility you need to stay on top of things.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_Cells_to_Your_Watch_Window\"><\/span>Add Cells to Your Watch Window<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can easily add cells to the Watch Window in your current spreadsheet, and you can select the particular cells containing formulas if you want to watch or view all the\u00a0formulas in the sheet.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Watch_Certain_Cells_with_Formulas\"><\/span>Watch Certain Cells with Formulas<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To add specific cells, first, select them, and then open the Formulas tab. Now, click \u201cWatch Window\u201d in the Formula Auditing section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-725715\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/FormulasTabWatchWindow-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Go to the Formulas tab and click Watch Window\" width=\"650\" height=\"310\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cAdd Watch\u201d in the Watch Window toolbar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-725717\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/AddToWatchWindow-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Add Watch\" width=\"556\" height=\"224\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Confirm the cells that you\u2019ve selected in the Add Watch pop-up window and hit \u201cAdd.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-725716\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/AddWatchWindow-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Confirm the cells and click Add\" width=\"488\" height=\"138\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Watch_All_Cells_with_Formulas\"><\/span>Watch All Cells with Formulas<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you prefer to add all cells containing formulas in your sheet, this is just as simple. With your sheet active, go to the Home tab.<\/p>\n<p>Click the \u201cFind &amp; Select\u201d drop-down box in the Editing section of the ribbon and select \u201cFormulas.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-725719\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/FindSelectFormulas-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Go to the Home tab, click Find &amp; Select, choose Formulas\" width=\"302\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This selects all cells containing formulas in your spreadsheet. From there, follow the same steps as those listed above to open the Watch Window and add those cells.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_Watch_Window\"><\/span>Use the Watch Window<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After you add cells to the Watch Window, you can see the workbook name, sheet name, cell name, cell reference, value, and formula for each one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-725721 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/CellsWatchWindow-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Cells in the Watch Window\" width=\"556\" height=\"340\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This is when the Watch Window becomes so valuable in large spreadsheets. If you need to see the result of a formula (value), you don\u2019t have to scroll through your current sheet, move to a different one, or even pull another workbook into view. Just look at the Watch Window.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Change the Cell Reference Style in Excel<\/em><\/strong><\/p>\n<p>Any cells that you add to the Watch Window will remain there until you remove them (as seen below). The exception is when you\u2019re using multiple workbooks. For example, if you\u2019re using Workbook A and have cells from Workbook B in the Watch Window, you must keep Workbook B open. If you close it, those cells will dis<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ear from the Watch Window.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Move_the_Watch_Window\"><\/span>Move the Watch Window<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The Watch Window can be moved or parked wherever you like in your Microsoft Excel workbook. Simply drag to move it or double-click its gray area to dock it above the formula bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-725720\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/ParkWatchWindow-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Docked Watch Window in Excel\" width=\"650\" height=\"403\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also close the Watch Window using the \u201cX\u201d in the upper-right corner or the button in the ribbon. When you reopen it, those same cells that you added will be there ready and waiting.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_Cells_from_Your_Watch_Window\"><\/span>Remove Cells from Your Watch Window<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To remove a cell from the Watch Window, select it in the window and click \u201cDelete Watch.\u201d You can use your Control key (Command on Mac) to select multiple cells in the window and then hit \u201cDelete Watch.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-725722\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/DeleteFromWatchWindow-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Delete Watch\" width=\"556\" height=\"340\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Being able to see cells with formulas that aren\u2019t in your im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>te view is a great feature. So remember the Watch Window feature the next time you\u2019re working with a lengthy Microsoft Excel spreadsheet.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/725710\/how-to-use-the-microsoft-excel-watch-window-for-formulas\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Use the Microsoft Excel Watch Window for Formulas&#8221; Tired of scrolling to see formulas and results in cells that aren\u2019t in view? With the Watch Window in Microsoft Excel, you can keep an eye on your formulas without constant spreadsheet scrolling. Available for all desktop versions of Excel, the Watch Window is a&#8230;<\/p>\n","protected":false},"author":1,"featured_media":258195,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-258194","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/258194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=258194"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/258194\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/258195"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=258194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=258194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=258194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}