{"id":23,"date":"2012-03-13T07:58:00","date_gmt":"2012-03-13T07:58:00","guid":{"rendered":"http:\/\/www.ahbsolutions.co.uk\/blog\/?p=23"},"modified":"2017-03-29T14:48:09","modified_gmt":"2017-03-29T14:48:09","slug":"excel-shortcuts","status":"publish","type":"post","link":"https:\/\/www.ahbtraining.co.uk\/blog\/2012\/03\/excel-shortcuts\/","title":{"rendered":"Excel Shortcuts"},"content":{"rendered":"<p>I\u2019m starting a series of articles here about shortcuts in Microsoft Excel.<\/p>\n<p>Becoming more productive across all applications is important, and to help you n your way there are a series of keyboard shortcuts that can be used.<\/p>\n<p>Firstly I\u2019ll consider moving around a worksheet.<\/p>\n<p>Keyboard shortcuts for moving around workbooks<\/p>\n<p>This is only a partial list. For a comprehensive list, see the links at the top of this page.<\/p>\n<ul>\n<li>To move one cell at a time in any direction, use the Arrow keys<\/li>\n<li>When in a range, to move to edge of range use the CTRL+Arrow key combination<\/li>\n<li>To move to last cell on worksheet that contains data, the CTRL+End key combination should be used<\/li>\n<li>Move to beginning of worksheet, typically cell A1, CTRL+Home key combination<\/li>\n<li>Move one screen down or up is achieved with the Page Down and Page Up keys<\/li>\n<li>Moving one screen to the right or left use the ALT+Page Down or ALT+Page Up key combination<\/li>\n<\/ul>\n<p>Next, moving between worksheets<\/p>\n<ul>\n<li>Move to next worksheet use the CTRL+Page Down key combination<\/li>\n<li>Whilst moving to previous worksheet uses the CTRL+Page Up key combination<\/li>\n<\/ul>\n<p>Need Help? then press the F1 key to access Word Help<\/p>\n<p>In Excel2007 or Excel 2010 show or hide the ribbon by using CTRL+F1 or add commonly used commands to the Quick Access Toolbar by right-click a button, and then click Add to Quick Access Toolbar.<\/p>\n<p>More Excel tips soon.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019m starting a series of articles here about shortcuts in Microsoft Excel. Becoming more productive across all applications is important, and to help you n your way there are a series of keyboard shortcuts that can be used. Firstly I\u2019ll consider moving around a worksheet. Keyboard shortcuts for moving around workbooks This is only a &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.ahbtraining.co.uk\/blog\/2012\/03\/excel-shortcuts\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[29,10,14],"tags":[90,124,137],"class_list":["post-23","post","type-post","status-publish","format-standard","hentry","category-excel-2007","category-microsoft","category-office-2007","tag-microsoft-excel","tag-shortcuts","tag-tips","item-wrap"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":1,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":476,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/posts\/23\/revisions\/476"}],"wp:attachment":[{"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ahbtraining.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}