{"id":925,"date":"2012-10-25T12:18:45","date_gmt":"2012-10-25T12:18:45","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=925"},"modified":"2023-12-30T23:12:48","modified_gmt":"2023-12-30T23:12:48","slug":"using-different-views-in-excel-and-boost-your-work","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/using-different-views-in-excel-and-boost-your-work\/","title":{"rendered":"Zoom in and out and Switch Views in Excel"},"content":{"rendered":"<p>Using different views in Excel can help speed up the quick analysis of data. \u00a0<strong>Using Views<\/strong> is a great tool for <strong>viewing and organising<\/strong> large spreadsheets.<\/p>\n<p><strong>Zoom in on current selection<\/strong><br \/>\nI use Excel for 90% of my work and using views is an effective way to zoom in and out on data. \u00a0To access this tool, go to the View tab and select Zoom to Selection. \u00a0Click on this and Excel will zoom in on your selected area.<\/p>\n<figure id=\"attachment_935\" aria-describedby=\"caption-attachment-935\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/view-tab-zoom-view-microsoft-excel-training.png\"><img decoding=\"async\" class=\"size-medium wp-image-935\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/view-tab-zoom-view-microsoft-excel-training-300x71.png\" alt=\"view-tab-zoom-view-microsoft-excel-training\" width=\"300\" height=\"71\" \/><\/a><figcaption id=\"caption-attachment-935\" class=\"wp-caption-text\">The View tab includes this fantastic little widget&#8230;the Zoom Feature.<\/figcaption><\/figure>\n<blockquote><p>Tip: you can use your mouse to zoom in and out of your worksheet. \u00a0Hold down the <strong>Control key<\/strong> and <strong>use the central wheel on your mouse<\/strong> to zoom in and out.<\/p><\/blockquote>\n<p><strong>Switch Windows<br \/>\n<\/strong>I tend to have several Excel documents open at the same time, so I like to be able to switch between them easily. \u00a0In the View tab, I can use the Switch Windows tab to do this.<\/p>\n<figure id=\"attachment_938\" aria-describedby=\"caption-attachment-938\" style=\"width: 123px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Switch-windows-microsoft-excel-courses2.png\"><img decoding=\"async\" class=\"size-full wp-image-938\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/10\/Switch-windows-microsoft-excel-courses2.png\" alt=\"Switch-windows-microsoft-excel-courses\" width=\"123\" height=\"84\" \/><\/a><figcaption id=\"caption-attachment-938\" class=\"wp-caption-text\">Switch Windows quickly using this nifty little tool in the View tab<\/figcaption><\/figure>\n<blockquote><p>Tip: If you switch between Excel documents a lot, try adding the <strong>Switch Windows<\/strong> function to your <strong>Quick Access Toolbar<\/strong>. \u00a0To do this, right click on the Switch Windows icon and select &#8220;Add to quick Access toolbar&#8221;.<\/p>\n<p>&nbsp;<\/p><\/blockquote>\n<p>Viewing and organising data is included in our Microsoft Excel courses. \u00a0<a href=\"https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php\">https:\/\/www.stl-training.co.uk\/microsoft\/excel-training-london.php<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using different views in Excel can help speed up the quick analysis of data. \u00a0Using Views is a great tool for viewing and organising large spreadsheets. Zoom in on current selection I use Excel for 90% of my work and using views is an effective way to zoom in and out on data. \u00a0To access [&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":[356,570],"class_list":["post-925","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-microsoft-excel-courses","tag-using-views-in-excel"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/925","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=925"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/925\/revisions"}],"predecessor-version":[{"id":6743,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/925\/revisions\/6743"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=925"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=925"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=925"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}