{"id":466,"date":"2011-10-26T09:22:22","date_gmt":"2011-10-26T09:22:22","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=466"},"modified":"2024-05-12T01:22:54","modified_gmt":"2024-05-12T01:22:54","slug":"add-cells-to-the-watch-window","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/add-cells-to-the-watch-window\/","title":{"rendered":"Add cells to the Watch Window"},"content":{"rendered":"<ol type=\"1\">\n<li>Select the cells that you want to watch.<\/li>\n<\/ol>\n<p>To select all cells on a worksheet with formulas, on the <strong>Home <\/strong>tab, in the <strong>Editing<\/strong> group, click <strong>Find &amp; Replace<\/strong>, click <strong>Go To Special<\/strong>, and then click <strong>Formulas<\/strong>.<\/p>\n<ol type=\"1\" start=\"2\">\n<li>On the <strong>Formulas<\/strong> tab, in the <strong>Formula Auditing<\/strong> group, click <strong>Watch Window<\/strong>.<\/li>\n<\/ol>\n<ol type=\"1\" start=\"3\">\n<li>Click <strong>Add Watch<\/strong> .<\/li>\n<li>Click <strong>Add<\/strong>.<\/li>\n<li>Move the <strong>Watch Window<\/strong> toolbar to the top, bottom, left, or right side of the window.<\/li>\n<li>To change the width of a column, drag the boundary on the right side of the column heading.<\/li>\n<li>To display the cell that an entry in <strong>Watch Window<\/strong> toolbar refers to, double-click the entry.<\/li>\n<\/ol>\n<p><strong>\u00a0Note\u00a0<\/strong>\u00a0\u00a0Cells that have external references (external reference: A reference to a cell or range on a sheet in another Excel workbook, or a reference to a defined name in another workbook.) to other workbooks are displayed in the <strong>Watch Window<\/strong> toolbar only when the other workbook is open.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select the cells that you want to watch. To select all cells on a worksheet with formulas, on the Home tab, in the Editing group, click Find &amp; Replace, click Go To Special, and then click Formulas. On the Formulas tab, in the Formula Auditing group, click Watch Window. Click Add Watch . Click Add. [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[433,586],"class_list":["post-466","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-pr","tag-watch-window"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=466"}],"version-history":[{"count":3,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/466\/revisions"}],"predecessor-version":[{"id":7543,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/466\/revisions\/7543"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}