{"appState":{"pageLoadApiCallsStatus":true},"categoryState":{"relatedCategories":{"headers":{"timestamp":"2022-05-23T18:31:22+00:00"},"categoryId":33618,"data":{"title":"Software","slug":"software","image":{"src":null,"width":0,"height":0},"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618}],"parentCategory":{"categoryId":33512,"title":"Technology","slug":"technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"}},"childCategories":[{"categoryId":33619,"title":"Adobe Products","slug":"adobe-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33619"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33633,"title":"Animation Software","slug":"animation-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33633"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33634,"title":"Design Software","slug":"design-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33634"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33638,"title":"Garageband","slug":"garageband","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33638"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33639,"title":"Marketing Software","slug":"marketing-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33639"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33642,"title":"Microsoft Products","slug":"microsoft-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33653,"title":"Money Management Software","slug":"money-management-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33653"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33658,"title":"Productivity Software","slug":"productivity-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33658"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33659,"title":"Videoconference Software","slug":"videoconference-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33659"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":34356,"title":"Music Recording Software","slug":"music-recording-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34356"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":34381,"title":"Apple Products","slug":"apple-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34381"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":34390,"title":"Google Products","slug":"google-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34390"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":34393,"title":"Other Software","slug":"other-software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34393"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}}],"description":"From photo-editing apps to music recording software, these articles have the lowdown on your favorite programs.","relatedArticles":{"self":"https://dummies-api.dummies.com/v2/articles?category=33618&offset=0&size=5"}},"_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"}},"relatedCategoriesLoadedStatus":"success"},"listState":{"list":{"count":10,"total":3198,"items":[{"headers":{"creationTime":"2018-10-10T22:00:18+00:00","modifiedTime":"2022-05-02T17:21:05+00:00","timestamp":"2022-05-02T18:01:06+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Money Management Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33653"},"slug":"money-management-software","categoryId":33653},{"name":"QuickBooks","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33656"},"slug":"quickbooks","categoryId":33656}],"title":"QuickBooks 2019 For Dummies Cheat Sheet","strippedTitle":"quickbooks 2019 for dummies cheat sheet","slug":"quickbooks-2019-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"This Cheat Sheet includes user interface tricks, keyboard shortcuts, and how to perform common tasks for QuickBooks 2019.","noIndex":0,"noFollow":0},"content":"<span style=\"margin: 0px; color: #333333; font-family: 'Georgia',serif; font-size: 12pt;\">QuickBooks 2019 makes small-business accounting fast and easy. But your day-to-day business bookkeeping will go even more smoothly if you employ a handful of QuickBooks user interface tricks, editing tricks, and keyboard shortcuts.</span>","description":"<span style=\"margin: 0px; color: #333333; font-family: 'Georgia',serif; font-size: 12pt;\">QuickBooks 2019 makes small-business accounting fast and easy. But your day-to-day business bookkeeping will go even more smoothly if you employ a handful of QuickBooks user interface tricks, editing tricks, and keyboard shortcuts.</span>","blurb":"","authors":[{"authorId":8982,"name":"Stephen L. Nelson","slug":"stephen-l-nelson","description":"Stephen L. Nelson, MBA, MS in Taxation, is a certified public accountant in Redmond, Washington, where he provides accounting, business advisory, and tax planning and preparation services to small businesses. He is the bestselling author of more than 100 books on how to use computers to manage personal and business finances. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/8982"}}],"primaryCategoryTaxonomy":{"categoryId":33656,"title":"QuickBooks","slug":"quickbooks","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33656"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259385,"title":"QuickBooks 2019 Online Banking","slug":"quickbooks-2019-online-banking","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259385"}},{"articleId":259382,"title":"Basic Budgeting Tips for QuickBooks 2019","slug":"basic-budgeting-tips-for-quickbooks-2019","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259382"}},{"articleId":259379,"title":"Track Debit, ATM, and Customer Credit Cards in QuickBooks 2019","slug":"track-debit-atm-and-customer-credit-cards-in-quickbooks-2019","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259379"}},{"articleId":259373,"title":"How to Track Business Credit Cards in QuickBooks 2019","slug":"how-to-track-business-credit-cards-in-quickbooks-2019","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259373"}},{"articleId":259367,"title":"How Purchase Orders Work in QuickBooks 2019","slug":"how-purchase-orders-work-in-quickbooks-2019","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259367"}}],"fromCategory":[{"articleId":282793,"title":"QuickBooks Online: It’s All About Subscriptions","slug":"quickbooks-online-its-all-about-subscriptions","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/282793"}},{"articleId":282790,"title":"An Overview of What Won’t Import into QuickBooks Online","slug":"an-overview-of-what-wont-import-into-quickbooks-online","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/282790"}},{"articleId":282763,"title":"How to Review a Client QBO Company's Setup","slug":"how-to-review-a-client-qbo-companys-setup","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/282763"}},{"articleId":277889,"title":"How to Work in a QuickBooks Online Client’s Company","slug":"how-to-work-in-a-quickbooks-online-clients-company","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/277889"}},{"articleId":277688,"title":"How to Bill for Time in QuickBooks 2021","slug":"how-to-bill-for-time-in-quickbooks-2021","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/277688"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281840,"slug":"quickbooks-2019-for-dummies","isbn":"9781119520498","categoryList":["technology","software","money-management-software","quickbooks"],"amazon":{"default":"https://www.amazon.com/gp/product/1119520495/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119520495/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119520495-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119520495/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119520495/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/quickbooks-2019-for-dummies-cover-9781119520498-203x255.jpg","width":203,"height":255},"title":"QuickBooks 2019 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p><b data-author-id=\"8982\">Stephen L. Nelson</b>, MBA, MS in Taxation, is a certified public accountant in Redmond, Washington, where he provides accounting, business advisory, and tax planning and preparation services to small businesses. He is the bestselling author of more than 100 books on how to use computers to manage personal and business finances.</p>","authors":[{"authorId":8982,"name":"Stephen L. Nelson","slug":"stephen-l-nelson","description":"Stephen L. Nelson, MBA, MS in Taxation, is a certified public accountant in Redmond, Washington, where he provides accounting, business advisory, and tax planning and preparation services to small businesses. He is the bestselling author of more than 100 books on how to use computers to manage personal and business finances. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/8982"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;money-management-software&quot;,&quot;quickbooks&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119520498&quot;]}]\" id=\"du-slot-62701c62d6d35\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;money-management-software&quot;,&quot;quickbooks&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119520498&quot;]}]\" id=\"du-slot-62701c62d728a\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":256090,"title":"QuickBooks 2019 User Interface Tricks","slug":"quickbooks-2019-user-interface-tricks","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/256090"}},{"articleId":256092,"title":"QuickBooks 2019 Keyboard Shortcuts","slug":"quickbooks-2019-keyboard-shortcuts","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/256092"}},{"articleId":226325,"title":"Performing Common QuickBooks Tasks","slug":"performing-common-quickbooks-tasks-2","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/226325"}},{"articleId":256088,"title":"Right-Click for Common QuickBooks 2019 Tasks","slug":"right-click-for-common-quickbooks-2019-tasks","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/256088"}}],"content":[{"title":"User interface tricks","thumb":null,"image":null,"content":"<p>Here are some techniques that you can use to navigate the QuickBooks 2019 software more quickly:</p>\n<ul type=\"disc\">\n<li style=\"margin: 0px 0px 14.66px 48px; color: #333333; line-height: 18pt; font-family: 'Georgia',serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">To move quickly to a specific list-box entry, press the letter. Press the s key to move to the first list entry that begins with the letter <i>s</i>, for example.</span></li>\n<li style=\"margin: 0px 0px 14.66px 48px; color: #333333; line-height: 18pt; font-family: 'Georgia',serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">To select a list-box entry shown within a dialog box and simultaneously choose a suggested command button for the active dialog box (probably the OK button), double-click the entry.</span></li>\n<li style=\"margin: 0px 0px 14.66px 48px; color: #333333; line-height: 18pt; font-family: 'Georgia',serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">To move the insertion point to the beginning of a field, press Home.</span></li>\n<li style=\"margin: 0px 0px 14.66px 48px; color: #333333; line-height: 18pt; font-family: 'Georgia',serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">To move the insertion point to the end of a field, press End.</span></li>\n<li style=\"margin: 0px 0px 14.66px 48px; color: #333333; line-height: 18pt; font-family: 'Georgia',serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">QuickBooks can display a list of open windows in its Open Window list. To display the Open Window list, choose View</span>→<span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">Open Window List. To move to a listed window, just click it.</span></li>\n<li style=\"margin: 0px 0px 14.66px 48px; color: #333333; line-height: 18pt; font-family: 'Georgia',serif; font-size: 12pt; font-style: normal; font-weight: 400;\"><span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">To tell QuickBooks to use windows the same way every other program does, choose View</span>→<span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">Multiple Windows. Alternatively, to tell QuickBooks to display just the active window, choose View</span>→<span style=\"margin: 0px; font-family: 'Georgia',serif; font-size: 12pt;\">One Window.</span></li>\n</ul>\n"},{"title":"Keyboard shortcuts","thumb":null,"image":null,"content":"<p>Use the QuickBooks 2019 keyboard shortcuts shown in the following table to make your day-to-day small-business accounting easier and faster.</p>\n<p>&nbsp;</p>\n<table>\n<tbody>\n<tr>\n<td width=\"217\"><strong>Press This PC Shortcut</strong></td>\n<td width=\"447\"><strong>QuickBooks Does This</strong></td>\n</tr>\n<tr>\n<td width=\"217\">Alt+S</td>\n<td width=\"447\">Saves a transaction</td>\n</tr>\n<tr>\n<td width=\"217\">Alt+N</td>\n<td width=\"447\">Saves a transaction and goes to a new transaction</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+A</td>\n<td width=\"447\">Displays the Chart of Accounts window</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+C</td>\n<td width=\"447\">Copies your selection to the Clipboard</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+D</td>\n<td width=\"447\">Deletes check, invoice, transaction, or item from the list</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+E</td>\n<td width=\"447\">Edits transaction selected in the register</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+F</td>\n<td width=\"447\">Displays the Find window</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+G</td>\n<td width=\"447\">Goes to the other side of a transfer transaction</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+I</td>\n<td width=\"447\">Displays the Create Invoice window</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+J</td>\n<td width=\"447\">Displays the Customer:Job List window</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+M</td>\n<td width=\"447\">Memorizes a transaction</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+N</td>\n<td width=\"447\">Creates a new <em>&lt;fill in the blank&gt;</em> where <em>&lt;fill in the blank&gt;</em> is whatever is active at the time</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+P</td>\n<td width=\"447\">Almost always prints the currently active register, list, or form</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+Q</td>\n<td width=\"447\">Creates and displays a QuickReport on the selected transaction</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+R</td>\n<td width=\"447\">Displays the Register window</td>\n</tr>\n<tr>\n<td width=\"217\">Crtl+T</td>\n<td width=\"447\">Displays the memorized transaction list</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+V</td>\n<td width=\"447\">Pastes the contents of the Clipboard</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+W</td>\n<td width=\"447\">Displays the Write Checks window</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+X</td>\n<td width=\"447\">Moves your selection to the Clipboard</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+Z</td>\n<td width=\"447\">Undoes your last action — usually</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+Enter</td>\n<td width=\"447\">Saves the changes</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+Insert</td>\n<td width=\"447\">Inserts a line into a list of items or expenses</td>\n</tr>\n<tr>\n<td width=\"217\">Ctrl+Delete</td>\n<td width=\"447\">Deletes the selected line from a list of items or expenses</td>\n</tr>\n<tr>\n<td width=\"217\">Esc</td>\n<td width=\"447\">Closes the active window</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Performing common QuickBooks tasks","thumb":null,"image":null,"content":"<p>To perform a common accounting or bookkeeping task in QuickBooks, use these commands. When QuickBooks displays the commands window, you just fill in the boxes and press Enter.</p>\n<table>\n<tbody>\n<tr>\n<td width=\"254\"><strong>To Do This</strong></td>\n<td width=\"286\"><strong>Choose This QuickBooks Command</strong></td>\n</tr>\n<tr>\n<td width=\"254\"><em>Dealing with Customers</em></td>\n<td width=\"286\"></td>\n</tr>\n<tr>\n<td width=\"254\">Invoice a customer</td>\n<td width=\"286\">Customers→Create Invoices</td>\n</tr>\n<tr>\n<td width=\"254\">Record a cash sale</td>\n<td width=\"286\">Customers→Enter Sales Receipts</td>\n</tr>\n<tr>\n<td width=\"254\">Issue a credit memo</td>\n<td width=\"286\">Customers→Create Credit Memo/Refunds</td>\n</tr>\n<tr>\n<td width=\"254\">Record a customer payment</td>\n<td width=\"286\">Customers→Receive Payments</td>\n</tr>\n<tr>\n<td width=\"254\"><em>Handling Banking Activities</em></td>\n<td width=\"286\"></td>\n</tr>\n<tr>\n<td width=\"254\">Pay a bill with a check</td>\n<td width=\"286\">Banking→Write Checks</td>\n</tr>\n<tr>\n<td width=\"254\">Buy inventory with a check</td>\n<td width=\"286\">Banking→Write Checks</td>\n</tr>\n<tr>\n<td width=\"254\">Move money between bank accounts</td>\n<td width=\"286\">Banking→Transfer Funds</td>\n</tr>\n<tr>\n<td width=\"254\">Deposit money in a bank account</td>\n<td width=\"286\">Banking→Make Deposits</td>\n</tr>\n<tr>\n<td width=\"254\">See a bank account’s transactions</td>\n<td width=\"286\">Banking→Use Register</td>\n</tr>\n<tr>\n<td width=\"254\">Reconcile a bank account</td>\n<td width=\"286\">Banking→Reconcile</td>\n</tr>\n<tr>\n<td width=\"254\"><em>Working with Vendors</em></td>\n<td width=\"286\"></td>\n</tr>\n<tr>\n<td width=\"254\">Prepare a purchase order</td>\n<td width=\"286\">Vendors→Create Purchase Orders</td>\n</tr>\n<tr>\n<td width=\"254\">Record when items are received</td>\n<td width=\"286\">Vendors→Receive Items or Vendors→Receive Items and Enter Bill</td>\n</tr>\n<tr>\n<td width=\"254\">Record an accounts payable amount</td>\n<td width=\"286\">Vendors→Enter Bills or Vendors→Enter Bill for Received Items</td>\n</tr>\n<tr>\n<td width=\"254\"><em>Managing Employees</em></td>\n<td width=\"286\"></td>\n</tr>\n<tr>\n<td width=\"254\">Preparing employee payroll</td>\n<td width=\"286\">Employees→Pay Employees</td>\n</tr>\n<tr>\n<td width=\"254\">Paying tax deposits</td>\n<td width=\"286\">Employees→Payroll Taxes and Liabilities→Pay Scheduled Liabilities</td>\n</tr>\n<tr>\n<td width=\"254\"><em>Getting Financial Information</em></td>\n<td width=\"286\"></td>\n</tr>\n<tr>\n<td width=\"254\">Accounts</td>\n<td width=\"286\">Lists→Chart of Accounts</td>\n</tr>\n<tr>\n<td width=\"254\">Customers</td>\n<td width=\"286\">Customers→Customer Center</td>\n</tr>\n<tr>\n<td width=\"254\">Inventory</td>\n<td width=\"286\">Lists→Item List or Vendors→Inventory Activies→Inventory Center</td>\n</tr>\n<tr>\n<td width=\"254\">Vendors</td>\n<td width=\"286\">Vendors→Vendor Center</td>\n</tr>\n<tr>\n<td width=\"254\">Employees</td>\n<td width=\"286\">Employees→Employee Center</td>\n</tr>\n<tr>\n<td width=\"254\">Profit and loss</td>\n<td width=\"286\">Reports→Company &amp; Financial→Profit &amp; Loss Standard or one of the other profit &amp; loss reports on Company &amp; Financial submenu</td>\n</tr>\n<tr>\n<td width=\"254\">Net worth</td>\n<td width=\"286\">Reports→Company &amp; Financial→Balance Sheet Standard or one of the other balance sheet reports on the Company &amp; Financial submenu</td>\n</tr>\n<tr>\n<td width=\"254\"><em>Managing the QuickBooks System</em></td>\n<td width=\"286\"></td>\n</tr>\n<tr>\n<td width=\"254\">Setting up a new company</td>\n<td width=\"286\">File→New Company</td>\n</tr>\n<tr>\n<td width=\"254\">Resetting company information</td>\n<td width=\"286\">Company→Company Information</td>\n</tr>\n<tr>\n<td width=\"254\">Backing up data file</td>\n<td width=\"286\">File→Save Copy or Back Up</td>\n</tr>\n<tr>\n<td width=\"254\">Restoring a data file</td>\n<td width=\"286\">File→Open or Restore Company</td>\n</tr>\n<tr>\n<td width=\"254\">Customizing QuickBooks</td>\n<td width=\"286\">Edit→Preferences</td>\n</tr>\n<tr>\n<td width=\"254\">Adjusting accounting data</td>\n<td width=\"286\">Company→Make Journal Entries</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Right-click for common tasks","thumb":null,"image":null,"content":"<p>To perform a common QuickBooks 2019 task related to a window, right-click to display a shortcut menu. In a register, select and right-click a specific transaction; in a list, right-click an item; in a form, display a transaction and right-click a blank area of the form.</p>\n<p>QuickBooks displays a shortcut menu of common commands for each particular transaction, item, or window. It often displays commands for memorizing or voiding a transaction, for example, or for creating a QuickReport on a transaction. The commands differ based on the type of transaction you select.</p>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-05-02T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":256094},{"headers":{"creationTime":"2016-03-27T16:57:32+00:00","modifiedTime":"2022-04-27T20:31:50+00:00","timestamp":"2022-04-28T00:01:06+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Money Management Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33653"},"slug":"money-management-software","categoryId":33653},{"name":"QuickBooks","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33656"},"slug":"quickbooks","categoryId":33656}],"title":"QuickBooks Simple Start For Dummies Cheat Sheet","strippedTitle":"quickbooks simple start for dummies cheat sheet","slug":"quickbooks-simple-start-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"This Cheat Sheet can serve as a handy reference to working QuickBooks Simple Start, including keyboard shortcuts, common tasks, and more.","noIndex":0,"noFollow":0},"content":"Keeping track of your accounting with QuickBooks Simple Start means organizing your debits and credits, applying user interface tips, using calculating and editing tricks, working efficiently with keyboard shortcuts, and right-clicking on your mouse to perform basic tasks in QuickBooks Simple Start.","description":"Keeping track of your accounting with QuickBooks Simple Start means organizing your debits and credits, applying user interface tips, using calculating and editing tricks, working efficiently with keyboard shortcuts, and right-clicking on your mouse to perform basic tasks in QuickBooks Simple Start.","blurb":"","authors":[],"primaryCategoryTaxonomy":{"categoryId":33656,"title":"QuickBooks","slug":"quickbooks","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33656"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[],"fromCategory":[{"articleId":282793,"title":"QuickBooks Online: It’s All About Subscriptions","slug":"quickbooks-online-its-all-about-subscriptions","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/282793"}},{"articleId":282790,"title":"An Overview of What Won’t Import into QuickBooks Online","slug":"an-overview-of-what-wont-import-into-quickbooks-online","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/282790"}},{"articleId":282763,"title":"How to Review a Client QBO Company's Setup","slug":"how-to-review-a-client-qbo-companys-setup","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/282763"}},{"articleId":277889,"title":"How to Work in a QuickBooks Online Client’s Company","slug":"how-to-work-in-a-quickbooks-online-clients-company","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/277889"}},{"articleId":277688,"title":"How to Bill for Time in QuickBooks 2021","slug":"how-to-bill-for-time-in-quickbooks-2021","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/277688"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":0,"slug":null,"isbn":null,"categoryList":null,"amazon":null,"image":null,"title":null,"testBankPinActivationLink":null,"bookOutOfPrint":false,"authorsInfo":null,"authors":null,"_links":null},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;money-management-software&quot;,&quot;quickbooks&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[null]}]\" id=\"du-slot-6269d942992c2\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;money-management-software&quot;,&quot;quickbooks&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[null]}]\" id=\"du-slot-6269d94299c68\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":194344,"title":"Keeping Your Debits and Credits Straight in QuickBooks Simple Start","slug":"keeping-your-debits-and-credits-straight-in-quickbooks-simple-start","categoryList":["technology","software","money-management-software","quickbooks"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/194344"}},{"articleId":194343,"title":"QuickBooks Simple Start Keyboard Shortcuts","slug":"quickbooks-simple-start-keyboard-shortcuts","categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/194343"}},{"articleId":194368,"title":"Right-Click to Perform Common Tasks in QuickBooks Simple Start","slug":"right-click-to-perform-common-tasks-in-quickbooks-simple-start","categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/194368"}},{"articleId":194337,"title":"Some QuickBooks Simple Start User Interface Tricks","slug":"some-quickbooks-simple-start-user-interface-tricks","categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/194337"}},{"articleId":194342,"title":"Some QuickBooks Simple Start Calculation and Editing Tricks","slug":"some-quickbooks-simple-start-calculation-and-editing-tricks","categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/194342"}}],"content":[{"title":"Keeping track of your debits and credits","thumb":null,"image":null,"content":"<p>To keep track of your debits and credits in QuickBooks Simple Start, remember that the left (debit) is the natural balance for asset accounts, and the right (credit) is the natural balance for liability and owner’s equity accounts.</p>\n<p class=\"article-tips remember\">Assets = Liabilities  + Owner’s Equity. (The exceptions are contra accounts and expense accounts that add or deduct from other accounts to form a net amount.)</p>\n<table>\n<tbody>\n<tr>\n<th>Account Type</th>\n<th>Debits</th>\n<th>Credits</th>\n</tr>\n<tr>\n<td>Assets</td>\n<td>Increase asset accounts</td>\n<td>Decrease asset accounts</td>\n</tr>\n<tr>\n<td>Liabilities</td>\n<td>Decrease liability accounts</td>\n<td>Increase liability accounts</td>\n</tr>\n<tr>\n<td>Owner’s equity</td>\n<td>Decrease owner’s equity accounts</td>\n<td>Increase owner’s equity accounts</td>\n</tr>\n<tr>\n<td>Income</td>\n<td>Decrease income accounts</td>\n<td>Increase income accounts</td>\n</tr>\n<tr>\n<td>Expenses</td>\n<td>Increase expense accounts</td>\n<td>Decrease expense accounts</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Keyboard shortcuts","thumb":null,"image":null,"content":"<p>When you’re working in QuickBooks Simple Start, take advantage of keyboard shortcuts for efficiency. Although they may take a while to internalize, keyboard shortcuts can save you a lot of time. This guide represents the PC keys to press and the action that occurs:</p>\n<table>\n<tbody>\n<tr>\n<th>Press This PC Shortcut</th>\n<th>And QuickBooks Does This</th>\n</tr>\n<tr>\n<td>Alt</td>\n<td>Activates the menu bar so you can select command names by<br />\npressing the underlined letter in the menu or command name</td>\n</tr>\n<tr>\n<td>Alt+F4</td>\n<td>Exits the QuickBooks program</td>\n</tr>\n<tr>\n<td>Ctrl+A</td>\n<td>Displays the Chart of Accounts window</td>\n</tr>\n<tr>\n<td>Ctrl+C</td>\n<td>Copies your selection to the clipboard</td>\n</tr>\n<tr>\n<td>Ctrl+D</td>\n<td>Within a register window, deletes the selected transaction</td>\n</tr>\n<tr>\n<td>Ctrl+E</td>\n<td>Within a register window, opens the selected transaction so you<br />\ncan edit it</td>\n</tr>\n<tr>\n<td>Ctrl+F</td>\n<td>Displays the Find window</td>\n</tr>\n<tr>\n<td>Ctrl+G</td>\n<td>Goes to the other side of a transfer transaction</td>\n</tr>\n<tr>\n<td>Ctrl+I</td>\n<td>Displays the Create Invoice window</td>\n</tr>\n<tr>\n<td>Ctrl+J</td>\n<td>Displays the Customer list window</td>\n</tr>\n<tr>\n<td>Ctrl+ N</td>\n<td>When you’re working with a window—such as the<br />\nCreate Invoices window or the Write Checks window—displays an<br />\nempty, fresh window so you can add a new transaction</td>\n</tr>\n<tr>\n<td>Ctrl+V</td>\n<td>Pastes the contents of the clipboard</td>\n</tr>\n<tr>\n<td>Ctrl+X</td>\n<td>Moves your selection to the clipboard</td>\n</tr>\n<tr>\n<td>Ctrl+Z</td>\n<td>Undoes your last action — usually</td>\n</tr>\n<tr>\n<td>Ctrl+Ins</td>\n<td>Inserts a line into a list of items or expenses</td>\n</tr>\n<tr>\n<td>Ctrl+Del</td>\n<td>Deletes the selected line from a list of items or expenses</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Right-click to perform common tasks","thumb":null,"image":null,"content":"<p>To perform a common task related to a window, transaction, or item in QuickBooks Simple Start, you can use the right mouse button to display a shortcut menu. For example, right-clicking often displays commands for deleting or voiding the transaction, or creating a QuickReport on the transaction. The commands vary depending on the type of transaction you select or the window you’ve right-clicked:</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\">In a register, select and right-click a specific transaction</p>\n</li>\n<li>\n<p class=\"first-para\">In a list, right-click an item</p>\n</li>\n<li>\n<p class=\"first-para\">In a form, display a transaction and right-click a blank area of the form.</p>\n</li>\n<li>\n<p class=\"first-para\">In a list window, right-click somewhere inside the window.</p>\n</li>\n</ul>\n"},{"title":"Some user interface tricks","thumb":null,"image":null,"content":"<p>Working your way through QuickBooks Simple Start is easier when you use these tricks to navigate through the QuickBooks Simple Start program and interact with the system’s displays. Here are a few user interface tips:</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\">To get help, press the F1 function key. QuickBooks starts the Help program and shows you information about the part of the QuickBooks program you’re working in.</p>\n</li>\n<li>\n<p class=\"first-para\">To move quickly to a specific list box entry, press the letter.</p>\n</li>\n<li>\n<p class=\"first-para\">To select a list box entry and choose a dialog box’s suggested command button, double-click the entry.</p>\n</li>\n<li>\n<p class=\"first-para\">To move the insertion point to the beginning of a field, press Home.</p>\n</li>\n<li>\n<p class=\"first-para\">To move the insertion point to the end of a field, press End.</p>\n</li>\n<li>\n<p class=\"first-para\">To move to another program, click the other program’s button on the Windows task bar. To move back to the QuickBooks program, click the QuickBooks task bar button.</p>\n</li>\n<li>\n<p class=\"first-para\">To minimize the QuickBooks program window (so you can see or work with whatever is underneath the QuickBooks program window), click the Minimize button in the upper-right corner of the Quickbooks program window. The minimize window shows a picture of a task bar button.</p>\n</li>\n</ul>\n"},{"title":"Some calculation and editing tricks","thumb":null,"image":null,"content":"<p>These Quickbooks Simple Start tips can help you work easily through math calculations if you’re in the amount field, and editing the day if you’re in the date field. Here’s a guide for help:</p>\n<p>If the selection cursor is on amount field, you can use these symbol keys to make calculations:</p>\n<table>\n<tbody>\n<tr>\n<th>Press</th>\n<th>What Happens</th>\n</tr>\n<tr>\n<td>+</td>\n<td>To add the number you just typed to the next number you<br />\ntype</td>\n</tr>\n<tr>\n<td>&#8211;</td>\n<td>To subtract the next number you type from the number you just<br />\ntyped</td>\n</tr>\n<tr>\n<td>*</td>\n<td>To multiply the number you just typed by the next number you<br />\ntype</td>\n</tr>\n<tr>\n<td>/</td>\n<td>To divide the number you just typed by the next number you<br />\ntype</td>\n</tr>\n</tbody>\n</table>\n<p>If the selection cursor is on a date field, you can use these tricks to edit the date:</p>\n<table>\n<tbody>\n<tr>\n<th>Press</th>\n<th>What Happens</th>\n</tr>\n<tr>\n<td>+</td>\n<td>Adds one day to the date shown</td>\n</tr>\n<tr>\n<td>t</td>\n<td>Replaces the date shown with <b>t</b>oday’s date</td>\n</tr>\n<tr>\n<td>–</td>\n<td>Subtracts one day from the date shown</td>\n</tr>\n<tr>\n<td>y</td>\n<td>Changes the date to the first day in the <b>y</b>ear</td>\n</tr>\n<tr>\n<td>r</td>\n<td>Changes the date to the last day in the yea<b>r</b></td>\n</tr>\n<tr>\n<td>m</td>\n<td>Changes the date to the first day in the <b>m</b>onth</td>\n</tr>\n<tr>\n<td>h</td>\n<td>Changes the date to the last day in the mont<b>h</b></td>\n</tr>\n</tbody>\n</table>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-04-27T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":209292},{"headers":{"creationTime":"2016-07-14T20:10:56+00:00","modifiedTime":"2022-04-26T16:17:54+00:00","timestamp":"2022-04-26T18:01:03+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"SharePoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33649"},"slug":"sharepoint","categoryId":33649}],"title":"SharePoint 2016 For Dummies Cheat Sheet","strippedTitle":"sharepoint 2016 for dummies cheat sheet","slug":"sharepoint-2016-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Get up to speed quickly on SharePoint 2016, including its technology mix, templates, apps, web parts, and page types.","noIndex":0,"noFollow":0},"content":"Microsoft SharePoint Server 2016 provides a web-based platform that your organization can leverage to be more productive and more competitive. With SharePoint 2016, you can manage content, publish information, track processes, and manage your overall business activities.\r\n\r\nIn addition, SharePoint 2016 provides social features, such as microblogging, feeds, likes, mentions, and hash tags, to get everyone in your organization on the same page and communicating effectively.","description":"Microsoft SharePoint Server 2016 provides a web-based platform that your organization can leverage to be more productive and more competitive. With SharePoint 2016, you can manage content, publish information, track processes, and manage your overall business activities.\r\n\r\nIn addition, SharePoint 2016 provides social features, such as microblogging, feeds, likes, mentions, and hash tags, to get everyone in your organization on the same page and communicating effectively.","blurb":"","authors":[{"authorId":9718,"name":"Ken Withee","slug":"ken-withee","description":"Ken Withee is a Microsoft certified technology specialist in SharePoint, SQL Server, and .NET.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9718"}},{"authorId":10888,"name":"Rosemarie Withee","slug":"rosemarie-withee","description":"Rosemarie Withee is a technology professional who has authored a number of books in the For Dummies series, including the most recent editions of Office 365 For Dummies and SharePoint For Dummies. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10888"}}],"primaryCategoryTaxonomy":{"categoryId":33649,"title":"SharePoint","slug":"sharepoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33649"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":227044,"title":"Understanding Workflow in SharePoint 2016","slug":"understanding-workflow-sharepoint-2016","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227044"}},{"articleId":227040,"title":"How to Create Email Alerts for a SharePoint Group","slug":"create-email-alerts-sharepoint-group","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227040"}},{"articleId":227036,"title":"How to Make Local Changes to Your SharePoint Team Navigation with the Quick Launch","slug":"make-local-changes-sharepoint-team-navigation-quick-launch","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227036"}},{"articleId":227012,"title":"How to Make Global Changes to Your SharePoint Team Navigation with the Top Link Bar","slug":"make-global-changes-sharepoint-team-navigation-top-link-bar","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227012"}},{"articleId":227031,"title":"Managing SharePoint Designer Access","slug":"managing-sharepoint-designer-access","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/227031"}}],"fromCategory":[{"articleId":264458,"title":"How to Build a SharePoint PowerApp","slug":"how-to-build-a-sharepoint-powerapp","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/264458"}},{"articleId":264447,"title":"How to Share and Follow SharePoint Sites","slug":"how-to-share-and-follow-sharepoint-sites","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/264447"}},{"articleId":264439,"title":"How to Integrate SharePoint with Power BI","slug":"how-to-integrate-sharepoint-with-power-bi","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/264439"}},{"articleId":264425,"title":"The SharePoint Mobile App","slug":"the-sharepoint-mobile-app","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/264425"}},{"articleId":264414,"title":"How to Get Up and Running with SharePoint 2019 in 3 Minutes Flat","slug":"how-to-get-up-and-running-with-sharepoint-2019-in-3-minutes-flat","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/264414"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281862,"slug":"sharepoint-2016-for-dummies","isbn":"9781119181705","categoryList":["technology","software","microsoft-products","sharepoint"],"amazon":{"default":"https://www.amazon.com/gp/product/1119181704/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119181704/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119181704-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119181704/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119181704/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/sharepoint-2016-for-dummies-cover-9781119181705-203x255.jpg","width":203,"height":255},"title":"SharePoint 2016 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"10888\">Rosemarie Withee</b> is President of Portal Integrators LLC and Founder of Scrum Now with locations in Seattle, WA and Laguna, Philippines. She is also the lead author of <i>Office 365 For Dummies</i>. </p>\n<p><b data-author-id=\"9718\">Ken Withee</b> writes TechNet and MSDN articles for Microsoft and is the author of <i>SharePoint 2013 For Dummies</i>. </p>","authors":[{"authorId":10888,"name":"Rosemarie Withee","slug":"rosemarie-withee","description":"Rosemarie Withee is a technology professional who has authored a number of books in the For Dummies series, including the most recent editions of Office 365 For Dummies and SharePoint For Dummies. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10888"}},{"authorId":9718,"name":"Ken Withee","slug":"ken-withee","description":"Ken Withee is a Microsoft certified technology specialist in SharePoint, SQL Server, and .NET.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9718"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;sharepoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119181705&quot;]}]\" id=\"du-slot-6268335fe8de6\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;sharepoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119181705&quot;]}]\" id=\"du-slot-6268335fe978c\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":221369,"title":"Understanding the SharePoint 2016 Technology Mix","slug":"understanding-sharepoint-2016-technology-mix","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/221369"}},{"articleId":221372,"title":"Common Site Templates in SharePoint 2016","slug":"common-site-templates-sharepoint-2016","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/221372"}},{"articleId":221375,"title":"Common Apps in SharePoint 2016","slug":"common-apps-sharepoint-2016","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/221375"}},{"articleId":221378,"title":"Common Web Parts in SharePoint 2016","slug":"common-web-parts-sharepoint-2016","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/221378"}},{"articleId":221382,"title":"SharePoint 2016 Page Types","slug":"sharepoint-2016-page-types","categoryList":["technology","software","microsoft-products","sharepoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/221382"}}],"content":[{"title":"Understanding the SharePoint 2016 technology mix","thumb":null,"image":null,"content":"<p>SharePoint 2016 is a massive and complex product. Not only is SharePoint itself complicated but it relies on a whole series of other technologies to make the magic happen.</p>\n<p>The SharePoint 2016 technology stack consists of:</p>\n<ul>\n<li><strong>Computer servers:</strong> At the root of any software system is a physical device called a server. A server is no different than your laptop, desktop, or even phone. They all use physical computer chips to make things happen in the digital world. A server is just designed specifically for heavy duty enterprise type software.</li>\n<li><strong>Operating systems:</strong> A physical computer isn’t much more than a paper weight or door stop without software to make it function. The software designed to make computers do stuff is called an operating system. In the Microsoft world the operating system designed for servers is called, aptly enough, Windows Server.</li>\n<li><strong>Databases:</strong> A database is installed onto the operating system and is specifically designed and optimized to store and manipulate data. The Microsoft database product is called SQL Server. SharePoint leverages the advanced capabilities of SQL Server in order to provide the features explored throughout the book.</li>\n<li><strong>Web servers:</strong> SharePoint is software that you interact with using your web browser. A special software product called a web server is the engine that delivers web pages to your web browser. The Microsoft web server is called Internet Information Services (IIS).</li>\n</ul>\n<p>It takes this entire stack of technology to make SharePoint possible. You could even say it takes a software village. When this stack of software is in place, your IT team can install SharePoint.</p>\n<p>When your IT team installs SharePoint on your local premises it is called SharePoint On Premise. When you buy SharePoint as a service from Microsoft and access it over the Internet it is called SharePoint Online. With SharePoint Online the software stack is installed in Microsoft’s data centers and they take of things like installing, managing, backing up, and securing it all.</p>\n<p class=\"article-tips tip\">Letting Microsoft provide the SharePoint infrastructure lets your organization focus on your business. In particular, you can focus on leveraging SharePoint to increase your business value instead of worrying about the blinking lights of the servers and the intricacies of all of the software that makes up the stack.</p>\n<p>You have a few different options when choosing SharePoint 2016. These options include:</p>\n<ul>\n<li><strong>SharePoint Server 2016, Standard license:</strong> Intranet, portals, extranets, search, and My Site social network.</li>\n<li><strong>SharePoint Server 2016, Enterprise license:</strong> Advanced scenarios for business intelligence, application integration, and Office 2016 services.</li>\n<li><strong>SharePoint Online:</strong> The cloud-based version of SharePoint. Offered as a standalone product or bundled with Office 365. SharePoint Online includes a number of different package options, which are a mix of the SharePoint Server features. In addition, from now on Microsoft will add the latest and greatest new features to SharePoint Online. At some point in the future (maybe SharePoint 2019?), they will take all of that work with SharePoint Online and create another On-Premises version of SharePoint. If you want to stay with the latest and greatest, then SharePoint Online is your best option.</li>\n</ul>\n"},{"title":"Common site templates","thumb":null,"image":null,"content":"<p>A site template is what you use when you create a new SharePoint site. A site template just provides you with a starting setup for SharePoint. For example, if you choose a Team Site template then the site you create will include SharePoint components designed for a team. Things like a Documents App, Calendar App, Tasks App, and timeline visualization.</p>\n<p class=\"article-tips tip\">There are a number of site templates available in SharePoint 2016. Site templates are grouped into categories such as Collaboration, Enterprise, and Publishing.</p>\n<p>The site templates that you have available depend on the SharePoint edition you are using as well as the features you have activated. For example, the Business Intelligence Center template is only available with the Enterprise license. And the Publishing sites are only available when you have the SharePoint Server Publishing Infrastructure activated.</p>\n<p>The site templates you should be familiar with include:</p>\n<ul>\n<li><strong>Team Site:</strong> A template designed for teams to collaborate, share documents, and stay in sync.</li>\n<li><strong>Blog:</strong> A template that produces a blog site.</li>\n<li><strong>Project Site:</strong> A template that creates a site for managing and collaborating on a specific project.</li>\n<li><strong>Community Site:</strong> A template designed to create a site that allows community members to congregate and discuss common interests.</li>\n<li><strong>Document Center:</strong> A template designed for managing common documents in a central location</li>\n<li><strong>Records Center:</strong> A template that creates a site to manage company records.</li>\n<li><strong>Business Intelligence Center:</strong> A template with all of the functionality required for Business Intelligence in SharePoint.</li>\n<li><strong>Enterprise Search Center:</strong> A template used to create a site for search. Includes a number of search results pages for specialized queries like searching people, conversations, videos, and general.</li>\n<li><strong>Basic Search Center:</strong> A template used to create a general search center site. The basic lacks the multiple results pages of the enterprise class search center.</li>\n<li><strong>Visio Process Repository:</strong> A template that you can choose when creating a site for storing business processes in Microsoft Office Visio format.</li>\n<li><strong>Publishing Site:</strong> A template that creates a blank publishing site. A publishing site is used to publish web pages for mass consumption.</li>\n<li><strong>Publishing Site with Workflow:</strong> A template that provides the capabilities of the Publishing Site template and also includes approval workflows.</li>\n<li><strong>Enterprise Wiki:</strong> A template for creating a site to capture and store information from a group collective.</li>\n</ul>\n"},{"title":"Common apps in SharePoint 2016","thumb":null,"image":null,"content":"<p>An app is a component in SharePoint that performs some duty. An app might be created to store accounting documents or track customer contacts. If you are familiar with the idea of lists and libraries, then you are familiar with apps.</p>\n<p>When you create an app you choose the type of template it should use. There are templates for things like libraries, lists, calendars, tasks, and discussion boards. When you add an app to your site you give it a name. For example, you might add a Calendar app and call it Company Holidays.</p>\n<p class=\"article-tips remember\">What can be confusing is that apps are often named the same thing as their templates. For example, if you are using a site with an app called Document Library based on the Document Library app template, then understanding apps would be very confusing.</p>\n<p class=\"article-tips remember\">If you create your own app called My Documents App and then choose the Document Library template then the differences are easy to notice. You can see that you could create a My Documents App 1, My Documents App 2, and My Documents App 3, which could all use the same template: Document Library.</p>\n<p>The apps that you have available depend on the SharePoint 2016 edition you are using as well as the features you have activated. For example, the Report Library app is only available with the Enterprise license.</p>\n<p>The following are common apps that you should be aware of.</p>\n<ul>\n<li><strong>Document Library:</strong> Used to create apps that hold documents.</li>\n<li><strong>Form Library:</strong> Creates an app that holds business forms. This library requires a compatible editor such as InfoPath.</li>\n<li><strong>Wiki Page Library:</strong> Used to create apps that store wiki pages.</li>\n<li><strong>Picture Library:</strong> Using this template you create apps to store pictures.</li>\n<li><strong>Links:</strong> Creates an app that contains HTML links.</li>\n<li><strong>Announcements:</strong> Results in an app that can be used for announcements.</li>\n<li><strong>Contacts:</strong> Creates an app to store contacts.</li>\n<li><strong>Calendar:</strong> A template used to create calendar apps.</li>\n<li><strong>Discussion Board:</strong> Creates an app where users can discuss topics in a threaded forum.</li>\n<li><strong>Promoted Links:</strong> An app template that creates a place to store links to specific actions using a visual tile based layout. When you create a new Team Site it includes an app based on the Promoted Links template. When you move the mouse over a tile, information pops up to describe what will happen when the link is clicked.</li>\n<li><strong>Tasks:</strong> A template used to create apps to store tasks.</li>\n<li><strong>Issue Tracking:</strong> Used to create an app to track issues.</li>\n<li><strong>Custom List:</strong> A template that creates a blank app based on a list.</li>\n<li><strong>Custom List in Datasheet View:</strong> This template is similar to the Custom List template but provides a datasheet view by default.</li>\n<li><strong>External List:</strong> Used to create an app that connects to external data.</li>\n<li><strong>Survey:</strong> Creates an app that is used to conduct surveys.</li>\n<li><strong>Asset Library:</strong> A template used to create an app that stores site assets such as images, audio, and video files.</li>\n<li><strong>Data Connection Library:</strong> Creates an app that stores data connections.</li>\n<li><strong>Report Library:</strong> Used to create an app to store reports.</li>\n<li><strong>Access App:</strong> A template used to create an app that is the Office Access web based app.</li>\n<li><strong>Import Spreadsheet:</strong> A template used to import a spreadsheet. The result is an app that contains the data in the spreadsheet. The equivalent could be done manually by creating the app using the Custom List template, adding all of the columns in the spreadsheet, and then keying in all of the data.</li>\n</ul>\n"},{"title":"Common web parts","thumb":null,"image":null,"content":"<p><em>Web parts</em> are reusable components that display content on web pages in SharePoint 2016. Web parts are a fundamental component in building SharePoint pages. There are a number of web parts that ship right out of the box with the different editions of SharePoint and you can also purchase third-party web parts that plug right into your SharePoint environment.</p>\n<p class=\"article-tips tip\">The web parts that you have available depend on the SharePoint 2016 edition you are using as well as on the features you have activated. For example, the PerformancePoint web parts are only available with the Enterprise license and when the PerformancePoint Services feature is activated. And the Project Web app web parts are only available when you have installed Project Server.</p>\n<p>The following is a list of the common web part categories that you should be familiar with:</p>\n<ul>\n<li><strong>Apps:</strong> Each app instance you have added to your site has an associated web part. The app web parts allow you to add a view into the data in your app to your web pages.</li>\n<li><strong>Blog:</strong> Provides web parts for a blog site.</li>\n<li><strong>Business Data:</strong> A grouping of web parts designed to display business information such as status, indicators, and other business data. This grouping also includes web parts for embedding Excel and Visio documents and for displaying data from Business Connectivity Services (BCS). BCS is a component of SharePoint that allows you to connect to data that is stored outside of SharePoint.</li>\n<li><strong>Community:</strong> The Community grouping contains web parts for the community features of SharePoint. This includes things like membership, joining a community, and information about the community. In addition, there are tools for community administrators.</li>\n<li><strong>Content Rollup:</strong> Contains web parts that are used to rollup (aggregate) content. There are web parts for rolling up search results, providing project summaries, displaying timelines, and showing relevant documents from throughout the site.</li>\n<li><strong>Document Sets:</strong> Web parts specifically designed for working with sets of documents.</li>\n<li><strong>Filters:</strong> Web parts that can be used to filter information. These web parts are designed to be connected with other web parts in order to provide a useful filtering mechanism. For example, you might have a list of content and want users to be able to filter based on certain criteria. You could use these web parts to provide the filter mechanism.</li>\n<li><strong>Forms:</strong> Web parts that allow you to embed HTML or InfoPath forms in a page.</li>\n<li><strong>Media and Content:</strong> This category provides web parts that display media such as images, videos, and pages. In addition, there is also a web part for displaying Silverlight applications.</li>\n<li><strong>PerformancePoint:</strong> Web parts specifically designed for PerformancePoint services.</li>\n<li><strong>Project Web App:</strong> Web parts specifically designed for Project Server. These web parts include functionality for displaying information about a project such as issues, tasks, timesheets, and status.</li>\n<li><strong>Search:</strong> Provides web parts for search functionality such as the search box for entering a query, search results, and refinement of results.</li>\n<li><strong>Search-Driven Content:</strong> Provides web parts that display content based on search. For example, there are web parts to show items matching a certain tag, pages based on a search query, and recently changed items.</li>\n<li><strong>Social Collaboration:</strong> This category contains web parts designed for the social components of SharePoint such as user contact details, shared note board, tag clouds, and user tasks.</li>\n</ul>\n"},{"title":"SharePoint 2016 page types","thumb":null,"image":null,"content":"<p>There are a few things you should know about SharePoint 2016 page types. A web page is a document that is displayed in your web browser. The only difference between a web page and a regular text document is that a web page has special markup that tells the web browser how to display it.</p>\n<p class=\"article-tips tip\">SharePoint takes the details of the special markup and throws it behind the scenes. What you are left with is a few different types of pages you can add to your SharePoint sites.</p>\n<p>These include:</p>\n<ul>\n<li><strong>Wiki page:</strong> A wiki page is also known as a content page. You can add content to them by typing and formatting text. In addition, you can insert images and web parts. Adding content to a wiki page is much like working with Office Word in that all of the capabilities for formatting content are contained at the top of the page in the Ribbon. And as the name implies, a wiki page handles all of the wiki commands such as the [ and ] characters.</li>\n<li><strong>Web Part page:</strong> A web part page is specifically designed for Web Parts. A Web Part page includes web part zones where you can add Web Parts. Using a web part page you can drag web parts between zones and connect them to each other. There are multiple web part zone layouts you can choose from when creating a web part page.</li>\n<li><strong>Publishing page:</strong> The publishing page is used when you need to create a separation between the publishing of content and the layout of the content on the page. A publishing page allows you to create a standard page layout and then let multiple users enter content using the page layout. This allows you to have users familiar with their content, but not SharePoint layouts, publish to the site while still maintaining the look and feel.</li>\n</ul>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Two years","lifeExpectancySetFrom":"2022-04-26T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":221385},{"headers":{"creationTime":"2016-03-27T16:56:40+00:00","modifiedTime":"2022-04-20T19:36:05+00:00","timestamp":"2022-04-21T00:01:03+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Excel 2010 All-in-One For Dummies Cheat Sheet","strippedTitle":"excel 2010 all-in-one for dummies cheat sheet","slug":"excel-2010-all-in-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Hot keys, menu commands, formulas, and more — learn about all the features included in Excel 2010 and how to use them.","noIndex":0,"noFollow":0},"content":"As an integral part of the Ribbon interface used by the major applications included in Microsoft Office 2010, Excel gives you access to hot keys that can help you select program commands more quickly. As soon as you press the Alt key, Excel displays the mnemonic letter choices on the various tabs and command buttons on the Ribbon. Then, simply press the mnemonic (or not-so-mnemonic) letters to perform a particular task.","description":"As an integral part of the Ribbon interface used by the major applications included in Microsoft Office 2010, Excel gives you access to hot keys that can help you select program commands more quickly. As soon as you press the Alt key, Excel displays the mnemonic letter choices on the various tabs and command buttons on the Ribbon. Then, simply press the mnemonic (or not-so-mnemonic) letters to perform a particular task.","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":206080,"title":"How to Get Help in Excel 2010","slug":"how-to-get-help-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206080"}},{"articleId":206076,"title":"How to Customize the Excel 2010 Ribbon","slug":"how-to-customize-the-excel-2010-ribbon","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206076"}},{"articleId":206066,"title":"How to Create a New Custom Dictionary in Excel 2010","slug":"how-to-create-a-new-custom-dictionary-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206066"}},{"articleId":206056,"title":"How to Translate Text in Excel 2010","slug":"how-to-translate-text-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206056"}},{"articleId":206054,"title":"Creating Your Own Excel 2010 Templates","slug":"creating-your-own-excel-2010-templates","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206054"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281701,"slug":"excel-2010-all-in-one-for-dummies","isbn":"9780470489598","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/0470489596/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/0470489596/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/0470489596-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/0470489596/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/0470489596/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/excel-2010-all-in-one-for-dummies-cover-9780470489598-203x255.jpg","width":203,"height":255},"title":"Excel 2010 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is president of Mind Over Media, Inc. He is the author of all editions of <i>Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies</i>, and <i>Windows For Dummies Quick Reference</i>. He's also an experienced educator. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489598&quot;]}]\" id=\"du-slot-62609ec00782d\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489598&quot;]}]\" id=\"du-slot-62609ec0081b5\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":193174,"title":"File Menu Commands: Common Excel 2010 Hot Keys","slug":"file-menu-commands-common-excel-2010-hot-keys","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193174"}},{"articleId":193169,"title":"Hot Keys for Excel 2010 Editing Commands","slug":"hot-keys-for-excel-2010-editing-commands","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193169"}},{"articleId":193176,"title":"Excel 2010 View Commands Hot Keys","slug":"excel-2010-view-commands-hot-keys","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193176"}},{"articleId":193175,"title":"Hot Keys for Common Excel 2010 Formula Commands","slug":"hot-keys-for-common-excel-2010-formula-commands","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193175"}}],"content":[{"title":"File menu commands: common Excel 2010 hot keys","thumb":null,"image":null,"content":"<p>To activate the Excel 2010 hot keys, you press the Alt key before typing the mnemonic letters for a particular task. The mnemonic letter is <em>F </em>(for File) for the commands on the File menu in the new Backstage View. All you have to remember, then, is the second letter in the sequence; unfortunately, not all of the second letters are intuitive, as you can see in the following table.</p>\n<table border=\"0\">\n<tbody>\n<tr>\n<th>Hot Key</th>\n<th>Excel Ribbon Command</th>\n<th>Function</th>\n</tr>\n<tr>\n<td>Alt+FS</td>\n<td>File Menu→Save</td>\n<td>Saves changes to a workbook. When you first select this command for a new workbook, Excel displays the Save As dialog box</td>\n</tr>\n<tr>\n<td>Alt+FA</td>\n<td>File Menu→Save As</td>\n<td>Display the Save As dialog box in the regular worksheet view where you can modify the filename, location where the file is saved, and format that the file is saved in</td>\n</tr>\n<tr>\n<td>Alt+FO</td>\n<td>File Menu→Open</td>\n<td>Displays the Open dialog box in the regular worksheet view where you can select a new Excel workbook to open for editing or printing</td>\n</tr>\n<tr>\n<td>Alt+FC</td>\n<td>File Menu→Close</td>\n<td>Closes the current workbook without exiting Excel</td>\n</tr>\n<tr>\n<td>Alt+FI</td>\n<td>File Menu→Info</td>\n<td>Displays the Information panel in the Backstage View where you can see a preview of the current worksheet along with statistics about the workbook as well as protect the workbook, check the file for compatibility issues, and manage different versions created by the AutoRecover feature</td>\n</tr>\n<tr>\n<td>Alt+FR</td>\n<td>File Menu→Recent</td>\n<td>Displays a list of the last 20 workbook files most recently opened for editing in Excel</td>\n</tr>\n<tr>\n<td>Alt+FN</td>\n<td>File Menu→New</td>\n<td>Displays the Available Templates panel in the Backstage View box where you can open a blank workbook or one from a template</td>\n</tr>\n<tr>\n<td>Alt+FP</td>\n<td>File Menu→Print</td>\n<td>Displays the Print panel in the Backstage View where you can change the print settings before sending the current worksheet, workbook, or cell selection to the printer</td>\n</tr>\n<tr>\n<td>Alt+FD</td>\n<td>File Menu→Save &amp; Send</td>\n<td>Displays the Save &amp; Send panel in the Backstage View where you can send the current workbook as an e-mail attachment, save it in a new file format, or save it online to your company’s SharePoint site or your own Windows Live SkyDrive</td>\n</tr>\n<tr>\n<td>Alt+FH</td>\n<td>File Menu→Help</td>\n<td>Displays the Support panel in the Backstage View where you get help using Excel, check for updates to the program, and get statistics about the version of Excel 2010 you’re running</td>\n</tr>\n<tr>\n<td>Alt+FT</td>\n<td>File Menu→Options</td>\n<td>Displays the Excel Options dialog box in the regular worksheet view where you can change default program settings, modify the buttons on the Quick Access toolbar, and customize the Excel Ribbon</td>\n</tr>\n<tr>\n<td>Alt+FX</td>\n<td>File Menu→Exit Excel</td>\n<td>Quits the Excel program and closes all open workbooks after prompting you to save them</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Hot keys for Excel 2010 editing commands","thumb":null,"image":null,"content":"<p>To activate Excel 2010 hot keys, you press the Alt key before you type the mnemonic letters for a particular task. The mnemonic letter is <em>H </em>(Home) for the editing commands because these commands are located on the Home tab. The remaining letters in the hot key sequences are not so intuitive.</p>\n<p>Fortunately, the most common editing commands (Cut, Copy, and Paste) still respond to the old Ctrl+key sequences (Ctrl+X, Ctrl+C, and Ctrl+V), and you may find them quicker to use.</p>\n<table border=\"0\">\n<tbody>\n<tr>\n<th>Hot Key</th>\n<th>Excel Ribbon Command</th>\n<th>Function</th>\n</tr>\n<tr>\n<td>Alt+HVP</td>\n<td>Home→Paste→Paste</td>\n<td>Pastes the currently cut or copied cell selection or graphic objects in the worksheet</td>\n</tr>\n<tr>\n<td>Alt+HX</td>\n<td>Home→Cut</td>\n<td>Cuts the cell selection or selected graphic objects out of the workbook and places them on the Windows Clipboard</td>\n</tr>\n<tr>\n<td>Alt+HC</td>\n<td>Home→Copy</td>\n<td>Copies the cell selection or selected graphic objects to the Windows Clipboard</td>\n</tr>\n<tr>\n<td>Alt+HFP</td>\n<td>Home→Format Painter</td>\n<td>Activates the Format Painter</td>\n</tr>\n<tr>\n<td>Alt+HFO</td>\n<td>Home→Clipboard Dialog Box Launcher</td>\n<td>Displays and hides the Clipboard task pane</td>\n</tr>\n<tr>\n<td>Alt+HII</td>\n<td>Home→Insert→Insert Cells</td>\n<td>Opens Insert dialog box so you can indicate the direction in which to shift existing cells to make room for the ones being inserted</td>\n</tr>\n<tr>\n<td>Alt+HIR</td>\n<td>Home→Insert→Insert Sheet Rows</td>\n<td>Inserts blank rows equal to the number of rows in the cell selection</td>\n</tr>\n<tr>\n<td>Alt+HIC</td>\n<td>Home→Insert→Insert Sheet Columns</td>\n<td>Inserts blank columns equal to the number of columns in the cell selection</td>\n</tr>\n<tr>\n<td>Alt+HIS</td>\n<td>Home→Insert→Insert Sheet</td>\n<td>Inserts a new worksheet in the workbook</td>\n</tr>\n<tr>\n<td>Alt+HDD</td>\n<td>Home→Delete→Delete Cells</td>\n<td>Opens Delete dialog box so you can indicate the direction in which to shift existing cells to replace the ones being deleted</td>\n</tr>\n<tr>\n<td>Alt+HDR</td>\n<td>Home→Delete→Delete Sheet Rows</td>\n<td>Deletes rows equal to the number of rows in the cell selection</td>\n</tr>\n<tr>\n<td>Alt+HDC</td>\n<td>Home→Delete→Delete Sheet Columns</td>\n<td>Deletes columns equal to the number of columns in the cell selection</td>\n</tr>\n<tr>\n<td>Alt+HDS</td>\n<td>Home→Delete→Sheet</td>\n<td>Deletes the current worksheet after warning you of data loss if the sheet contains cell entries</td>\n</tr>\n<tr>\n<td>Alt+HEA</td>\n<td>Home→Clear→Clear All</td>\n<td>Clears the contents, formatting, and comments from the cell selection</td>\n</tr>\n<tr>\n<td>Alt+HEF</td>\n<td>Home→Clear→Clear Formats</td>\n<td>Clears the formatting of the cell selection without removing the contents and comments</td>\n</tr>\n<tr>\n<td>Alt+HEC</td>\n<td>Home→Clear→Clear Contents</td>\n<td>Clears the contents of the cell selection without removing the formatting and comments</td>\n</tr>\n<tr>\n<td>Alt+HEM</td>\n<td>Home→Clear→Clear Comments</td>\n<td>Clears all comments in the cell selection without removing the formatting and contents</td>\n</tr>\n<tr>\n<td>Alt+HEL</td>\n<td>Home→Clear→Clear Hyperlinks</td>\n<td>Clears all hyperlinks in the cell selection without removing the formatting and contents</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Excel 2010 view commands hot keys","thumb":null,"image":null,"content":"<p>You can activate the Excel 2010 hot keys by pressing the Alt key before you type the mnemonic letters for a particular task. The mnemonic letter for all view-related commands in Excel 2010 is <i>W</i> (the last letter you see in <i>vieW</i>). Therefore, all the hot keys for switching the Excel worksheet into a new view begin with Alt+W. Remember that, and you’ll find most of the subsequent letters fairly easy to deal with.</p>\n<table>\n<tbody>\n<tr>\n<th>Hot Key</th>\n<th>Excel Ribbon Command</th>\n<th>Function</th>\n</tr>\n<tr>\n<td>Alt+WL</td>\n<td>View→Normal View</td>\n<td>Returns the worksheet to normal view from Page Layout or Page<br />\nBreak Preview</td>\n</tr>\n<tr>\n<td>Alt+WP</td>\n<td>View→Page Layout View</td>\n<td>Puts the worksheet into Page Layout View showing the page<br />\nbreaks, margins, and rulers</td>\n</tr>\n<tr>\n<td>Alt+WI</td>\n<td>View→Page Break Preview</td>\n<td>Puts the worksheet into Page Break Preview showing pages breaks<br />\nthat you can adjust</td>\n</tr>\n<tr>\n<td>Alt+WE</td>\n<td>View→Full Screen</td>\n<td>Puts the worksheet in full-screen mode which hides the File<br />\nMenu, Quick Access toolbar, and Ribbon — press the Esc key to<br />\nrestore previous viewing mode</td>\n</tr>\n<tr>\n<td>Alt+WVG</td>\n<td>View→Gridlines</td>\n<td>Hides and redisplays the row and column gridlines that form the<br />\ncells in the Worksheet area</td>\n</tr>\n<tr>\n<td>Alt+WG</td>\n<td>View→Zoom to Selection</td>\n<td>Zooms the Worksheet area in or out to the magnification<br />\npercentage needed to display just the cell selection</td>\n</tr>\n<tr>\n<td>Alt+WJ</td>\n<td>View→100%</td>\n<td>Returns the Worksheet area to the default 100% magnification<br />\npercentage</td>\n</tr>\n<tr>\n<td>Alt+WN</td>\n<td>View→New Window</td>\n<td>Inserts a new window in the current workbook</td>\n</tr>\n<tr>\n<td>Alt+WA</td>\n<td>View→Arrange All</td>\n<td>Opens the Arrange dialog box where you can select how workbook<br />\nwindows are displayed on the screen</td>\n</tr>\n<tr>\n<td>Alt+WF</td>\n<td>View→Freeze Panes</td>\n<td>Opens the Freeze Panes drop-down menu where you select how to<br />\nfreeze rows and columns in the Worksheet area: Freeze Panes (to<br />\nfreeze all the rows above and columns to the left of the cell<br />\ncursor); Freeze Top Row; or Freeze First Column</td>\n</tr>\n<tr>\n<td>Alt+WS</td>\n<td>View→Split</td>\n<td>Splits the worksheet into four panes using the top and left<br />\nedge of the cell cursor as the vertical and horizontal dividing<br />\nlines — press hot keys again to remove all panes</td>\n</tr>\n<tr>\n<td>Alt+WH</td>\n<td>View→Hide</td>\n<td>Hides the current worksheet window or workbook</td>\n</tr>\n<tr>\n<td>Alt+WU</td>\n<td>View→Unhide</td>\n<td>Opens the Unhide dialog box where you can select the window or<br />\nworkbook to redisplay</td>\n</tr>\n<tr>\n<td>Alt+WB</td>\n<td>View→View Side by Side</td>\n<td>Tiles two open windows or workbooks one above the other for<br />\ncomparison — press hot keys again to restore the original<br />\nfull windows</td>\n</tr>\n<tr>\n<td>Alt+WW</td>\n<td>View→Switch Windows</td>\n<td>Opens the Switch Windows drop-down menu where you can select<br />\nthe open window or workbook to make active</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Hot keys for common Excel 2010 formula commands","thumb":null,"image":null,"content":"<p>You activate Excel 2010 hot keys by pressing the Alt key before you type the mnemonic letter for a particular task. Hot key sequences for the most common formula-related commands in Excel 2010 begin with the sequence Alt+M because the <i>M</i> in <i>forMulas</i> was the only mnemonic key still available (<i>F</i> is assigned to the File menu commands). After you know to press Alt+M to access Formula tab commands, it’s pretty easy sailing.</p>\n<table>\n<tbody>\n<tr>\n<th>Hot Key</th>\n<th>Excel Ribbon Command</th>\n<th>Function</th>\n</tr>\n<tr>\n<td>Alt+MF</td>\n<td>Formulas→Insert Function</td>\n<td>Opens the Insert Function dialog box (same as clicking the<br />\nInsert Function button on the Formula bar</td>\n</tr>\n<tr>\n<td>Alt+MUS</td>\n<td>Formulas→AutoSum→Sum</td>\n<td>Selects the occupied range above the cell cursor and inserts<br />\nSUM formula to total the range</td>\n</tr>\n<tr>\n<td>Alt+MUA</td>\n<td>Formulas→AutoSum→Average</td>\n<td>Selects the occupied range above the cell cursor and inserts<br />\nAVERAGE formula to calculate the average of total in the range</td>\n</tr>\n<tr>\n<td>Alt+MUC</td>\n<td>Formulas→AutoSum→Count Numbers</td>\n<td>Selects the occupied range above the cell cursor and inserts<br />\nCOUNT formula to count the number of values in the range</td>\n</tr>\n<tr>\n<td>Alt+MI</td>\n<td>Formulas→Financial</td>\n<td>Opens a drop-down menu listing all Financial functions —<br />\nclick name to insert function into current cell</td>\n</tr>\n<tr>\n<td>Alt+ME</td>\n<td>Formulas→Date &amp; Time</td>\n<td>Opens a drop-down menu listing all Date and Time functions<br />\n— click name to insert function into current cell</td>\n</tr>\n<tr>\n<td>Alt+MN</td>\n<td>Formulas→Name Manager</td>\n<td>Opens Name Manager dialog box showing all range names in<br />\nworkbook where you can add, edit, and delete names</td>\n</tr>\n<tr>\n<td>Alt+MMD</td>\n<td>Formulas→Define Name</td>\n<td>Opens New Name dialog box where you can assign a name to the<br />\ncell selection or define a new constant</td>\n</tr>\n<tr>\n<td>Alt+MS</td>\n<td>Formulas→Use in Formula</td>\n<td>Displays drop-down menu with range names in workbook that you<br />\ncan insert into current formula by clicking</td>\n</tr>\n<tr>\n<td>Alt+MC</td>\n<td>Formulas→Create from Selection</td>\n<td>Opens Create Names from Selection dialog box where you indicate<br />\nwhich rows and columns to use in naming cell selection</td>\n</tr>\n<tr>\n<td>Alt+MH</td>\n<td>Formulas→Show Formulas (Ctrl+`)</td>\n<td>Displays and then hides all formulas in cells of the<br />\nworksheet</td>\n</tr>\n<tr>\n<td>Alt+MXA</td>\n<td>Formulas→Options→Automatic</td>\n<td>Turns automatic recalculation back on</td>\n</tr>\n<tr>\n<td>Alt+MXE</td>\n<td>Formulas→Options→Automatic Except for Data<br />\nTables</td>\n<td>Turns automatic recalculation back on for all parts of the<br />\nworksheet except for ranges with Data Tables</td>\n</tr>\n<tr>\n<td>Alt+MXM</td>\n<td>Formulas→Options→Manual</td>\n<td>Turns on manual recalculation</td>\n</tr>\n<tr>\n<td>Alt+MB</td>\n<td>Formulas→Calculate Now (F9)</td>\n<td>Recalculates formulas throughout the entire workbook when<br />\nmanual recalculation is turned on</td>\n</tr>\n<tr>\n<td>Alt+MJ</td>\n<td>Formulas→Calculate Sheet (Shift+F9)</td>\n<td>Recalculates formulas in the current worksheet when manual<br />\nrecalculation is turned on</td>\n</tr>\n</tbody>\n</table>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Five years","lifeExpectancySetFrom":"2022-04-20T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":209118},{"headers":{"creationTime":"2016-03-27T16:56:40+00:00","modifiedTime":"2022-04-18T19:06:56+00:00","timestamp":"2022-04-19T00:01:29+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Excel 2010 For Dummies Cheat Sheet","strippedTitle":"excel 2010 for dummies cheat sheet","slug":"excel-2010-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"","noIndex":0,"noFollow":0},"content":"At first glance, you might have trouble making sense of the many menus, tabs, columns, and rows of the Excel 2010 user interface. This Cheat Sheet will help you navigate your way by showing you keystrokes for moving the cell cursor to a new cell, simple rules of data-entry etiquette, common causes of some formula error values, and a quick list of the best Excel 2010 features.","description":"At first glance, you might have trouble making sense of the many menus, tabs, columns, and rows of the Excel 2010 user interface. This Cheat Sheet will help you navigate your way by showing you keystrokes for moving the cell cursor to a new cell, simple rules of data-entry etiquette, common causes of some formula error values, and a quick list of the best Excel 2010 features.","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":206078,"title":"How to Save an Excel 2010 Workbook as a PDF or XPS File","slug":"how-to-save-an-excel-2010-workbook-as-a-pdf-or-xps-file","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206078"}},{"articleId":206070,"title":"How to Rename an Excel 2010 Worksheet","slug":"how-to-rename-an-excel-2010-worksheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206070"}},{"articleId":206064,"title":"How to Drag and Drop Data in Excel 2010","slug":"how-to-drag-and-drop-data-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206064"}},{"articleId":206061,"title":"Automatically Fix Typos and Add Text with AutoCorrect in Excel 2010","slug":"automatically-fix-typos-and-add-text-with-autocorrect-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206061"}},{"articleId":206057,"title":"How to Insert Symbols and Special Characters in Excel 2010","slug":"how-to-insert-symbols-and-special-characters-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206057"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281702,"slug":"excel-2010-for-dummies","isbn":"9780470489536","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/0470489537-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/0470489537/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/excel-2010-for-dummies-cover-9780470489536-203x255.jpg","width":203,"height":255},"title":"Excel 2010 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is president of Mind Over Media, Inc. He is the author of all editions of <i>Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies</i>, and <i>Windows For Dummies Quick Reference</i>. He's also an experienced educator. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-625dfbd983013\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9780470489536&quot;]}]\" id=\"du-slot-625dfbd9839a9\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":193180,"title":"Moving the Cell Cursor in Excel 2010 Spreadsheets","slug":"moving-the-cell-cursor-in-excel-2010-spreadsheets","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193180"}},{"articleId":193173,"title":"Excel 2010 Data-Entry Etiquette","slug":"excel-2010-data-entry-etiquette","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193173"}},{"articleId":193172,"title":"Deciphering Error Values in Excel 2010 Formulas","slug":"deciphering-error-values-in-excel-2010-formulas","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193172"}},{"articleId":193179,"title":"Top Ten Features in Excel 2010","slug":"top-ten-features-in-excel-2010","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/193179"}}],"content":[{"title":"Moving the cell cursor in spreadsheets","thumb":null,"image":null,"content":"<p>Excel 2010 offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if this is required to move the cell pointer.</p>\n<p>The following table summarizes these keystrokes, including how far each one moves the cell pointer from its starting position.</p>\n<table>\n<tbody>\n<tr>\n<th>Keystroke</th>\n<th>Where the Cell Cursor Moves</th>\n</tr>\n<tr>\n<td>Right arrow or Tab</td>\n<td>Cell to the immediate right.</td>\n</tr>\n<tr>\n<td>Left arrow or Shift+Tab</td>\n<td>Cell to the immediate left.</td>\n</tr>\n<tr>\n<td>Up arrow</td>\n<td>Cell up one row.</td>\n</tr>\n<tr>\n<td>Down arrow</td>\n<td>Cell down one row.</td>\n</tr>\n<tr>\n<td>Home</td>\n<td>Cell in Column A of the current row.</td>\n</tr>\n<tr>\n<td>Ctrl+Home</td>\n<td>First cell (A1) of the worksheet.</td>\n</tr>\n<tr>\n<td>Ctrl+End or End, Home</td>\n<td>Cell in the worksheet at the intersection of the last column<br />\nthat has data in it and the last row that has data in it (that is,<br />\nthe last cell of the so-called active area of the worksheet).</td>\n</tr>\n<tr>\n<td>Page Up</td>\n<td>Cell one full screen up in the same column.</td>\n</tr>\n<tr>\n<td>Page Down</td>\n<td>Cell one full screen down in the same column.</td>\n</tr>\n<tr>\n<td>Ctrl+Right arrow or End, Right arrow</td>\n<td>First occupied cell to the right in the same row that is either<br />\npreceded or followed by a blank cell. If no cell is occupied, the<br />\npointer goes to the cell at the very end of the row.</td>\n</tr>\n<tr>\n<td>Ctrl+Left arrow or End, Left arrow</td>\n<td>First occupied cell to the left in the same row that is either<br />\npreceded or followed by a blank cell. If no cell is occupied, the<br />\npointer goes to the cell at the very beginning of the row.</td>\n</tr>\n<tr>\n<td>Ctrl+Up arrow or End, Up arrow</td>\n<td>First occupied cell above in the same column that is either<br />\npreceded or followed by a blank cell. If no cell is occupied, the<br />\npointer goes to the cell at the very top of the column.</td>\n</tr>\n<tr>\n<td>Ctrl+Down arrow or End, Down arrow</td>\n<td>First occupied cell below in the same column that is either<br />\npreceded or followed by a blank cell. If no cell is occupied, the<br />\npointer goes to the cell at the very bottom of the column.</td>\n</tr>\n<tr>\n<td>Ctrl+Page Down</td>\n<td>The cell pointer’s location in the next worksheet of that<br />\nworkbook.</td>\n</tr>\n<tr>\n<td>Ctrl+Page Up</td>\n<td>The cell pointer’s location in the previous worksheet of<br />\nthat workbook.</td>\n</tr>\n</tbody>\n</table>\n<p class=\"Tip\">When moving the cell cursor by using the keystrokes listed in the table, keep the following helpful hints in mind:</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\">In the case of those keystrokes that use arrow keys, you must either use the arrows on the cursor keypad or else have the Num Lock disengaged on the numeric keypad of your keyboard.</p>\n</li>\n<li>\n<p class=\"first-para\">The keystrokes that combine the Ctrl or End key with an arrow key are among the most helpful for moving quickly from one edge to the other in large tables of cell entries or for moving from table to table in a section of a worksheet with many blocks of cells.</p>\n</li>\n<li>\n<p class=\"first-para\">When you use Ctrl and an arrow key to move from edge to edge in a table or between tables in a worksheet, you hold down Ctrl while you press one of the four arrow keys.</p>\n</li>\n<li>\n<p class=\"first-para\">When you use End and an arrow-key alternative, you must press and then release the End key <i>before</i> you press the arrow key. Pressing and releasing the End key causes the End Mode indicator to appear on the Status bar. This is your sign that Excel is ready for you to press one of the four arrow keys.</p>\n</li>\n</ul>\n"},{"title":"Data-entry etiquette","thumb":null,"image":null,"content":"<p>To begin to work on a new Excel 2010 spreadsheet, you simply start entering information in the first sheet of the Book1 workbook window. Here are a few simple guidelines (a kind of data-entry etiquette) to keep in mind when you create an Excel spreadsheet in Sheet1 of a new workbook:</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\">Whenever you can, organize your information in tables of data that use adjacent (neighboring) columns and rows. Start the tables in the upper-left corner of the worksheet and work your way down the sheet, rather than across the sheet, whenever possible. When it’s practical, separate each table by no more than a single column or row.</p>\n</li>\n<li>\n<p class=\"first-para\">When you set up these tables, don’t skip columns and rows just to “space out” the information. (To place white space between information in adjacent columns and rows, you can widen columns, heighten rows, and change the alignment.)</p>\n</li>\n<li>\n<p class=\"first-para\">Reserve a single column at the left edge of the table for the table’s row headings.</p>\n</li>\n<li>\n<p class=\"first-para\">Reserve a single row at the top of the table for the table’s column headings.</p>\n</li>\n<li>\n<p class=\"first-para\">If your table requires a title, put the title in the row above the column headings. Put the title in the same column as the row headings.</p>\n</li>\n</ul>\n"},{"title":"Deciphering error values","thumb":null,"image":null,"content":"<p>You can tell right away that an Excel 2010 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness, in the parlance of Excel 2010 spreadsheets, is an <i>error value.</i> Its purpose is to let you know that some element &#8212; either in the formula itself or in a cell referred to by the formula &#8212; is preventing Excel from returning the anticipated calculated value.</p>\n<p>The following table lists some Excel 2010 error values and their most common causes.</p>\n<table>\n<tbody>\n<tr>\n<th>What Shows Up in the Cell</th>\n<th>What’s Going On Here?</th>\n</tr>\n<tr>\n<td>#DIV/0!</td>\n<td>Appears when the formula calls for division by a cell that<br />\neither contains the value 0 or, as is more often the case, is<br />\nempty. Division by zero is a no-no in mathematics.</td>\n</tr>\n<tr>\n<td>#NAME?</td>\n<td>Appears when the formula refers to a <i>range name</i> that<br />\ndoesn’t exist in the worksheet. This error value appears when<br />\nyou type the wrong range name or fail to enclose in quotation marks<br />\nsome text used in the formula, causing Excel to think that the text<br />\nrefers to a range name.</td>\n</tr>\n<tr>\n<td>#NULL!</td>\n<td>Appears most often when you insert a space (where you should<br />\nhave used a comma) to separate cell references used as arguments<br />\nfor functions.</td>\n</tr>\n<tr>\n<td>#NUM!</td>\n<td>Appears when Excel encounters a problem with a number in the<br />\nformula, such as the wrong type of argument in an Excel function or<br />\na calculation that produces a number too large or too small to be<br />\nrepresented in the worksheet.</td>\n</tr>\n<tr>\n<td>#REF!</td>\n<td>Appears when Excel encounters an invalid cell reference, such<br />\nas when you delete a cell referred to in a formula or paste cells<br />\nover the cells referred to in a formula.</td>\n</tr>\n<tr>\n<td>#VALUE!</td>\n<td>Appears when you use the wrong type of argument or operator in<br />\na function, or when you call for a mathematical operation that<br />\nrefers to cells that contain text entries.</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Top 10 features in Excel 2010","thumb":null,"image":null,"content":"<p>If you’re looking for a quick rundown on what’s cool in Excel 2010, look no further! Just a cursory glance down the list tells you that the thrust of the features is graphics, graphics, graphics!</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\"><b>Conditional Formatting &amp; Sparklines: </b>Conditional formatting in Excel 2010 gives you the ability to define formatting when the values in cells meet certain conditions. You can now instantly apply one of many different Data Bars, Color Scales, and Icon Sets to the cell selection merely by clicking the set’s thumbnail in the respective pop-up palettes.</p>\n<p class=\"child-para\">When you apply a set of Data Bars to a cell range, the length of each bar in the cell represents its value relative to the others. When you apply a set of Color Scales, each shade of color in the cell represents its value relative to the others. Additionally, when you apply one of the Icon Sets, each icon in the cell represents its value relative to the others.</p>\n<p class=\"child-para\">Sparklines are the newest graphic addition to Excel. They are tiny charts (so small they fit within the current height of a worksheet cell) that visually represent changes in ranges of associated data. You can use sparklines to call attention to trends in the data as well as to help your users quickly spot high and low values.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Cell Styles:</b> Excel 2010 offers more than 40 colorful ready-made styles. These are styles you can preview in the worksheet with Live Preview before you apply them. You apply a cell style to the cell selection by quickly and easily clicking its thumbnail in the Cells Styles gallery.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Formatting and Editing from the Home tab: </b>The Home tab of the Excel Ribbon literally brings home all the commonly used formatting and editing features. Gone are the days when you have to fish for the right button on some long, drawn-out toolbar or on some partially deployed pull-down menu. Now all you have to do is find the group that holds the command button you need and click it. What could be easier!</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Charts from the Insert tab:</b> Excel 2010 retires the Chart Wizard and offers you direct access to all the major types of charts on the Ribbon’s Insert tab. Simply select the data to chart, click the command button for the chart type on the Insert tab, and then select the style you want for that chart type. And with a little help from the many command buttons and galleries on the Design, Layout, and Format tabs on its Chart Tools contextual tab, you have a really professional-looking chart ready for printing!</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Format As Table:</b> This feature is a real keeper. By formatting a table of data with one of the many table styles available on the Table Styles drop-down gallery, you’re assured that all new entries made to the table are going to be formatted in the same manner as others in similar positions in the table. Better yet, all new entries to the table are considered part of the table automatically when it comes to formatting, sorting, and filtering.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Page Layout View:</b> When you turn on this view by clicking the Page Layout View button on the Status bar, Excel doesn’t just show the page breaks as measly dotted lines as in earlier versions but as actual separations. Additionally, the program shows the margins for each page, including headers and footers defined for the report (which you can both define and edit directly in the margin areas while the program is in this view).</p>\n<p class=\"child-para\">As an extra nice touch, Excel throws in a pair of horizontal and vertical rulers to accompany the standard column and row headers. Couple this great feature with the Zoom slider and the Page Break Preview feature and you’re going to enjoy getting the spreadsheet ready to print.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Style Galleries:</b> Excel 2010 is jammed full of style galleries that make it a snap to apply new sophisticated (and, in many cases, very colorful) formatting to the charts, tables and lists of data, and various and sundry graphics that you add to your worksheets. Coupled with the Live Preview feature, Excel’s style galleries go a long way toward encouraging you to create better looking, more colorful, and interesting spreadsheets.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Document Information and Printing in Backstage View:</b> The brand new Backstage View in Excel enables you to get all the properties and stats (technically known as metadata) about the workbook file you’re editing (including a thumbnail of its contents) on one pane simply by choosing FileInfo (Alt+F). This new Backstage View also makes it a breeze to preview, change settings, and print your worksheet using its new Print panel by choosing FilePrint (Ctrl+P or Alt+FP).</p>\n</li>\n<li>\n<p class=\"first-para\"><b>The Ribbon:</b> The Ribbon is the heart of the new Excel 2010 user interface. Based on a core of standard tabs to which various so-called contextual tabs are added as needed in formatting and editing of specific elements (such as data tables, charts, pivot tables, and graphic objects), the Ribbon brings together most every command you’re going to need when performing particular tasks in Excel.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Live Preview:</b> Live Preview works with all the style galleries as well as Font and Font Size drop-down menus in the Font group on the Home tab. It enables you to see how the data in the current cell selection would look with a particular formatting, font, or font size before you actually apply the formatting to the range. All you have to do is mouse over the thumbnails in the drop-down menu or gallery to see how each of its styles will look on your actual data.</p>\n<p class=\"child-para\">Many of the larger style galleries sport spinner buttons that enable you to bring new rows of thumbnails in the gallery into view so that you can preview their styles without obscuring any part of the cell selection (as would be the case if you actually open the gallery by clicking its More drop-down button). When you finally do see the formatting that fits your data to a tee, all you have to do is click its thumbnail to apply it to the selected cell range.</p>\n</li>\n</ul>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Two years","lifeExpectancySetFrom":"2022-04-18T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":209119},{"headers":{"creationTime":"2021-06-08T14:28:08+00:00","modifiedTime":"2022-04-18T17:22:31+00:00","timestamp":"2022-04-18T18:01:09+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Apple Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34381"},"slug":"apple-products","categoryId":34381}],"title":"Apple One For Dummies Cheat Sheet","strippedTitle":"apple one for dummies cheat sheet","slug":"apple-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Learn about two ways to access Apple One services and get the most out of Apple TV's Siri remote and discover the best iCloud.com browsers.","noIndex":0,"noFollow":0},"content":"The Apple TV streaming device and iCloud.com are two of the ways you can access many of your Apple One services. Get the most out of your Apple TV’s Siri remote control and discover the best web browsers to use with iCloud.com, ensuring a better consumer experience.","description":"The Apple TV streaming device and iCloud.com are two of the ways you can access many of your Apple One services. Get the most out of your Apple TV’s Siri remote control and discover the best web browsers to use with iCloud.com, ensuring a better consumer experience.","blurb":"","authors":[{"authorId":9260,"name":"Dwight Spivey","slug":"dwight-spivey","description":"Dwight Spivey has been a technical author and editor for over a decade, drawing on his talent for explaining technology to ordinary humans. He works as an educational technology administrator at Spring Hill College in Alabama. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9260"}}],"primaryCategoryTaxonomy":{"categoryId":34381,"title":"Apple Products","slug":"apple-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34381"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[],"fromCategory":[{"articleId":206536,"title":"How to Add Music or Sound Effects to Your iMovie","slug":"how-to-add-music-or-sound-effects-to-your-imovie","categoryList":["technology","software","apple-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206536"}},{"articleId":206535,"title":"How to Record a Voiceover in iMovie","slug":"how-to-record-a-voiceover-in-imovie","categoryList":["technology","software","apple-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206535"}},{"articleId":206525,"title":"How to Add Photos to Your Movies in iMovie","slug":"how-to-add-photos-to-your-movies-in-imovie","categoryList":["technology","software","apple-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206525"}},{"articleId":206524,"title":"How to Add Titles to Your Movies in iMovie","slug":"how-to-add-titles-to-your-movies-in-imovie","categoryList":["technology","software","apple-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206524"}},{"articleId":206512,"title":"How to Find a Song on iTunes","slug":"how-to-find-a-song-on-itunes","categoryList":["technology","software","apple-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/206512"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":284352,"slug":"appleone-for-dummies","isbn":"9781119800941","categoryList":["technology","software","apple-products"],"amazon":{"default":"https://www.amazon.com/gp/product/1119800943/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119800943/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119800943-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119800943/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119800943/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/appleone-for-dummies-cover-9781119800941-170x255.jpg","width":170,"height":255},"title":"Apple One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p><b data-author-id=\"9260\">Dwight Spivey</b> has been a technical author and editor for over a decade, drawing on his talent for explaining technology to ordinary humans. He works as an educational technology administrator at Spring Hill College in Alabama.</p>","authors":[{"authorId":9260,"name":"Dwight Spivey","slug":"dwight-spivey","description":"Dwight Spivey has been a technical author and editor for over a decade, drawing on his talent for explaining technology to ordinary humans. He works as an educational technology administrator at Spring Hill College in Alabama. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9260"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;apple-products&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119800941&quot;]}]\" id=\"du-slot-625da7659d841\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;apple-products&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119800941&quot;]}]\" id=\"du-slot-625da7659dd7f\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Using Siri with Your Apple TV Remote","thumb":null,"image":null,"content":"<p>Siri has become a cultural icon. Apple’s virtual assistant is incredibly useful on our iPhones, iPads, Apple Watches, and Macs, but it’s also a wonderful companion for your Apple TV. As a matter of fact, Siri is such an integral part of the Apple TV experience that its remote control is called Siri Remote. You can speak a command to Siri and it will perform the action you request, without having to poke around in all your apps to find a show, movie, or game.</p>\n<p>Siri is available for Apple TV 4K and Apple TV HD models and supports several languages.</p>\n<p>To use Siri with your Apple TV, hold down the Siri button (microphone icon) on the Siri Remote, speak a command, release the Siri button, and then sit back and relax while Siri does the work. Here are a just a few examples of tasks you can ask of Siri on Apple TV:</p>\n<ul>\n<li>Search for shows or movies by title: “Ted Lasso” or “I’d like to watch The Lord of the Rings.”</li>\n<li>Look for shows or movie by genre: “Find sci-fi movies” or “Shows for young children.”</li>\n<li>Find shows or movies by cast or director name: “Steven Spielberg movies” or “Find something with Denzel Washington.”</li>\n<li>Control playback of shows and movies you’re watching: “Pause” or “Skip ahead 10 minutes.”</li>\n<li>Search for shows and movies by the host app: “Find The Crown on Netflix” or “DudePerfect on YouTube.”</li>\n<li>Find your Apple devices: “Where’s my iPad?” or “Play a sound on my Apple Watch.”</li>\n<li>Check your favorite sports scores: “How badly is Auburn beating Alabama?” or “What are the latest March Madness scores?”</li>\n<li>Look for live television: “Show my CBS live” or “Watch live basketball on Hulu.”</li>\n<li>Discover apps: “Find the Paramount+ app” or “Which weather apps are available?”</li>\n</ul>\n<p>And much more! Check out this <a href=\"https://support.apple.com/en-us/HT205300\">page on Apple’s Support site</a> for more information, including troubleshooting information in case Siri isn’t behaving as expected.</p>\n"},{"title":"The Best Browsers for iCloud.com","thumb":null,"image":null,"content":"<p>Most of the services available with your Apple One subscription can be accessed via iCloud.com in your favorite web browser, regardless of the operating system or device you use. However, all web browsers aren’t created equal. Some are built for speed, others focus on security, and many others try to cater to specific uses or platforms. In general, the default web browser that came with your computer or device may suffice for you, but it’s always a good idea to try new things, even when it comes to the tools you use to browse the web. You may surprise yourself and find that one browser just suits you more than another, or security features in some browsers may supersede your need for speed.</p>\n<p>Here’s a list (in alphabetical order) of what I consider to be some of the best browsers around, including the platforms they’re available for:</p>\n<ul>\n<li><a href=\"https://brave.com/\">Brave</a>: If you don’t like ads on your websites—and I mean you <em>really</em> don’t like ads—Brave is the browser for you. By default, Brave blocks intrusive ads and pop-ups from ruining your browsing experience and even speeds it up. There can be tradeoffs, though, as some sites just don’t work right without ads (by design). Brave is available for Mac, Windows, iOS, iPadOS, Android, and Linux.</li>\n<li><a href=\"https://www.google.com/chrome\">Google Chrome</a>: Chrome is the most popular browser on the market today. Powerful and speedy, Chrome works with all major operating systems: Mac, Windows, iOS, iPadOS, Android, and Linux.</li>\n<li><a href=\"https://www.microsoft.com/en-us/edge\">Microsoft Edge</a>: Edge is Microsoft’s replacement for Internet Explorer. You may be surprised to find out that it works for not only Windows but also Mac, iOS, iPadOS, Android, and Linux. If you’re looking for a very Chrome-like experience without being tied so much to Google, Edge might be for you.</li>\n<li><a href=\"https://www.mozilla.org/en-US/firefox\">Mozilla Firefox</a>: Firefox is a powerful and user-friendly browser, but it’s biggest claim to fame may be that it’s the “anti-Chrome” (some folks just do not like letting Google into every facet of their browsing lives). Get Firefox for Mac, Windows, iOS, iPadOS, Android, and Linux.</li>\n<li><a href=\"https://www.opera.com/\">Opera</a>: Opera has been around a long time and has a small but fiercely loyal base. It’s always been known for its strong feature set and customization options. You can get Opera for Mac, Windows, Android, and Linux. Opera also makes a version of its browser for iOS and iPadOS called <a href=\"https://apps.apple.com/app/id1411869974\">Opera Touch</a> that’s light and fast, and includes a built-in ad-blocker to boot.</li>\n<li><a href=\"https://www.apple.com/safari/\">Safari</a>: Safari is the second-most popular browser in the world as of this writing and is beautifully made for speed and power. Its major drawback for some is that it’s available only for Apple users. If you don’t have an Apple product, you can’t use Safari.</li>\n<li><a href=\"https://vivaldi.com/\">Vivaldi</a>: Vivaldi is an up-and-comer known for its awesome customization features. You can truly configure Vivaldi to work exactly as you want it to, down to the <em>n</em>th degree. Vivaldi is available for Mac, Windows, Android, and Linux but doesn’t currently support iOS or iPadOS.</li>\n</ul>\n<p><em>Note to Internet Explorer users</em>: You may have noticed that I didn’t mention Internet Explorer in my list. That’s because, frankly, compared to those I did list, it’s a subpar browser. It’s also been replaced by Microsoft Edge in the newest versions of Windows.</p>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Explore","lifeExpectancy":"One year","lifeExpectancySetFrom":"2021-06-08T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":285266},{"headers":{"creationTime":"2020-08-15T16:39:52+00:00","modifiedTime":"2022-04-14T20:13:51+00:00","timestamp":"2022-04-15T00:01:10+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Google Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34390"},"slug":"google-products","categoryId":34390}],"title":"G Suite For Dummies Cheat Sheet","strippedTitle":"g suite for dummies cheat sheet","slug":"g-suite-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Explore useful keyboard shortcuts common to the G Suite apps and some handy shortcuts you can use with Gmail and Calendar.","noIndex":0,"noFollow":0},"content":"G Suite offers a huge number of keyboard shortcuts that not only enable you to navigate the app interfaces quickly but also let you easily invoke many app features and settings. Here, you see some of the more useful shortcuts that are common to the G Suite apps, as well as some handy shortcuts you can use with Gmail and Calendar. Do you need to memorize them all? Don't be silly. But read through the lists — you'll probably find two or three that you'll use every day.\r\n\r\n<img class=\"alignnone size-full wp-image-272494\" src=\"https://www.dummies.com/wp-content/uploads/g-suite-calendar.jpg\" alt=\"Google Calendar\" width=\"556\" height=\"416\" />","description":"G Suite offers a huge number of keyboard shortcuts that not only enable you to navigate the app interfaces quickly but also let you easily invoke many app features and settings. Here, you see some of the more useful shortcuts that are common to the G Suite apps, as well as some handy shortcuts you can use with Gmail and Calendar. Do you need to memorize them all? Don't be silly. But read through the lists — you'll probably find two or three that you'll use every day.\r\n\r\n<img class=\"alignnone size-full wp-image-272494\" src=\"https://www.dummies.com/wp-content/uploads/g-suite-calendar.jpg\" alt=\"Google Calendar\" width=\"556\" height=\"416\" />","blurb":"","authors":[{"authorId":11290,"name":"Paul McFedries","slug":"paul-mcfedries","description":"Paul McFedries is a true renaissance geek. He has been a programmer, consultant, database developer, and website builder. He's also the author of more than 90 books, including top sellers covering Windows, Office, and macOS. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/11290"}}],"primaryCategoryTaxonomy":{"categoryId":34390,"title":"Google Products","slug":"google-products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/34390"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":272775,"title":"10 Ways to Enhance Privacy and Security with G Suite","slug":"10-ways-to-enhance-privacy-and-security-with-g-suite","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272775"}},{"articleId":272772,"title":"10 Useful Gmail Settings","slug":"10-useful-gmail-settings","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272772"}},{"articleId":272769,"title":"10 Tips for Working from Home with G Suite Apps","slug":"10-tips-for-working-from-home-with-g-suite-apps","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272769"}},{"articleId":272766,"title":"What Is G Suite?","slug":"what-is-g-suite","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272766"}},{"articleId":272763,"title":"Gather Info with G Suite's Forms App","slug":"gather-info-with-g-suites-forms-app","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272763"}}],"fromCategory":[{"articleId":272775,"title":"10 Ways to Enhance Privacy and Security with G Suite","slug":"10-ways-to-enhance-privacy-and-security-with-g-suite","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272775"}},{"articleId":272772,"title":"10 Useful Gmail Settings","slug":"10-useful-gmail-settings","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272772"}},{"articleId":272769,"title":"10 Tips for Working from Home with G Suite Apps","slug":"10-tips-for-working-from-home-with-g-suite-apps","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272769"}},{"articleId":272766,"title":"What Is G Suite?","slug":"what-is-g-suite","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272766"}},{"articleId":272763,"title":"Gather Info with G Suite's Forms App","slug":"gather-info-with-g-suites-forms-app","categoryList":["technology","software","google-products"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/272763"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281725,"slug":"g-suite-for-dummies","isbn":"9781119742173","categoryList":["technology","software","google-products"],"amazon":{"default":"https://www.amazon.com/gp/product/111974217X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/111974217X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/111974217X-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/111974217X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/111974217X/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/g-suite-for-dummies-cover-9781119742173-203x255.jpg","width":203,"height":255},"title":"G Suite For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"\n <p><b data-author-id=\"11290\">Paul McFedries</b> is a true renaissance geek. He has been a programmer, consultant, database developer, and website builder. He's also the author of more than 90 books, including top sellers covering Windows, Office, and macOS.</p>","authors":[{"authorId":11290,"name":"Paul McFedries","slug":"paul-mcfedries","description":"Paul McFedries is a true renaissance geek. He has been a programmer, consultant, database developer, and website builder. He's also the author of more than 90 books, including top sellers covering Windows, Office, and macOS. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/11290"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;google-products&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119742173&quot;]}]\" id=\"du-slot-6258b5c6721c8\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;google-products&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119742173&quot;]}]\" id=\"du-slot-6258b5c672734\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"Common G Suite keyboard shortcuts","thumb":null,"image":null,"content":"<p>The following table lists a few keyboard shortcuts that you can use in most G Suite apps (if you&#8217;re using a Mac, replace the Ctrl keystroke with Command):</p>\n<table width=\"389\">\n<tbody>\n<tr>\n<td width=\"217\"><strong>To Do This</strong></td>\n<td width=\"172\"><strong>Press This</strong></td>\n</tr>\n<tr>\n<td width=\"217\">Apply bold</td>\n<td width=\"172\">Ctrl+b</td>\n</tr>\n<tr>\n<td width=\"217\">Apply italic</td>\n<td width=\"172\">Ctrl+i</td>\n</tr>\n<tr>\n<td width=\"217\">Apply underline</td>\n<td width=\"172\">Ctrl+u</td>\n</tr>\n<tr>\n<td width=\"217\">Insert a link</td>\n<td width=\"172\">Ctrl+k</td>\n</tr>\n<tr>\n<td width=\"217\">Open spelling suggestions</td>\n<td width=\"172\">Ctrl+m</td>\n</tr>\n<tr>\n<td width=\"217\">Decrease text size</td>\n<td width=\"172\">Ctrl+Shift+– (minus)</td>\n</tr>\n<tr>\n<td width=\"217\">Increase text size</td>\n<td width=\"172\">Ctrl+Shift++ (plus)</td>\n</tr>\n<tr>\n<td width=\"217\">Indent less</td>\n<td width=\"172\">Ctrl+[</td>\n</tr>\n<tr>\n<td width=\"217\">Indent more</td>\n<td width=\"172\">Ctrl+]</td>\n</tr>\n<tr>\n<td width=\"217\">Align left</td>\n<td width=\"172\">Ctrl+Shift+l</td>\n</tr>\n<tr>\n<td width=\"217\">Align center</td>\n<td width=\"172\">Ctrl+Shift+e</td>\n</tr>\n<tr>\n<td width=\"217\">Align right</td>\n<td width=\"172\">Ctrl+Shift+r</td>\n</tr>\n<tr>\n<td width=\"217\">Start a numbered list</td>\n<td width=\"172\">Ctrl+Shift+7</td>\n</tr>\n<tr>\n<td width=\"217\">Start a bulleted list</td>\n<td width=\"172\">Ctrl+Shift+8</td>\n</tr>\n<tr>\n<td width=\"217\">Open keyboard shortcut help</td>\n<td width=\"172\">?</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n"},{"title":"50 Gmail keyboard shortcuts","thumb":null,"image":null,"content":"<p>You might not think about using the keyboard with Gmail for anything beyond typing your message text, but Gmail actually has a fistful of handy keyboard shortcuts that can be real timesavers. Before getting to the actual shortcuts, you should first follow these steps to make sure all Gmail keyboard shortcuts are activated:</p>\n<ol>\n<li>In Gmail, select Settings to open the menu and then choose Settings.</li>\n<li>On the General tab, scroll down to the Keyboard Shortcuts section and then click the Keyboard Shortcuts On radio button.</li>\n<li>At the bottom of the tab, click Save Changes.</li>\n</ol>\n<p>With that chore crossed off your to-do list, you can now use the shortcuts in the following table (if you&#8217;re using a Mac, replace the Ctrl keystroke with Command):</p>\n<table width=\"392\">\n<tbody>\n<tr>\n<td width=\"286\"><strong>To Do This</strong></td>\n<td width=\"106\"><strong>Press This</strong></td>\n</tr>\n<tr>\n<td width=\"286\">Go to inbox</td>\n<td width=\"106\">g, i</td>\n</tr>\n<tr>\n<td width=\"286\">Go to starred conversations</td>\n<td width=\"106\">g, s</td>\n</tr>\n<tr>\n<td width=\"286\">Go to snoozed conversations</td>\n<td width=\"106\">g, b</td>\n</tr>\n<tr>\n<td width=\"286\">Go to sent messages</td>\n<td width=\"106\">g, t</td>\n</tr>\n<tr>\n<td width=\"286\">Go to drafts</td>\n<td width=\"106\">g, d</td>\n</tr>\n<tr>\n<td width=\"286\">Go to All Mail</td>\n<td width=\"106\">g, a</td>\n</tr>\n<tr>\n<td width=\"286\">Go to tasks</td>\n<td width=\"106\">g, k</td>\n</tr>\n<tr>\n<td width=\"286\">Search mail</td>\n<td width=\"106\">/</td>\n</tr>\n<tr>\n<td width=\"286\">Open the More Actions menu</td>\n<td width=\"106\">. (period)</td>\n</tr>\n<tr>\n<td width=\"286\">Open the Label As menu</td>\n<td width=\"106\">l</td>\n</tr>\n<tr>\n<td width=\"286\">Compose</td>\n<td width=\"106\">c</td>\n</tr>\n<tr>\n<td width=\"286\">Compose on a new tab</td>\n<td width=\"106\">d</td>\n</tr>\n<tr>\n<td width=\"286\">Send message</td>\n<td width=\"106\">Ctrl+Enter</td>\n</tr>\n<tr>\n<td width=\"286\">Add cc recipients</td>\n<td width=\"106\">Ctrl+Shift+c</td>\n</tr>\n<tr>\n<td width=\"286\">Add bcc recipients</td>\n<td width=\"106\">Ctrl+Shift+b</td>\n</tr>\n<tr>\n<td width=\"286\">Go to previous message in open conversation</td>\n<td width=\"106\">p</td>\n</tr>\n<tr>\n<td width=\"286\">Go to next message in open conversation</td>\n<td width=\"106\">n</td>\n</tr>\n<tr>\n<td width=\"286\">Focus on main window</td>\n<td width=\"106\">Shift+Esc</td>\n</tr>\n<tr>\n<td width=\"286\">Focus on latest chat or compose window</td>\n<td width=\"106\">Esc</td>\n</tr>\n<tr>\n<td width=\"286\">Select conversation</td>\n<td width=\"106\">X</td>\n</tr>\n<tr>\n<td width=\"286\">Toggle star or rotate among superstars</td>\n<td width=\"106\">S</td>\n</tr>\n<tr>\n<td width=\"286\">Go to next page</td>\n<td width=\"106\">g+n</td>\n</tr>\n<tr>\n<td width=\"286\">Go to previous page</td>\n<td width=\"106\">g+p</td>\n</tr>\n<tr>\n<td width=\"286\">Newer conversation</td>\n<td width=\"106\">k</td>\n</tr>\n<tr>\n<td width=\"286\">Older conversation</td>\n<td width=\"106\">j</td>\n</tr>\n<tr>\n<td width=\"286\">Open conversation</td>\n<td width=\"106\">o or Enter</td>\n</tr>\n<tr>\n<td width=\"286\">Expand entire conversation</td>\n<td width=\"106\">; (semicolon)</td>\n</tr>\n<tr>\n<td width=\"286\">Collapse entire conversation</td>\n<td width=\"106\">: (colon)</td>\n</tr>\n<tr>\n<td width=\"286\">Add conversation to tasks</td>\n<td width=\"106\">Shift+t</td>\n</tr>\n<tr>\n<td width=\"286\">Archive conversation</td>\n<td width=\"106\">e</td>\n</tr>\n<tr>\n<td width=\"286\">Archive conversation and go to previous or next message</td>\n<td width=\"106\">] or [</td>\n</tr>\n<tr>\n<td width=\"286\">Mute conversation</td>\n<td width=\"106\">m</td>\n</tr>\n<tr>\n<td width=\"286\">Snooze conversation</td>\n<td width=\"106\">b</td>\n</tr>\n<tr>\n<td width=\"286\">Report as spam</td>\n<td width=\"106\">!</td>\n</tr>\n<tr>\n<td width=\"286\">Delete</td>\n<td width=\"106\">#</td>\n</tr>\n<tr>\n<td width=\"286\">Reply</td>\n<td width=\"106\">r</td>\n</tr>\n<tr>\n<td width=\"286\">Reply in new window</td>\n<td width=\"106\">Shift+r</td>\n</tr>\n<tr>\n<td width=\"286\">Reply all</td>\n<td width=\"106\">a</td>\n</tr>\n<tr>\n<td width=\"286\">Reply all in new window</td>\n<td width=\"106\">Shift+a</td>\n</tr>\n<tr>\n<td width=\"286\">Forward</td>\n<td width=\"106\">f</td>\n</tr>\n<tr>\n<td width=\"286\">Forward in new window</td>\n<td width=\"106\">Shift+f</td>\n</tr>\n<tr>\n<td width=\"286\">Undo last action</td>\n<td width=\"106\">z</td>\n</tr>\n<tr>\n<td width=\"286\">Mark as read</td>\n<td width=\"106\">Shift+i</td>\n</tr>\n<tr>\n<td width=\"286\">Mark as unread</td>\n<td width=\"106\">Shift+u</td>\n</tr>\n<tr>\n<td width=\"286\">Mark as important</td>\n<td width=\"106\">+ or =</td>\n</tr>\n<tr>\n<td width=\"286\">Mark as not important</td>\n<td width=\"106\">– (minus)</td>\n</tr>\n<tr>\n<td width=\"286\">Move focus to toolbar</td>\n<td width=\"106\">, (comma)</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n"},{"title":"Some useful calendar shortcuts","thumb":null,"image":null,"content":"<p>Calendar doesn&#8217;t offer a ton of keyboard shortcuts, but the shortcuts it supports are pretty darned useful, if you ask me. Keyboard shortcuts are usually enabled by default in <a href=\"https://dummies-wp-content.dummies.com/education/internet-basics/how-to-sync-multiple-calendars-using-google-calendar/\" target=\"_blank\" rel=\"noopener\">Calendar</a>, but you should scurry through the following steps, just to make sure:</p>\n<ol>\n<li>In Calendar, select Settings Menu and then choose Settings.</li>\n<li>Select Keyboard Shortcuts.</li>\n<li>Select the Enable Keyboard Shortcuts check box.</li>\n</ol>\n<p>You&#8217;re now free to play around with the keyboard shortcuts in the following table (if you&#8217;re using a Mac, replace the Ctrl keystroke with Command):</p>\n<table>\n<tbody>\n<tr>\n<td width=\"301\"><strong>To Do This</strong></td>\n<td width=\"157\"><strong>Press This</strong></td>\n</tr>\n<tr>\n<td width=\"301\">Display current day</td>\n<td width=\"157\">T</td>\n</tr>\n<tr>\n<td width=\"301\">Go to specific date</td>\n<td width=\"157\">G</td>\n</tr>\n<tr>\n<td width=\"301\">Switch to Day view</td>\n<td width=\"157\">1 or d</td>\n</tr>\n<tr>\n<td width=\"301\">Switch to Week view</td>\n<td width=\"157\">2 or w</td>\n</tr>\n<tr>\n<td width=\"301\">Switch to Month view</td>\n<td width=\"157\">3 or m</td>\n</tr>\n<tr>\n<td width=\"301\">Switch to Custom view</td>\n<td width=\"157\">4 or x</td>\n</tr>\n<tr>\n<td width=\"301\">Switch to Agenda view</td>\n<td width=\"157\">5 or a</td>\n</tr>\n<tr>\n<td width=\"301\">Change calendar view to the next date range</td>\n<td width=\"157\">j or n</td>\n</tr>\n<tr>\n<td width=\"301\">Create new event</td>\n<td width=\"157\">c</td>\n</tr>\n<tr>\n<td width=\"301\">See event&#8217;s details</td>\n<td width=\"157\">e</td>\n</tr>\n<tr>\n<td width=\"301\">Delete event</td>\n<td width=\"157\">Backspace or Delete</td>\n</tr>\n<tr>\n<td width=\"301\">Refresh calendar</td>\n<td width=\"157\">r</td>\n</tr>\n<tr>\n<td width=\"301\">Move to Meet With text box</td>\n<td width=\"157\">+</td>\n</tr>\n<tr>\n<td width=\"301\">Search</td>\n<td width=\"157\">/</td>\n</tr>\n<tr>\n<td width=\"301\">Open Settings</td>\n<td width=\"157\">s</td>\n</tr>\n<tr>\n<td width=\"301\">Undo</td>\n<td width=\"157\">z</td>\n</tr>\n<tr>\n<td width=\"301\">Save event (from event details)</td>\n<td width=\"157\">Ctrl+s</td>\n</tr>\n<tr>\n<td width=\"301\">Return to calendar grid (from event details)</td>\n<td width=\"157\">Esc</td>\n</tr>\n</tbody>\n</table>\n<p>&nbsp;</p>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-04-14T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":272493},{"headers":{"creationTime":"2018-09-18T15:20:50+00:00","modifiedTime":"2022-04-05T21:18:25+00:00","timestamp":"2022-04-06T00:01:10+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"PowerPoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"},"slug":"powerpoint","categoryId":33647}],"title":"PowerPoint 2019 For Dummies Cheat Sheet","strippedTitle":"powerpoint 2019 for dummies cheat sheet","slug":"powerpoint-2019-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Keep this Cheat Sheet handy when you're working in PowerPoint 2019 for keyboard shortcuts for formatting, editing, slide shows, and more.","noIndex":0,"noFollow":0},"content":"PowerPoint 2019 is the most powerful presentation software available to create and edit slide show presentations for work, home, or school. PowerPoint 2019 offers a number of helpful keyboard shortcuts for performing tasks quickly. Here are some shortcuts for common PowerPoint formatting, editing, and file and document tasks.\r\n\r\nAdditionally, after you’ve created your masterpiece, you can use a number of shortcuts when running your slide show.","description":"PowerPoint 2019 is the most powerful presentation software available to create and edit slide show presentations for work, home, or school. PowerPoint 2019 offers a number of helpful keyboard shortcuts for performing tasks quickly. Here are some shortcuts for common PowerPoint formatting, editing, and file and document tasks.\r\n\r\nAdditionally, after you’ve created your masterpiece, you can use a number of shortcuts when running your slide show.","blurb":"","authors":[{"authorId":8946,"name":"Doug Lowe","slug":"doug-lowe","description":"Doug Lowe still has the electronics experimenter's kit his dad gave him when he was 10. He became an IT director, programmer, and author of books on various programming languages, Microsoft Office, web programming, and PCs. But Lowe never forgot his first love: electronics.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/8946"}}],"primaryCategoryTaxonomy":{"categoryId":33647,"title":"PowerPoint","slug":"powerpoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":257590,"title":"How to Remove Picture Backgrounds in PowerPoint 2019","slug":"how-to-remove-picture-backgrounds-in-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257590"}},{"articleId":257584,"title":"Audio Options in Microsoft PowerPoint 2019","slug":"audio-options-in-microsoft-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257584"}},{"articleId":257577,"title":"How to Share Presentations via the PowerPoint Web App","slug":"how-to-share-presentations-via-the-powerpoint-web-app","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257577"}},{"articleId":257571,"title":"How to Share a PowerPoint 2019 Presentation in the Cloud","slug":"how-to-share-a-powerpoint-2019-presentation-in-the-cloud","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257571"}},{"articleId":257565,"title":"PowerPoint 2019 Slide Libraries and Ways to Reuse Slides","slug":"powerpoint-2019-slide-libraries-and-ways-to-reuse-slides","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257565"}}],"fromCategory":[{"articleId":288823,"title":"PowerPoint 2021 For Dummies Cheat Sheet","slug":"powerpoint-2021-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288823"}},{"articleId":257590,"title":"How to Remove Picture Backgrounds in PowerPoint 2019","slug":"how-to-remove-picture-backgrounds-in-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257590"}},{"articleId":257584,"title":"Audio Options in Microsoft PowerPoint 2019","slug":"audio-options-in-microsoft-powerpoint-2019","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257584"}},{"articleId":257577,"title":"How to Share Presentations via the PowerPoint Web App","slug":"how-to-share-presentations-via-the-powerpoint-web-app","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257577"}},{"articleId":257571,"title":"How to Share a PowerPoint 2019 Presentation in the Cloud","slug":"how-to-share-a-powerpoint-2019-presentation-in-the-cloud","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257571"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281826,"slug":"powerpoint-2019-for-dummies","isbn":"9781119514220","categoryList":["technology","software","microsoft-products","powerpoint"],"amazon":{"default":"https://www.amazon.com/gp/product/1119514223/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119514223/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119514223-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119514223/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119514223/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/powerpoint-2019-for-dummies-cover-9781119514220-203x255.jpg","width":203,"height":255},"title":"PowerPoint 2019 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"8946\">Doug Lowe</b> is a master at demystifying technology. The 50+ technology books he's written include more than 30 <i>For Dummies</i> books, including <i>Networking All-in-One For Dummies.</i> Doug has been managing networks at publishing companies and nonprofit organizations for more than 20 years and is presently IT director for a civil engineering firm.\t </p>","authors":[{"authorId":8946,"name":"Doug Lowe","slug":"doug-lowe","description":"Doug Lowe still has the electronics experimenter's kit his dad gave him when he was 10. He became an IT director, programmer, and author of books on various programming languages, Microsoft Office, web programming, and PCs. But Lowe never forgot his first love: electronics.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/8946"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;powerpoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119514220&quot;]}]\" id=\"du-slot-624cd846da9cc\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;powerpoint&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119514220&quot;]}]\" id=\"du-slot-624cd846db0ca\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":255522,"title":"PowerPoint 2019 Formatting Shortcuts","slug":"powerpoint-2019-formatting-shortcuts","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255522"}},{"articleId":255525,"title":"PowerPoint 2019 Editing Shortcuts","slug":"powerpoint-2019-editing-shortcuts","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255525"}},{"articleId":255528,"title":"PowerPoint 2019 File and Document Shortcuts","slug":"powerpoint-2019-file-and-document-shortcuts","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255528"}},{"articleId":255531,"title":"PowerPoint 2019 Slide Show Shortcuts","slug":"powerpoint-2019-slide-show-shortcuts","categoryList":["technology","software","microsoft-products","powerpoint"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255531"}}],"content":[{"title":"PowerPoint 2019 formatting shortcuts","thumb":null,"image":null,"content":"<p>If you’re ready to format text in PowerPoint 2019, this table gets you on the road toward ooohs and aaahs of doing so. If you use PowerPoint 2019 templates as the basis for your presentations, your text is already formatted acceptably. To really pull out the pyrotechnic stops, however, you have to know a few basic formatting tricks.</p>\n<table>\n<tbody>\n<tr>\n<td width=\"167\"><strong>Command</strong></td>\n<td width=\"184\"><strong>Shortcut</strong></td>\n<td width=\"224\"><strong>Ribbon Location</strong></td>\n</tr>\n<tr>\n<td width=\"167\">Bold</td>\n<td width=\"184\">Ctrl+B</td>\n<td width=\"224\">Home tab, Font group</td>\n</tr>\n<tr>\n<td width=\"167\">Italic</td>\n<td width=\"184\">Ctrl+I</td>\n<td width=\"224\">Home tab, Font group</td>\n</tr>\n<tr>\n<td width=\"167\">Underline</td>\n<td width=\"184\">Ctrl+U</td>\n<td width=\"224\">Home tab, Font group</td>\n</tr>\n<tr>\n<td width=\"167\">Center</td>\n<td width=\"184\">Ctrl+E</td>\n<td width=\"224\">Home tab, Paragraph group</td>\n</tr>\n<tr>\n<td width=\"167\">Left Align</td>\n<td width=\"184\">Ctrl+L</td>\n<td width=\"224\">Home tab, Paragraph group</td>\n</tr>\n<tr>\n<td width=\"167\">Right Align</td>\n<td width=\"184\">Ctrl+R</td>\n<td width=\"224\">Home tab, Paragraph group</td>\n</tr>\n<tr>\n<td width=\"167\">Justify</td>\n<td width=\"184\">Ctrl+J</td>\n<td width=\"224\">Home tab, Paragraph group</td>\n</tr>\n<tr>\n<td width=\"167\">Normal</td>\n<td width=\"184\">Ctrl+spacebar</td>\n<td width=\"224\">Home tab, Paragraph group</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Editing shortcuts","thumb":null,"image":null,"content":"<p>Like any good Windows program, PowerPoint 2019 uses the standard Undo, Cut, Copy, Paste, Select All, Find, and Replace commands. These commands work on text that you’ve selected, or if you’ve selected an entire object, the commands work on the object itself. In other words, you can use these commands with bits of text or with entire objects.</p>\n<table>\n<tbody>\n<tr>\n<td width=\"178\"><strong>Command</strong></td>\n<td width=\"162\"><strong>Shortcut</strong></td>\n<td width=\"236\"><strong>Ribbon Location</strong></td>\n</tr>\n<tr>\n<td width=\"178\">Undo</td>\n<td width=\"162\">Ctrl+Z</td>\n<td width=\"236\">Quick Access toolbar</td>\n</tr>\n<tr>\n<td width=\"178\">Cut</td>\n<td width=\"162\">Ctrl+X</td>\n<td width=\"236\">Home tab, Clipboard group</td>\n</tr>\n<tr>\n<td width=\"178\">Copy</td>\n<td width=\"162\">Ctrl+C</td>\n<td width=\"236\">Home tab, Clipboard group</td>\n</tr>\n<tr>\n<td width=\"178\">Paste</td>\n<td width=\"162\">Ctrl+V</td>\n<td width=\"236\">Home tab, Clipboard group</td>\n</tr>\n<tr>\n<td width=\"178\">Select All</td>\n<td width=\"162\">Ctrl+A</td>\n<td width=\"236\">Home tab, Editing group</td>\n</tr>\n<tr>\n<td width=\"178\">Find</td>\n<td width=\"162\">Ctrl+F</td>\n<td width=\"236\">Home tab, Editing group</td>\n</tr>\n<tr>\n<td width=\"178\">Replace</td>\n<td width=\"162\">Ctrl+H</td>\n<td width=\"236\">Home tab, Editing group</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"File and document shortcuts","thumb":null,"image":null,"content":"<p>There are a lot of things you can do with PowerPoint 2019, and having shortcuts for the things you do most often is very handy. Some of the things you’ll frequently do in PowerPoint include creating, saving, and printing new presentations, as well as opening existing presentations, adding new slides, and getting help from PowerPoint. The following table tells you the shortcuts for these common actions.</p>\n<table>\n<tbody>\n<tr>\n<td width=\"163\"><strong>Command</strong></td>\n<td width=\"148\"><strong>Shortcut</strong></td>\n<td width=\"264\"><strong>Ribbon Location</strong></td>\n</tr>\n<tr>\n<td width=\"163\">New</td>\n<td width=\"148\">Ctrl+N</td>\n<td width=\"264\">File tab, New command</td>\n</tr>\n<tr>\n<td width=\"163\">Open</td>\n<td width=\"148\">Ctrl+O</td>\n<td width=\"264\">File tab, Open command</td>\n</tr>\n<tr>\n<td width=\"163\">Save</td>\n<td width=\"148\">Ctrl+S</td>\n<td width=\"264\">File tab, Save command</td>\n</tr>\n<tr>\n<td width=\"163\">Print</td>\n<td width=\"148\">Ctrl+P</td>\n<td width=\"264\">File tab, Print command</td>\n</tr>\n<tr>\n<td width=\"163\">Help</td>\n<td width=\"148\">F1</td>\n<td width=\"264\">Help button at top right of Ribbon</td>\n</tr>\n<tr>\n<td width=\"163\">New Slide</td>\n<td width=\"148\">Ctrl+M</td>\n<td width=\"264\">Home tab, New Slide command</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Slide show shortcuts","thumb":null,"image":null,"content":"<p>PowerPoint 2019 is designed to create slides that are presented directly on a screen rather than printed out. The screen can be your computer’s own monitor, a projector, or an external monitor, such as a giant-screen TV. In most cases, the default settings for showing a presentation are adequate. However, in some cases, you may want to take control and run the slide show yourself. The following table lists the shortcuts you’ll most often use when running a slide show.</p>\n<table>\n<tbody>\n<tr>\n<td width=\"245\"><strong>To Do This . . .</strong></td>\n<td width=\"330\"><strong>Use This . . .</strong></td>\n</tr>\n<tr>\n<td width=\"245\">Start a slide show</td>\n<td width=\"330\">F5</td>\n</tr>\n<tr>\n<td width=\"245\">Advance to the next slide</td>\n<td width=\"330\">N</td>\n</tr>\n<tr>\n<td width=\"245\">Perform the next animation</td>\n<td width=\"330\">Enter, Page Down, right arrow, down arrow, or spacebar</td>\n</tr>\n<tr>\n<td width=\"245\">Go back to the previous slide</td>\n<td width=\"330\">P</td>\n</tr>\n<tr>\n<td width=\"245\">Repeat the previous animation</td>\n<td width=\"330\">Page Up, left arrow, up arrow, or Backspace</td>\n</tr>\n<tr>\n<td width=\"245\">Go to a specific slide</td>\n<td width=\"330\">Type the slide number and then press Enter</td>\n</tr>\n<tr>\n<td width=\"245\">Display a black screen</td>\n<td width=\"330\">B</td>\n</tr>\n<tr>\n<td width=\"245\">Display a white screen</td>\n<td width=\"330\">W</td>\n</tr>\n<tr>\n<td width=\"245\">End a slide show</td>\n<td width=\"330\">Esc</td>\n</tr>\n<tr>\n<td width=\"245\">Go to the next hidden slide</td>\n<td width=\"330\">H</td>\n</tr>\n<tr>\n<td width=\"245\">Display a pen cursor</td>\n<td width=\"330\">Ctrl+P</td>\n</tr>\n<tr>\n<td width=\"245\">Display an arrow cursor</td>\n<td width=\"330\">Ctrl+A</td>\n</tr>\n<tr>\n<td width=\"245\">Hide the cursor</td>\n<td width=\"330\">Ctrl+H</td>\n</tr>\n</tbody>\n</table>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"Two years","lifeExpectancySetFrom":"2022-04-05T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255537},{"headers":{"creationTime":"2018-09-12T03:01:19+00:00","modifiedTime":"2022-03-28T14:19:43+00:00","timestamp":"2022-03-28T18:01:05+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"Excel 2019 All-in-One For Dummies Cheat Sheet","strippedTitle":"excel 2019 all-in-one for dummies cheat sheet","slug":"excel-2019-all-in-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"This Cheat Sheet for Excel 2019 can serve as a quick reference for File menu commands, sharing workbooks, creating pivot tables, and more.","noIndex":0,"noFollow":0},"content":"In Microsoft Excel 2019, you can use the keyboard to select cells and access hot key sequences that can greatly speed up the process of selecting program commands. Excel 2019 also makes it easy to set regional dates, share workbooks saved on your OneDrive, and add SmartArt graphics to your worksheets.\r\n\r\nIn Excel 2019, you also can sort multiple fields in a data list, create a new pivot table, or add a description to a user-defined function.\r\n\r\nThis Cheat Sheet is a handy reference to these Excel functions.","description":"In Microsoft Excel 2019, you can use the keyboard to select cells and access hot key sequences that can greatly speed up the process of selecting program commands. Excel 2019 also makes it easy to set regional dates, share workbooks saved on your OneDrive, and add SmartArt graphics to your worksheets.\r\n\r\nIn Excel 2019, you also can sort multiple fields in a data list, create a new pivot table, or add a description to a user-defined function.\r\n\r\nThis Cheat Sheet is a handy reference to these Excel functions.","blurb":"","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259741,"title":"How to Use the Excel 2019 Solver","slug":"how-to-use-the-excel-2019-solver","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259741"}},{"articleId":259735,"title":"How to Password-Protect Your Excel 2019 File","slug":"how-to-password-protect-your-excel-2019-file","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259735"}},{"articleId":259729,"title":"How to Create Forecast Worksheets in Excel 2019","slug":"how-to-create-forecast-worksheets-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259729"}},{"articleId":259724,"title":"How to Use the 3D Map Feature in Excel 2019","slug":"how-to-use-the-3d-map-feature-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259724"}},{"articleId":259717,"title":"Transforming a Data Query in the Power Query Editor in Excel 2019","slug":"transforming-a-data-query-in-the-power-query-editor-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259717"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281708,"slug":"excel-2019-all-in-one-for-dummies","isbn":"9781119517948","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/111951794X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/111951794X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/111951794X-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/111951794X/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/111951794X/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/excel-2019-all-in-one-for-dummies-cover-9781119517948-203x255.jpg","width":203,"height":255},"title":"Excel 2019 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"9027\">Greg Harvey, PhD,</b> is a veteran computer educator dating back to the days of DOS and Lotus 1-2-3. He has taught spreadsheet and database management courses at Golden Gate University and written dozens of books, including many in the <i>For Dummies</i> series. </p>","authors":[{"authorId":9027,"name":"Greg Harvey","slug":"greg-harvey","description":"Greg Harvey, PhD, was president of Mind Over Media and a highly skilled instructor. He wrote computer books for more than 20 years, and his long list of best sellers included all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. He died in 2020.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9027"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119517948&quot;]}]\" id=\"du-slot-6241f7e1cb299\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;excel&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119517948&quot;]}]\" id=\"du-slot-6241f7e1cc4c0\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":255335,"title":"Hot Keys for the Excel 2019 File Menu Commands","slug":"hot-keys-for-the-excel-2019-file-menu-commands","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255335"}},{"articleId":255338,"title":"How to Select Cells with the Keyboard in Excel 2019","slug":"how-to-select-cells-with-the-keyboard-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255338"}},{"articleId":255341,"title":"How to Set Regional Dates in Excel 2019","slug":"how-to-set-regional-dates-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255341"}},{"articleId":255344,"title":"How to Share Excel 2019 Workbooks Saved on Your OneDrive","slug":"how-to-share-excel-2019-workbooks-saved-on-your-onedrive","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255344"}},{"articleId":255348,"title":"How to Add SmartArt Graphics to Your Excel 2019 Worksheets","slug":"how-to-add-smartart-graphics-to-your-excel-2019-worksheets","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255348"}},{"articleId":255352,"title":"How to Sort on Multiple Fields in an Excel 2019 Data List","slug":"how-to-sort-on-multiple-fields-in-an-excel-2019-data-list","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255352"}},{"articleId":255356,"title":"How to Create a New Pivot Table with the Excel 2019 Quick Analysis Tool","slug":"how-to-create-a-new-pivot-table-with-the-excel-2019-quick-analysis-tool","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255356"}},{"articleId":255361,"title":"How to Add a Description to a User-Defined Function in Excel 2019","slug":"how-to-add-a-description-to-a-user-defined-function-in-excel-2019","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255361"}}],"content":[{"title":"Hot keys for the File menu commands","thumb":null,"image":null,"content":"<p>You can activate the Excel 2019 hot keys by pressing the Alt key before you type the various sequences of mnemonic letters. The mnemonic letter is F (for File) for the commands on the Excel 2019 File menu in the new Backstage view. Therefore, all you have to remember in the following table is the second letter in the File menu hot key sequence.</p>\n<p>Unfortunately, not all of these second letters are as easy to associate and remember as Alt+F. For example, check out the Account option hot key sequence, Alt+FD, where the second mnemonic letter doesn’t occur anywhere in the option name!</p>\n<table>\n<tbody>\n<tr>\n<td width=\"183\">Excel Ribbon Command</td>\n<td width=\"342\">Function</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Info</td>\n<td width=\"342\">Displays the Information screen in the Backstage view where you can view a preview along with statistics about the workbook as well as protect the workbook, check the file for compatibility issues, and manage different versions created by the AutoRecover feature</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→New</td>\n<td width=\"342\">Displays the New screen in the Backstage view where you can open a blank workbook from one of the available templates</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Open</td>\n<td width=\"342\">Displays the Open screen in the Backstage view where you can select a new Excel workbook to open for editing or printing</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Save</td>\n<td width=\"342\">Saves changes to a workbook: When you first select this command for a new workbook, Excel displays the Save As screen in the Backstage view where you designate the place to save the file</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Save As</td>\n<td width=\"342\">Displays the Save As screen in the Backstage view where you designate the place to save the file, the filename, and format in which the file is to be saved</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Save As Adobe PDF</td>\n<td width=\"342\">Displays the Acrobat PDF Maker dialog box where you designate the range and options to be used in converting your Excel workbook into an Adobe PDF file</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Print</td>\n<td width=\"342\">Displays the Print screen in the Backstage view where you can preview the printout and change the print settings before sending the current worksheet, workbook, or cell selection to the printer</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Share</td>\n<td width=\"342\">Displays the Share screen in the Backstage view where you can save your workbook to the cloud (if need be) before sharing it via a link in an e-mail message, send a copy as an e-mail attachment, or convert it into an Adobe PDF file for shared commenting in Adobe Acrobat Reader DC (Document Cloud)</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Export</td>\n<td width=\"342\">Displays the Export screen in the Backstage view where you can change the workbook file type or convert it to an Adobe PDF or Microsoft XPS document</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Publish</td>\n<td width=\"342\">Enables you to upload all or part of your workbook to Microsoft Power BI (Business Intelligence), a standalone program that enables you to create rich visual reports and dashboards for your Excel data</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Close</td>\n<td width=\"342\">Closes the current workbook without exiting Excel</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Account</td>\n<td width=\"342\">Displays the Account screen in the Backstage view where you can modify your user information, select a new background and theme for all Office 2019 programs, add connected storage services, and get the product ID and other information on your version of Office 2019</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Feedback</td>\n<td width=\"342\">Displays the Feedback screen in the Backstage view where you can send Microsoft your comments about Excel features you like and dislike as well as make suggestions for new features and other improvements</td>\n</tr>\n<tr>\n<td width=\"183\">File Menu→Options</td>\n<td width=\"342\">Displays the Excel Options dialog box in the regular Worksheet view where you can change default program settings, modify the buttons on the Quick Access toolbar, and customize the Excel Ribbon</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"How to select cells with the keyboard","thumb":null,"image":null,"content":"<p>Excel 2019 makes it easy for you to select cell ranges with a physical keyboard by using a technique known as <em>extending a selection</em>. To use this technique, you move the cell cursor to the active cell of the range, press F8 to turn on Extend Selection mode (indicated by Extend Selection on the Status bar), and use the direction keys to move the pointer to the last cell in the range.</p>\n<p>Excel selects all the cells that the cell cursor moves through until you turn off Extend Selection mode (by pressing F8 again).</p>\n<p>You can use the mouse as well as the keyboard to extend a selection when Excel is in Extend Selection mode. All you do is click the active cell, press F8, and then click the last cell to mark the range.</p>\n<p>You can also select a cell range with the keyboard without turning on Extend Selection mode. Here, you use a variation of the Shift+click method by moving the cell pointer to the active cell in the range, holding down the Shift key, and then using the direction keys to extend the range. After you’ve highlighted all the cells that you want to include, release the Shift key.</p>\n<p>To mark a nonadjacent selection of cells with the keyboard, you need to combine the use of Extend Selection mode with that of Add to Selection mode. To turn on Add to Selection mode (indicated by Add to Selection on the Status bar), you press Shift+F8. To mark a nonadjacent selection by using Extend Selection and Add to Selection modes, follow these steps:</p>\n<ol>\n<li>Move the cell cursor to the first cell of the first range you want to select.</li>\n<li>Press F8 to turn on Extend Selection mode.</li>\n<li>Use the arrow keys to extend the cell range until you’ve highlighted all its cells.</li>\n<li>Press Shift+F8 to turn off Extend Selection mode and turn on Add to Selection mode instead.</li>\n<li>Move the cell cursor to the first cell of the next cell range you want to add to the selection.</li>\n<li>Press F8 to turn off Add to Selection mode and turn Extend Selection mode back on.</li>\n<li>Use the arrow keys to extend the range until all cells are highlighted.</li>\n<li>Repeat Steps 4 through 7 until you’ve selected all the ranges that you want included in the nonadjacent selection.</li>\n<li>Press F8 to turn off Extend Selection mode.</li>\n</ol>\n"},{"title":"How to set regional dates","thumb":null,"image":null,"content":"<p>Excel 2019 isn’t set up to automatically recognize European date formats in which the number of the day precedes the number of the month and year.</p>\n<p>For example, you may want 6/11/2022 to represent November 6, 2022, rather than June 11, 2022. If you’re working with a spreadsheet that uses this type of European date system, you have to customize the Windows Regional settings for the United States so that the Short Date format in Windows programs, such as Excel and Word 2013, use the D/m/yyyy (day, month, year) format rather than the default M/d/yyyy (month, day, year) format.</p>\n<p>To make these changes, you follow these steps:</p>\n<ol>\n<li><strong>Click the Windows Start button and then click Settings on the Start menu.</strong> Windows 10 opens the Settings dialog box.</li>\n<li><strong>Click the Time &amp; Language button in the Settings dialog box.</strong> The Date and Time settings appear in the Settings dialog box.</li>\n<li><strong>Click the Change Date and Time formats link that appears under the Format examples that show you the current long and short date and time formatting.</strong> The Settings dialog box displays drop-down text boxes where you can select new formatting for the short and long dates.</li>\n<li><strong>Click the Short Date drop-down button, click the dd-MMM-yy format at the bottom of the drop-down list, and then click the Close button.</strong></li>\n</ol>\n<p>After changing the Short Date format in the Windows 10 Settings dialog box, the next time you launch Excel 2019, it automatically formats dates à la European; so that, for example, 3/5/22 is interpreted as May 3, 2022, rather than March 5, 2022.</p>\n<p>Change the Short Date format back to its original M/d/yyyy Short Date format for your version of Windows when working with spreadsheets that follow the “month-day-year” Short Date format preferred in the United States.</p>\n<p class=\"article-tips remember\">You have to restart Excel to get it to pick up on the changes that you make to any of the Windows date and time format settings.</p>\n"},{"title":"How to share workbooks saved to your OneDrive","thumb":null,"image":null,"content":"<p>To share Excel 2019 workbooks from your OneDrive, you follow these steps:</p>\n<ol>\n<li><strong>Open the workbook file you want to share in Excel 2019 and then click the Share button at the far right of the row with the Ribbon.</strong> If you’ve not yet saved the workbook on your OneDrive, a Share dialog box appears inviting you to upload the workbook file to OneDrive. Once you have clicked the OneDrive button and the file is uploaded to the cloud, the Share dialog box changes into the Send Link dialog box (similar to the one shown in the figure) where you specify the people with whom to share the file.</li>\n<li><strong>Begin typing the name or e-mail address of the first person with whom you want to share the workbook in the text box with the insertion point.</strong> When Excel finds a match to the person’s name in your Outlook address book or verifies the e-mail address you entered, click the button below this text box to add this recipient.</li>\n<li><strong>(Optional) Click the Anyone with This Link Can Edit drop-down button to open the Link Settings dialog box.</strong> This is where you can modify the people for whom the link works, deny editing privileges to those with whom you share the file, and/or set an expiration date after which the link is no longer operational before clicking the Apply button.</li>\n<li><strong>By default, Excel 2019 creates a sharing link that enables anyone who can access the workbook file online access to the file even when they are not logged into Office 365 or OneDrive.</strong></li>\n</ol>\n<ul>\n<li>To restrict access to only coworkers in your company who are logged into Office 365, click the People in &lt;<em>organization</em>&gt; option (where <em>organization</em> is the name of your company as in People in Mind Over Media, the name of my company).</li>\n<li>To restrict the file sharing to only those to whom you’ve given prior access to the workbook file or its folder on your SharePoint site, click the People with Existing Access option.</li>\n<li>To create a sharing link that only particular people can use, click the Specific People option before you click the Apply button.</li>\n</ul>\n<p>Then, in the Send Link dialog box, click the ellipsis (…) to the right of the Send Link title and click Manage Access on the drop-menu to open the Permissions dialog box where you select the names of the people with whom to share the workbook file before you click the back arrow button to return to the Send Link dialog box.</p>\n<p>By default, Excel allows the people with whom you share your workbooks to make editing changes to the workbook that are automatically saved on your OneDrive. If you want to restrict your recipients to reviewing the data without being able to make changes, be sure to click the Allow Editing check box to remove its check mark before you click Apply.</p>\n<p>If you wish to set an expiration date after which the sharing link is no longer operational, click the Set Expiration Date button to open the pop-up calendar where you select an expiration date by clicking it in the calendar. After selecting the expiration date, click somewhere in the dialog box to close the pop-up calendar and enter the date in the Link Settings dialog box.</p>\n<p style=\"padding-left: 30px;\"><strong> 5. (Optional) Click the Add a Message text box and type any personal message that you want to incorporate as part of the e-mail with the generic invitation to share the file.</strong></p>\n<p style=\"padding-left: 30px;\">By default, Excel creates a generic invitation.</p>\n<p style=\"padding-left: 30px;\"><strong> 6. After adding all the recipients with whom you wish to share the workbook file in this manner, click the Send button in the Send Link pane.</strong></p>\n<p style=\"padding-left: 30px;\">As soon as you click this Share button, Excel e-mails the invitation to share the workbook to each of the recipients.</p>\n<p>All the people with whom you share a workbook receive an e-mail message containing a hyperlink to the workbook on your OneDrive. When they follow this link (and sign into the site if this is required), a copy of the workbook opens on a new page in their default web browser using the Excel Online web app.</p>\n<p>If you’ve given the user permission to edit the file, the web app contains an Edit Workbook drop-down button.</p>\n<p>When the coworkers with whom you’ve shared the workbook click this button in Excel Online, they have a choice between choosing the Edit in Excel or Edit in Excel Online option from its drop-down menu.</p>\n<p>When the user chooses Edit in Excel, the workbook is downloaded and opened in his version of Excel.</p>\n<p>When the user chooses Edit in Excel Online, the browser opens the workbook in a new version of the Excel Online, containing Home, Insert, Data, Review, and View tabs, each with a more limited set of command options than Excel 2019, which you can use in making any necessary changes and which are automatically saved to workbook on the OneDrive when you close Excel Online.</p>\n<p>While sharing a workbook with the default Anyone Can Edit option, all changes made by the people with whom you’ve shared the workbook are automatically saved by the AutoSave feature.</p>\n<p>If you happen to have the workbook open in Excel 2019 on your computer with the same worksheet displayed, their editing changes automatically appear in your worksheet (in as close to real time as the speed of your Internet access provides). Likewise, all the editing changes that you make to the workbook in Excel 2019 are automatically updated in their workbooks in Excel Online. Microsoft refers to this process as co-authoring.</p>\n<p>If a questionable editing change appears in your worksheet when co-authoring with a coworker, add a comment to the cell containing the edit-in-question (Review&#8211;&gt;New Comment) that communicates your reservations about the change they made. A small balloon then appears above the cell where you made the comment in the user’s worksheet in Excel Online.</p>\n<p>When the coworker clicks this balloon, Excel Online displays the text of your comment calling into question their edit in a Comments task pane. They can then reply to your reservations by typing their explanation for the change in the same comment in this task pane and then updating it in your workbook by clicking the Post button or they can just go ahead and make any necessary updates reflecting your reservations directly in the worksheet in Excel Online.</p>\n"},{"title":"How to add SmartArt graphics to your worksheets","thumb":null,"image":null,"content":"<p>SmartArt graphics in Excel 2019 give you the ability to quickly and easily construct fancy graphical lists, diagrams, and captioned pictures in your worksheet. SmartArt lists, diagrams, and pictures come in a wide array of configurations that include a variety of organizational charts and flow diagrams that enable you to add your own text to predefined graphic shapes.</p>\n<p>To insert a SmartArt graphic into the worksheet:</p>\n<ol>\n<li><strong>Click the Insert a SmartArt command button in the Illustrations group on the Ribbon’s Insert tab (or press Alt+NZIM1).</strong><br />\nExcel opens the Choose a SmartArt Graphic dialog box.</li>\n<li><strong>Select a category in the navigation pane on the left followed by the list’s or diagram’s thumbnail in the center section before you click OK.</strong><br />\nExcel inserts the basic structure of the list, diagram, or picture into your worksheet with [Text ] placeholders (as shown in the figure) showing where you can enter titles, descriptions, captions, and, in the case of, SmartArt pictures, picture icons showing where you can insert your own pictures into the SmartArt graphic. At the same time, the Design tab of the SmartArt Tools contextual tab appears on the Ribbon with Layouts and SmartArt Styles galleries for the particular type of SmartArt list or diagram you originally selected.<br />\n<img loading=\"lazy\" class=\"alignnone size-full wp-image-255349\" src=\"https://www.dummies.com/wp-content/uploads/excel-smartart.jpg\" alt=\"excel-smartart\" width=\"1024\" height=\"768\" /></li>\n<li><strong>To fill in the text for the first for your new SmartArt graphic, click its [Text] placeholder and then simply type the text.</strong></li>\n<li><strong>When you finish entering the text for your new diagram, click outside the graphic to deselect it.</strong>\n<p class=\"article-tips remember\">If the style of the SmartArt list or diagram you select comes with more sections than you need, you can delete the unused graphics by clicking them to select them (indicated by the selection and rotation handles around it) and then pressing the Delete key.</p>\n<p>If the SmartArt graphic object you’ve added to your worksheet is one of those from the Picture group of the Choose a SmartArt Graphic dialog box, your selected SmartArt graphic contains an Insert Picture button (marked only by a small picture icon) along with the [Text] indicators.</li>\n<li><strong>(Optional) To add a graphic image to the SmartArt object, click the picture icon to open an Insert Pictures dialog box</strong>. This dialog box contains the following three options:</li>\n</ol>\n<ul>\n<li><strong>From a File</strong> to open the Insert Picture dialog box where you can select a local photo or other graphic image saved in a local or networked drive on your computer.</li>\n<li><strong>Online Pictures</strong> to open the Online Pictures dialog box where you can download a photo or other graphic image from online source such as Flickr or your OneDrive.</li>\n<li><strong>From Icons</strong> to open the Insert Icons dialog box where you can select one of the many categories of black and white images to insert.</li>\n</ul>\n"},{"title":"How to sort on multiple fields in a data list","thumb":null,"image":null,"content":"<p>When you need to sort a data list on more than one field, you use the Sort dialog box (shown in the figure). And you need to sort on more than one field when the first field contains duplicate values and you want to determine how the records with duplicates are arranged. (If you don’t specify another field to sort on, Excel just puts the records in the order in which you entered them.)</p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-255353\" src=\"https://www.dummies.com/wp-content/uploads/excel-sort.jpg\" alt=\"excel-sort\" width=\"600\" height=\"275\" /></p>\n<p>The best and most common example of when you need more than one field is when sorting a large database alphabetically in last-name order. Say that you have a database that contains several people with the last name Smith, Jones, or Zastrow (as is the case when you work at Zastrow and Sons).</p>\n<p>If you specify the Last Name field as the only field to sort on (using the default ascending order), all the duplicate Smiths, Joneses, and Zastrows are placed in the order in which their records were originally entered. To better sort these duplicates, you can specify the First Name field as the second field to sort on (again using the default ascending order), making the second field the tie-breaker, so that Ian Smith’s record precedes that of Sandra Smith, and Vladimir Zastrow’s record comes after that of Mikhail Zastrow.</p>\n<p>To sort records in a data list using the Sort dialog box, follow these steps:</p>\n<ol>\n<li><strong>Position the cell cursor in one of the cells in the data list table.</strong></li>\n<li><strong>Click the Sort button in the Sort &amp; Filter group on the Data tab or press Alt+ASS.</strong><br />\nExcel selects all the records of the database (without including the first row of field names) and opens the Sort dialog box. Note that you can also open the Sort dialog box by selecting the Custom Sort option on the Sort &amp; Filter drop-down button’s menu or by pressing Alt+HSU.</li>\n<li><strong>Select the name of the field you first want the records sorted by from the Sort By drop-down list.</strong><br />\nIf you want the records arranged in descending order, remember also to select the descending sort option (Z to A, Smallest to Largest, or Oldest to Newest) from the Order drop-down list to the right.</li>\n<li> <strong>(Optional) If the first field contains duplicates and you want to specify how the records in this field are sorted, click the Add Level button to insert another sort level, select a second field to sort on from the Then By drop-down list, and select either the ascending or descending option from its Order drop-down list to its right.</strong></li>\n<li><strong>(Optional) If necessary, repeat Step 4, adding as many additional sort levels as required.</strong></li>\n<li><strong>Click OK or press Enter.</strong><br />\nExcel closes the Sort dialog box and sorts the records in the data list using the sorting fields in the order of their levels in this dialog box. If you see that you sorted the database on the wrong fields or in the wrong order, click the Undo button on the Quick Access toolbar or press Ctrl+Z to immediately restore the data list records to their previous order.</li>\n</ol>\n<p>By default, when you perform a sort operation, Excel assumes that you’re sorting a data list that has a header row (with the field names) that is not to be reordered with the rest of the records in doing the sort.</p>\n<p>You can, however, use the Sort feature to sort a cell selection that doesn’t have such a header row. In that case, you need to specify the sorting keys by column letter, and you need to be sure to deselect the My Data Has Headers check box to remove its check mark in the Sort dialog box.</p>\n"},{"title":"How to create a new pivot table with the Quick Analysis tool","thumb":null,"image":null,"content":"<p>Excel 2019 makes it simple to create a new pivot table using a data list selected in your worksheet with its Quick Analysis tool. To preview various types of pivot tables that Excel can create for you on the spot using the entries in a data list that you have open in an Excel worksheet, simply follow these steps:</p>\n<ol>\n<li><strong>Select all the data (including the column headings) in your data list as a cell range in the worksheet.<br />\n</strong><br />\nIf you’ve assigned a range name to the data list, you can select the column headings and all the data records in one operation simply by choosing the data list’s name from the Name box drop-down menu.</li>\n<li><strong>Click the Quick Analysis tool that appears right below the lower-right corner of the current cell selection.</strong>Doing this opens the palette of Quick Analysis options with the initial Formatting tab selected and its various conditional formatting options displayed.</li>\n<li><strong>Click the Tables tab at the top of the Quick Analysis options palette.</strong>Excel selects the Tables tab and displays its Table and PivotTable option buttons. The Table button previews how the selected data would appear formatted as a table. The other PivotTable buttons preview the various types of pivot tables that can be created from the selected data.</li>\n<li><strong>To preview each pivot table that Excel 2019 can create for your data, highlight its PivotTable button in the Quick Analysis palette.</strong>As you highlight each PivotTable button in the options palette, Excel’s Live Preview feature displays a thumbnail of a pivot table that can be created using your table data. This thumbnail appears above the Quick Analysis options palette for as long as the mouse or Touch pointer is over its corresponding button.</li>\n<li><strong>When a preview of the pivot table you want to create appears, click its button in the Quick Analysis options palette to create it.</strong>Excel 2019 then creates the previewed pivot table on a new worksheet that is inserted at the beginning of the current workbook. This new worksheet containing the pivot table is active so that you can immediately rename and relocate the sheet as well as edit the new pivot table, if you wish.</li>\n</ol>\n<p>The following figures show you how this procedure works. In the first figure, the fourth suggested PivotTable button in the Quick Analysis tool’s option palette is highlighted.</p>\n<p>The previewed table in the thumbnail displayed above the palette shows the salaries subtotals and grand totals in the Employee Data list organized whether or not the employees participate in profit sharing (Yes or No).</p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-255357\" src=\"https://www.dummies.com/wp-content/uploads/excel-quick-analysis.jpg\" alt=\"excel-quick-analysis\" width=\"1024\" height=\"768\" /></p>\n<p>The second figure shows you the pivot table that Excel created when I clicked the highlighted button in the options palette in the preceding figure. Note this pivot table is selected on its own worksheet (Sheet1) that’s been inserted in front of the Employee Data worksheet. Because the new pivot table is selected, the PivotTable Fields task pane is displayed on the right side of the Excel worksheet window and the PivotTable Tools context tab is displayed on the Ribbon.</p>\n<p>You can use the options on this task pane and contextual tab to then customize your new pivot table.</p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-255358\" src=\"https://www.dummies.com/wp-content/uploads/excel-ribbon.jpg\" alt=\"excel-ribbon\" width=\"1024\" height=\"768\" /></p>\n<p class=\"article-tips remember\">Note that if Excel can’t suggest various pivot tables to create from the selected data in the worksheet, a single Blank PivotTable button is displayed after the Table button in the Quick Analysis tool’s options on the Tables tab. You can select this button to manually create a new pivot table for the data.</p>\n"},{"title":"How to add a description to a user-defined function","thumb":null,"image":null,"content":"<p>To help your user understand the purpose of your custom functions in Excel 2019, you can add descriptions that appear in Insert Function and Function Arguments dialog boxes that help explain what the function does.</p>\n<p>To add this kind of description to your user-defined function, you use the Object Browser, a special window in the Visual Basic Editor that enables you to get information about particular objects available to the project that you have open.</p>\n<p>To add a description for your user-defined function, follow these steps:</p>\n<ol>\n<li><strong>Open the Visual Basic Editor from Excel by clicking the Visual Basic button on the Developer tab of the Ribbon or pressing Alt+LV or Alt+F11.</strong><br />\nNow, you need to open the Object Browser.</li>\n<li><strong>Choose View→Object Browser from the Visual Basic Editor menu bar or press F2.</strong>This action opens the Object Browser window, which obscures the Code window.</li>\n<li><strong>Click the drop-down list box that currently contains the value &lt;All Libraries&gt; and then select VBAProject from the drop-down list.</strong><br />\nWhen you select VBAProject from this drop-down list, the Object Browser then displays your user-defined function as one of the objects in one of the Classes in the pane on the left.</li>\n<li><strong>Right-click the name of your user-defined function.</strong><br />\nThis action selects the function and displays it in the Members pane on the right, while at the same time displaying the object’s shortcut menu.</li>\n<li><strong>Click Properties on the shortcut menu.</strong>This action opens the Member Options dialog box for your user-defined function, where you can enter your description of this function, as shown in the figure.<br />\n<img loading=\"lazy\" class=\"alignnone size-full wp-image-255362\" src=\"https://www.dummies.com/wp-content/uploads/excel-member-options.jpg\" alt=\"excel-member-options\" width=\"348\" height=\"178\" /></li>\n<li><strong>Type the text that you want to appear in the Insert Function and Function Arguments dialog box for the user-defined function in the Description text box and then click OK.<br />\n</strong>Now, you can close the Object Browser and save your changes.<strong><br />\n</strong></li>\n<li><strong>Click the Close Window button to close the Object Browser and then choose the File→Save command.</strong></li>\n</ol>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-03-24T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255413},{"headers":{"creationTime":"2016-03-27T16:46:40+00:00","modifiedTime":"2022-03-25T19:02:02+00:00","timestamp":"2022-03-26T00:01:04+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Project","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33648"},"slug":"project","categoryId":33648}],"title":"Project 2016 For Dummies Cheat Sheet","strippedTitle":"project 2016 for dummies cheat sheet","slug":"project-2016-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Learn valuable tips and tricks to make project management tasks more efficient with Microsoft Project 2016.","noIndex":0,"noFollow":0},"content":"Project 2016, one incarnation of Microsoft’s popular project management software, offers a tremendous wealth of functionality. However, Microsoft Project 2016 probably isn’t like any other software you’ve ever used, so mastering it can seem a daunting process. This Cheat Sheet provides you with tips and tricks for doing what you do every day as a project manager.","description":"Project 2016, one incarnation of Microsoft’s popular project management software, offers a tremendous wealth of functionality. However, Microsoft Project 2016 probably isn’t like any other software you’ve ever used, so mastering it can seem a daunting process. This Cheat Sheet provides you with tips and tricks for doing what you do every day as a project manager.","blurb":"","authors":[{"authorId":8964,"name":"Cynthia Snyder","slug":"cynthia-snyder","description":"","_links":{"self":"https://dummies-api.dummies.com/v2/authors/8964"}}],"primaryCategoryTaxonomy":{"categoryId":33648,"title":"Project","slug":"project","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33648"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":223286,"title":"How to Modify Gridlines in Project 2016","slug":"modify-gridlines-project-2016","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/223286"}},{"articleId":223280,"title":"How to Format Gantt Chart Taskbars in Project 2016","slug":"format-gantt-chart-taskbars-project-2016","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/223280"}},{"articleId":223276,"title":"How to Reschedule the Project 2016 Project","slug":"reschedule-project-2016-project","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/223276"}},{"articleId":223271,"title":"How to Check Resource Availability in Project 2016","slug":"check-resource-availability-project-2016","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/223271"}},{"articleId":223267,"title":"How to Apply Contingency Reserve in Project 2016","slug":"apply-contingency-reserve-project-2016","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/223267"}}],"fromCategory":[{"articleId":289963,"title":"Microsoft Project For Dummies Cheat Sheet","slug":"microsoft-project-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289963"}},{"articleId":262082,"title":"How to Develop a Microsoft Project Communications Management Plan","slug":"how-to-develop-a-microsoft-project-communications-management-plan","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/262082"}},{"articleId":262079,"title":"How to Share Microsoft Project Resources","slug":"how-to-share-microsoft-project-resources","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/262079"}},{"articleId":262072,"title":"How to Manage Resources in Microsoft Project 2019","slug":"how-to-manage-resources-in-microsoft-project-2019","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/262072"}},{"articleId":262063,"title":"Continuous Learning from Microsoft Project 2019 Projects","slug":"continuous-learning-from-microsoft-project-2019-projects","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/262063"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281832,"slug":"project-2016-for-dummies","isbn":"9781119224518","categoryList":["technology","software","microsoft-products","project"],"amazon":{"default":"https://www.amazon.com/gp/product/1119224519/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119224519/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119224519-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119224519/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119224519/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/project-2016-for-dummies-cover-9781119224518-203x255.jpg","width":203,"height":255},"title":"Project 2016 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"\n <p><b data-author-id=\"19071\">Cynthia Snyder</b> is a well-known speaker, consultant, and trainer on project management, as well as the project manager of the team that updated PMI's <i>Project Management Body of Knowledge,</i> Sixth Edition. Her other books include <i>PMP Certification All-in-One For Dummies</i> and <i>A User's Manual to the PMBOK</i>. </p>","authors":[{"authorId":19071,"name":"Cynthia Snyder Dionisio","slug":"cynthia-snyder-dionisio","description":"Cynthia Snyder Dionisio is a project management consultant, trainer, and author. She also led the team that created the sixth and seventh editions of the PMBOK Guide, the standard for project management published by the Project Management Institute. She has written more than a dozen books.","_links":{"self":"https://dummies-api.dummies.com/v2/authors/19071"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;project&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119224518&quot;]}]\" id=\"du-slot-623e57c0750d7\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{&quot;key&quot;:&quot;cat&quot;,&quot;values&quot;:[&quot;technology&quot;,&quot;software&quot;,&quot;microsoft-products&quot;,&quot;project&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119224518&quot;]}]\" id=\"du-slot-623e57c075a5e\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":138355,"title":"How to Create Your Schedule with Microsoft Project 2016","slug":"how-to-create-your-schedule-with-microsoft-project-2016","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/138355"}},{"articleId":138354,"title":"12 Microsoft Project 2016 Shortcut Keys","slug":"12-microsoft-project-2016-shortcut-keys","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/138354"}},{"articleId":138353,"title":"Helpful Websites to Hone Microsoft Project 2016 Expertise","slug":"helpful-websites-to-hone-microsoft-project-2016-expertise","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/138353"}}],"content":[{"title":"How to create your schedule with Microsoft Project 2016","thumb":null,"image":null,"content":"<p>Microsoft Project 2016 makes it easy to set your project schedule. In just ten easy steps, you will be on your way to project management success!</p>\n<ol class=\"level-one\">\n<li>\n<p class=\"first-para\">Enter the project information, such as the project name and start date.</p>\n</li>\n<li>\n<p class=\"first-para\">Develop a work breakdown structure to organize your work.</p>\n</li>\n<li>\n<p class=\"first-para\">Enter the tasks needed to create the WBS deliverables.</p>\n<p class=\"child-para\">Don’t forget to indicate if you want manual or auto-scheduled tasks, and the task type.</p>\n</li>\n<li>\n<p class=\"first-para\">Link your tasks to show dependencies and create a network diagram</p>\n</li>\n<li>\n<p class=\"first-para\">Enter the resources who will work on your project, their cost/rate, and the time they have available.</p>\n</li>\n<li>\n<p class=\"first-para\">Estimate the effort or duration for each task.</p>\n</li>\n<li>\n<p class=\"first-para\">Assign resources to each task.</p>\n</li>\n<li>\n<p class=\"first-para\">Resolve any resource conflicts.</p>\n</li>\n<li>\n<p class=\"first-para\">Balance schedule, cost, resource, and performance constraints to meet stakeholder expectations.</p>\n</li>\n<li>\n<p class=\"first-para\">Baseline your schedule.</p>\n</li>\n</ol>\n"},{"title":"12 Microsoft Project 2016 shortcut keys","thumb":null,"image":null,"content":"<p>Microsoft Project 2016 maximizes efficiency as you manage projects — but Project 2016 shortcuts also save you time at the keyboard. Here are some shortcut keys you’ll use all the time when building and working with a Project schedule.</p>\n<table>\n<tbody>\n<tr>\n<th>Keystroke</th>\n<th>Result</th>\n</tr>\n<tr>\n<td>Ctrl+N</td>\n<td>Opens a new blank Project</td>\n</tr>\n<tr>\n<td>Alt+Home</td>\n<td>Moves to the beginning of the project</td>\n</tr>\n<tr>\n<td>Alt+End</td>\n<td>Moves the end of a project</td>\n</tr>\n<tr>\n<td>Alt+Right Arrow</td>\n<td>Moves the timeline to the right</td>\n</tr>\n<tr>\n<td>Alt+Left Arrow</td>\n<td>Moves the timeline to the left</td>\n</tr>\n<tr>\n<td>Shift+F2</td>\n<td>Opens the Task Information dialog box</td>\n</tr>\n<tr>\n<td>Ctrl+F</td>\n<td>Displays the Find dialog box</td>\n</tr>\n<tr>\n<td>Ctrl+Z</td>\n<td>Undoes the previous action</td>\n</tr>\n<tr>\n<td>Ctrl+P</td>\n<td>Displays the Print preview in the Backstage</td>\n</tr>\n<tr>\n<td>Ctrl+S</td>\n<td>Saves the file</td>\n</tr>\n<tr>\n<td>Alt+Shift+Hyphen (–)</td>\n<td>Hides subtasks</td>\n</tr>\n<tr>\n<td>Alt+Shift+Plus Sign (+)</td>\n<td>Shows subtasks</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Helpful websites to hone Microsoft Project 2016 expertise","thumb":null,"image":null,"content":"<p>Whether you consider project management an art or skill, Microsoft Project 2016 helps you do it better. Enhance your Microsoft Project expertise by visiting websites that offer templates and third-party add-ins for Microsoft Project and other project management information. Check out the following websites:</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\"><a href=\"http://www.pmi.org/\" target=\"_blank\" rel=\"noopener\">Project Management Institute</a></p>\n</li>\n<li>\n<p class=\"first-para\"><a href=\"http://www.projectmanagement.com/\" target=\"_blank\" rel=\"noopener\">ProjectManagement.com</a></p>\n</li>\n<li>\n<p class=\"first-para\"><a href=\"http://templates.office.com\" target=\"_blank\" rel=\"noopener\">Templates.office.com</a></p>\n</li>\n</ul>\n"}],"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":"One year","lifeExpectancySetFrom":"2022-03-25T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":207389}],"_links":{"self":{"self":"https://dummies-api.dummies.com/v2/categories/33618/categoryArticles?sortField=time&sortOrder=1&size=10&offset=0"},"next":{"self":"https://dummies-api.dummies.com/v2/categories/33618/categoryArticles?sortField=time&sortOrder=1&size=10&offset=10"},"last":{"self":"https://dummies-api.dummies.com/v2/categories/33618/categoryArticles?sortField=time&sortOrder=1&size=10&offset=3188"}}},"objectTitle":"","status":"success","pageType":"article-category","objectId":"33618","page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{"categoriesFilter":[{"itemId":0,"itemName":"All Categories","count":3197},{"itemId":33619,"itemName":"Adobe Products","count":194},{"itemId":33633,"itemName":"Animation Software","count":25},{"itemId":34381,"itemName":"Apple Products","count":36},{"itemId":33634,"itemName":"Design Software","count":65},{"itemId":33638,"itemName":"Garageband","count":5},{"itemId":34390,"itemName":"Google Products","count":40},{"itemId":33639,"itemName":"Marketing Software","count":43},{"itemId":33642,"itemName":"Microsoft Products","count":2400},{"itemId":33653,"itemName":"Money Management Software","count":200},{"itemId":34356,"itemName":"Music Recording Software","count":74},{"itemId":34393,"itemName":"Other Software","count":101},{"itemId":33659,"itemName":"Videoconference Software","count":14}],"articleTypeFilter":[{"articleType":"All Types","count":3197},{"articleType":"Articles","count":2615},{"articleType":"Cheat Sheet","count":97},{"articleType":"Step by Step","count":458},{"articleType":"Videos","count":27}]},"filterDataLoadedStatus":"success","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2022-05-23T18:59:07+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"<!--Optimizely Script-->\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"<!-- comScore Tag -->\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n<!-- / comScore Tag -->","enabled":true},{"pages":["all"],"location":"footer","script":"<!--BEGIN QUALTRICS WEBSITE FEEDBACK SNIPPET-->\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'><!--DO NOT REMOVE-CONTENTS PLACED HERE--></div>\r\n<!--END WEBSITE FEEDBACK SNIPPET-->","enabled":false},{"pages":["all"],"location":"header","script":"<!-- Hotjar Tracking Code for http://www.dummies.com -->\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":"<!-- //Connect Container: dummies --> <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"<!-- Facebook Pixel Code -->\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n<!-- End Facebook Pixel Code -->","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"ArticleCategory","path":"/category/articles/software-33618/","hash":"","query":{},"params":{"category":"software-33618"},"fullPath":"/category/articles/software-33618/","meta":{"routeType":"category","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"sfmcState":{"newsletterSignupStatus":"initial"}}
Logo
  • Articles Open Article Categories
  • Books Open Book Categories
  • Collections Open Collections list
  • Custom Solutions
  • Home
  • Technology Articles
  • Software Articles

Software Articles

From photo-editing apps to music recording software, these articles have the lowdown on your favorite programs.

Browse By Category

Adobe Products

Animation Software

Design Software

Garageband

Marketing Software

Microsoft Products

Money Management Software

Productivity Software

Videoconference Software

Music Recording Software

Apple Products

Google Products

Other Software

Previous slideNext slide

Adobe Products

Animation Software

Design Software

Garageband

Marketing Software

Microsoft Products

Money Management Software

Productivity Software

Videoconference Software

Music Recording Software

Apple Products

Google Products

Other Software

Articles From Software

page 1
page 2
page 3
page 4
page 5
page 6
page 7
page 8
page 9
page 10
page 11
page 12
page 13
page 14
page 15
page 16
page 17
page 18
page 19
page 20
page 21
page 22
page 23
page 24
page 25
page 26
page 27
page 28
page 29
page 30
page 31
page 32
page 33
page 34
page 35
page 36
page 37
page 38
page 39
page 40
page 41
page 42
page 43
page 44
page 45
page 46
page 47
page 48
page 49
page 50
page 51
page 52
page 53
page 54
page 55
page 56
page 57
page 58
page 59
page 60
page 61
page 62
page 63
page 64
page 65
page 66
page 67
page 68
page 69
page 70
page 71
page 72
page 73
page 74
page 75
page 76
page 77
page 78
page 79
page 80
page 81
page 82
page 83
page 84
page 85
page 86
page 87
page 88
page 89
page 90
page 91
page 92
page 93
page 94
page 95
page 96
page 97
page 98
page 99
page 100
page 101
page 102
page 103
page 104
page 105
page 106
page 107
page 108
page 109
page 110
page 111
page 112
page 113
page 114
page 115
page 116
page 117
page 118
page 119
page 120
page 121
page 122
page 123
page 124
page 125
page 126
page 127
page 128
page 129
page 130
page 131
page 132
page 133
page 134
page 135
page 136
page 137
page 138
page 139
page 140
page 141
page 142
page 143
page 144
page 145
page 146
page 147
page 148
page 149
page 150
page 151
page 152
page 153
page 154
page 155
page 156
page 157
page 158
page 159
page 160
page 161
page 162
page 163
page 164
page 165
page 166
page 167
page 168
page 169
page 170
page 171
page 172
page 173
page 174
page 175
page 176
page 177
page 178
page 179
page 180
page 181
page 182
page 183
page 184
page 185
page 186
page 187
page 188
page 189
page 190
page 191
page 192
page 193
page 194
page 195
page 196
page 197
page 198
page 199
page 200
page 201
page 202
page 203
page 204
page 205
page 206
page 207
page 208
page 209
page 210
page 211
page 212
page 213
page 214
page 215
page 216
page 217
page 218
page 219
page 220
page 221
page 222
page 223
page 224
page 225
page 226
page 227
page 228
page 229
page 230
page 231
page 232
page 233
page 234
page 235
page 236
page 237
page 238
page 239
page 240
page 241
page 242
page 243
page 244
page 245
page 246
page 247
page 248
page 249
page 250
page 251
page 252
page 253
page 254
page 255
page 256
page 257
page 258
page 259
page 260
page 261
page 262
page 263
page 264
page 265
page 266
page 267
page 268
page 269
page 270
page 271
page 272
page 273
page 274
page 275
page 276
page 277
page 278
page 279
page 280
page 281
page 282
page 283
page 284
page 285
page 286
page 287
page 288
page 289
page 290
page 291
page 292
page 293
page 294
page 295
page 296
page 297
page 298
page 299
page 300
page 301
page 302
page 303
page 304
page 305
page 306
page 307
page 308
page 309
page 310
page 311
page 312
page 313
page 314
page 315
page 316
page 317
page 318
page 319
page 320

Filter Results

3,198 results
3,198 results
QuickBooks QuickBooks 2019 For Dummies Cheat Sheet

Cheat Sheet / Updated 05-02-2022

QuickBooks 2019 makes small-business accounting fast and easy. But your day-to-day business bookkeeping will go even more smoothly if you employ a handful of QuickBooks user interface tricks, editing tricks, and keyboard shortcuts.

View Cheat Sheet
QuickBooks QuickBooks Simple Start For Dummies Cheat Sheet

Cheat Sheet / Updated 04-27-2022

Keeping track of your accounting with QuickBooks Simple Start means organizing your debits and credits, applying user interface tips, using calculating and editing tricks, working efficiently with keyboard shortcuts, and right-clicking on your mouse to perform basic tasks in QuickBooks Simple Start.

View Cheat Sheet
SharePoint SharePoint 2016 For Dummies Cheat Sheet

Cheat Sheet / Updated 04-26-2022

Microsoft SharePoint Server 2016 provides a web-based platform that your organization can leverage to be more productive and more competitive. With SharePoint 2016, you can manage content, publish information, track processes, and manage your overall business activities. In addition, SharePoint 2016 provides social features, such as microblogging, feeds, likes, mentions, and hash tags, to get everyone in your organization on the same page and communicating effectively.

View Cheat Sheet
Excel Excel 2010 All-in-One For Dummies Cheat Sheet

Cheat Sheet / Updated 04-20-2022

As an integral part of the Ribbon interface used by the major applications included in Microsoft Office 2010, Excel gives you access to hot keys that can help you select program commands more quickly. As soon as you press the Alt key, Excel displays the mnemonic letter choices on the various tabs and command buttons on the Ribbon. Then, simply press the mnemonic (or not-so-mnemonic) letters to perform a particular task.

View Cheat Sheet
Excel Excel 2010 For Dummies Cheat Sheet

Cheat Sheet / Updated 04-18-2022

At first glance, you might have trouble making sense of the many menus, tabs, columns, and rows of the Excel 2010 user interface. This Cheat Sheet will help you navigate your way by showing you keystrokes for moving the cell cursor to a new cell, simple rules of data-entry etiquette, common causes of some formula error values, and a quick list of the best Excel 2010 features.

View Cheat Sheet
Apple Products Apple One For Dummies Cheat Sheet

Cheat Sheet / Updated 04-18-2022

The Apple TV streaming device and iCloud.com are two of the ways you can access many of your Apple One services. Get the most out of your Apple TV’s Siri remote control and discover the best web browsers to use with iCloud.com, ensuring a better consumer experience.

View Cheat Sheet
Google Products G Suite For Dummies Cheat Sheet

Cheat Sheet / Updated 04-14-2022

G Suite offers a huge number of keyboard shortcuts that not only enable you to navigate the app interfaces quickly but also let you easily invoke many app features and settings. Here, you see some of the more useful shortcuts that are common to the G Suite apps, as well as some handy shortcuts you can use with Gmail and Calendar. Do you need to memorize them all? Don't be silly. But read through the lists — you'll probably find two or three that you'll use every day.

View Cheat Sheet
PowerPoint PowerPoint 2019 For Dummies Cheat Sheet

Cheat Sheet / Updated 04-05-2022

PowerPoint 2019 is the most powerful presentation software available to create and edit slide show presentations for work, home, or school. PowerPoint 2019 offers a number of helpful keyboard shortcuts for performing tasks quickly. Here are some shortcuts for common PowerPoint formatting, editing, and file and document tasks. Additionally, after you’ve created your masterpiece, you can use a number of shortcuts when running your slide show.

View Cheat Sheet
Excel Excel 2019 All-in-One For Dummies Cheat Sheet

Cheat Sheet / Updated 03-28-2022

In Microsoft Excel 2019, you can use the keyboard to select cells and access hot key sequences that can greatly speed up the process of selecting program commands. Excel 2019 also makes it easy to set regional dates, share workbooks saved on your OneDrive, and add SmartArt graphics to your worksheets. In Excel 2019, you also can sort multiple fields in a data list, create a new pivot table, or add a description to a user-defined function. This Cheat Sheet is a handy reference to these Excel functions.

View Cheat Sheet
Project Project 2016 For Dummies Cheat Sheet

Cheat Sheet / Updated 03-25-2022

Project 2016, one incarnation of Microsoft’s popular project management software, offers a tremendous wealth of functionality. However, Microsoft Project 2016 probably isn’t like any other software you’ve ever used, so mastering it can seem a daunting process. This Cheat Sheet provides you with tips and tricks for doing what you do every day as a project manager.

View Cheat Sheet
page 1
page 2
page 3
page 4
page 5
page 6
page 7
page 8
page 9
page 10
page 11
page 12
page 13
page 14
page 15
page 16
page 17
page 18
page 19
page 20
page 21
page 22
page 23
page 24
page 25
page 26
page 27
page 28
page 29
page 30
page 31
page 32
page 33
page 34
page 35
page 36
page 37
page 38
page 39
page 40
page 41
page 42
page 43
page 44
page 45
page 46
page 47
page 48
page 49
page 50
page 51
page 52
page 53
page 54
page 55
page 56
page 57
page 58
page 59
page 60
page 61
page 62
page 63
page 64
page 65
page 66
page 67
page 68
page 69
page 70
page 71
page 72
page 73
page 74
page 75
page 76
page 77
page 78
page 79
page 80
page 81
page 82
page 83
page 84
page 85
page 86
page 87
page 88
page 89
page 90
page 91
page 92
page 93
page 94
page 95
page 96
page 97
page 98
page 99
page 100
page 101
page 102
page 103
page 104
page 105
page 106
page 107
page 108
page 109
page 110
page 111
page 112
page 113
page 114
page 115
page 116
page 117
page 118
page 119
page 120
page 121
page 122
page 123
page 124
page 125
page 126
page 127
page 128
page 129
page 130
page 131
page 132
page 133
page 134
page 135
page 136
page 137
page 138
page 139
page 140
page 141
page 142
page 143
page 144
page 145
page 146
page 147
page 148
page 149
page 150
page 151
page 152
page 153
page 154
page 155
page 156
page 157
page 158
page 159
page 160
page 161
page 162
page 163
page 164
page 165
page 166
page 167
page 168
page 169
page 170
page 171
page 172
page 173
page 174
page 175
page 176
page 177
page 178
page 179
page 180
page 181
page 182
page 183
page 184
page 185
page 186
page 187
page 188
page 189
page 190
page 191
page 192
page 193
page 194
page 195
page 196
page 197
page 198
page 199
page 200
page 201
page 202
page 203
page 204
page 205
page 206
page 207
page 208
page 209
page 210
page 211
page 212
page 213
page 214
page 215
page 216
page 217
page 218
page 219
page 220
page 221
page 222
page 223
page 224
page 225
page 226
page 227
page 228
page 229
page 230
page 231
page 232
page 233
page 234
page 235
page 236
page 237
page 238
page 239
page 240
page 241
page 242
page 243
page 244
page 245
page 246
page 247
page 248
page 249
page 250
page 251
page 252
page 253
page 254
page 255
page 256
page 257
page 258
page 259
page 260
page 261
page 262
page 263
page 264
page 265
page 266
page 267
page 268
page 269
page 270
page 271
page 272
page 273
page 274
page 275
page 276
page 277
page 278
page 279
page 280
page 281
page 282
page 283
page 284
page 285
page 286
page 287
page 288
page 289
page 290
page 291
page 292
page 293
page 294
page 295
page 296
page 297
page 298
page 299
page 300
page 301
page 302
page 303
page 304
page 305
page 306
page 307
page 308
page 309
page 310
page 311
page 312
page 313
page 314
page 315
page 316
page 317
page 318
page 319
page 320

Quick Links

  • About For Dummies
  • Contact Us
  • Activate A Book Pin

Connect

Opt in to our newsletter!

By entering your email address and clicking the “Submit” button, you agree to the Terms of Use and Privacy Policy & to receive electronic communications from Dummies.com, which may include marketing promotions, news and updates.

About Dummies

Dummies has always stood for taking on complex concepts and making them easy to understand. Dummies helps everyone be more knowledgeable and confident in applying what they know. Whether it's to pass that big test, qualify for that big promotion or even master that cooking technique; people who rely on dummies, rely on it to learn the critical skills and relevant information necessary for success.

Terms of Use
Privacy Policy
Cookies Settings
Do Not Sell My Personal Info - CA Only