{"id":2103,"date":"2015-01-26T16:40:00","date_gmt":"2015-01-26T16:40:00","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/?p=2103"},"modified":"2023-12-30T23:38:37","modified_gmt":"2023-12-30T23:38:37","slug":"15-excel-keyboard-shortcuts-worth-knowing","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/15-excel-keyboard-shortcuts-worth-knowing\/","title":{"rendered":"15 Excel Keyboard Shortcuts worth knowing"},"content":{"rendered":"

Save hours in Excel:\u00a0spend\u00a0a few minutes learning these shortcuts<\/strong><\/h2>\n

Keyboard shortcuts are great time-savers; allowing you to shave\u00a0seconds off a task, but ultimately saving hours in the long run. This is especially true when you are working with Excel.\u00a0 There are over 200 Excel keyboard shortcuts<\/a> that you can use, here we have selected 15 most commonly used shortcuts. Using these\u00a0shortcuts will make you faster in\u00a0Excel, thus saving you\u00a0valuable time.<\/p>\n

1 – Switching Between Sheets<\/strong><\/p>\n

Working with multiple worksheets? Try using this Ctrl+PgUp or Ctrl+PgDn,\u00a0instead of clicking on the tabs for each sheet. Hold Ctrl to scroll through multiple sheets.<\/p>\n

\"Switch<\/a><\/p>\n

\"Sheet<\/a><\/p>\n

 <\/p>\n

2 – Currency Format<\/strong><\/p>\n

You can use Ctrl+Shift+$ to apply the Currency format (With two decimals places). Select the cells and apply. Great for Totals!<\/p>\n

\"Currency<\/a><\/p>\n

\"Currency<\/a><\/p>\n

 <\/p>\n

3 – Absolute References<\/strong><\/p>\n

If you are writing a formula that needs to point to a fixed cell reference A1, then we would want to make that \u201cabsolute\u201d by adding $A$1. The $ locks the row and column. As you type the cell reference, use the shortcut F4 to automatically make it \u201cabsolute\u201d by adding in the $ signs.<\/p>\n

\"Absolute<\/a><\/p>\n

\"Relative<\/a><\/p>\n

 <\/p>\n

4 – Find<\/strong><\/p>\n

It can be useful to search the worksheet or workbook for values or names. Use Ctrl+F to bring up the Find and Replace dialog box. This can save valuable time when you are hunting for\u00a0something specific.<\/p>\n

\"Ctrl+<\/a><\/p>\n

\"FindExample\"<\/a><\/p>\n

 <\/p>\n

5 – New Blank Workbook<\/strong><\/p>\n

When you need a New Blank Workbook, don’t go to File\/New try Ctrl+N instead<\/p>\n

\"New<\/a><\/p>\n

 <\/p>\n

\"New<\/a><\/p>\n

 <\/p>\n

6 – Print<\/strong><\/p>\n

When you want to print, use Ctrl+P to open up the Print options rather than clicking on File and heading down to\u00a0the Print Tab.<\/p>\n

\"Print\"<\/a><\/p>\n

\"Print<\/a><\/p>\n

 <\/p>\n

7 –\u00a0Save<\/strong><\/p>\n

Saving your work in Excel is\u00a0essential. You can use Ctrl + S as you work to make sure your\u00a0everything is safely saved.<\/p>\n

\"Save\"<\/a><\/p>\n

 <\/p>\n

8 – Save As<\/strong><\/p>\n

If you want to Save As (to create a copy) try F12 instead<\/p>\n

\"F12\"<\/a><\/p>\n

 <\/p>\n

\"Saveasexample\"<\/a><\/p>\n

 <\/p>\n

9\u00a0– Editing a Cell<\/strong><\/p>\n

Editing the current cell: you could double click on it, or go up to the formula bar. Save time by using F2.<\/p>\n

\"F2\"<\/a><\/p>\n

\"Edit<\/a><\/p>\n

If you make a mistake while editing a formula or want to cancel what you are doing, don’t click off. Press Esc<\/p>\n

\"Esc\"<\/a><\/p>\n

 <\/p>\n

10\u00a0– Automatically Generate a Chart<\/strong><\/p>\n

When you have formatted your data and are ready to insert a chart. Rather than heading to Insert and selecting Chart, just use F11. It will automatically use the data around the active cell (where you are clicked).\u00a0The\u00a0Chart will be generated in\u00a0a new worksheet.<\/p>\n

\"F11\"<\/a><\/p>\n

\"AutoChart\"<\/a><\/p>\n

 <\/p>\n

11 – Home<\/strong><\/p>\n

As you move around large worksheets, you might want to return to the top left of the data. Ctrl+Home takes you back to A1, faster than scrolling back up.<\/p>\n

\"Home\"<\/a><\/p>\n

\"Home<\/a><\/p>\n

 <\/p>\n

12 – Select All<\/strong><\/p>\n

Selecting and entire range of data would usually involve clicking and dragging. If that data region was large you could spend time scrolling down the page. Click into the data and use Ctrl+A to select the entire region of data, press again to select the entire worksheet. Great for quickly selecting an entire table<\/p>\n

\"Select<\/a><\/p>\n

\"Select<\/a><\/p>\n

 <\/p>\n

13 – AutoSum<\/strong><\/p>\n

Rather than writing the formula to Sum up a range, you can use AutoSum\"AutoSum\"<\/a><\/p>\n

This Function automatically applies the Sum\u00a0function to calculate the neighbouring cells.\u00a0Try selecting the cell where you require the total, and use the shortcut \u00a0Alt+=.<\/p>\n

\"AutoSum\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\"Autosum<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

14 – Copy\/Cut and Paste<\/strong><\/p>\n

Select the cells you want to Copy then use Ctrl+C.<\/p>\n

\"Copy\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

\"Copyexample\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

Then Paste it with Ctrl+V.<\/p>\n

\"Paste\"<\/a><\/p>\n

\"Paste<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

If you want to cut the cells, use Ctrl+X<\/p>\n

\"Cut\"<\/p>\n

\"Cut\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Then paste using Ctrl+V<\/p>\n

\"Paste\"<\/p>\n

\"Cut<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

15 – Show Formulas<\/strong><\/p>\n

When comparing Formulas on a sheet, it can help if the cell displays the formula \u00a0rather than the Value. This option is in the Formula Tab\/ Formula Auditing\/Display Formulas. Alternatively you can use the shortcut Ctrl+\u00ac (\u00ac or the ‘Pipe Key’ is located just above Tab and next to 1 on the keyboard).<\/p>\n

\"Show<\/p>\n

 <\/p>\n

\"Values\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\"Formulas\"<\/a><\/p>\n

 <\/p>\n

These keyboard shortcuts are but the tip of the Excel iceberg and there are plenty more productivity gains to be had. Check out these resources for further Excel keyboard shortcuts.<\/p>\n

The\u00a0Definitive Guide to Excel Keyboard Shortcuts<\/strong><\/a><\/h2>\n

Keyboard shortcuts in Excel<\/a><\/h2>\n","protected":false},"excerpt":{"rendered":"

Save hours in Excel:\u00a0spend\u00a0a few minutes learning these shortcuts Keyboard shortcuts are great time-savers; allowing you to shave\u00a0seconds off a task, but ultimately saving hours in the long run. This is especially true when you are working with Excel.\u00a0 There are over 200 Excel keyboard shortcuts that you can use, here we have selected 15 […]<\/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,6],"tags":[207,212,246,330,477,535],"class_list":["post-2103","post","type-post","status-publish","format-standard","hentry","category-excel-training","category-hints-tips","tag-excel-keyboard-shortcuts","tag-excel-shortcuts","tag-fast-keyboard-shortcuts","tag-keyboard-shortcuts-in-excel","tag-select-all-in-excel","tag-time-saving-shortcuts"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2103","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=2103"}],"version-history":[{"count":3,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2103\/revisions"}],"predecessor-version":[{"id":6261,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/2103\/revisions\/6261"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=2103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=2103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=2103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}