{"appState":{"pageLoadApiCallsStatus":true},"categoryState":{"relatedCategories":{"headers":{"timestamp":"2022-06-23T18:31:12+00:00"},"categoryId":33642,"data":{"title":"Microsoft Products","slug":"microsoft-products","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},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642}],"parentCategory":{"categoryId":33618,"title":"Software","slug":"software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"}},"childCategories":[{"categoryId":33643,"title":"Access","slug":"access","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33643"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33645,"title":"OneDrive","slug":"onedrive","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33645"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33646,"title":"Outlook","slug":"outlook","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33646"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33647,"title":"PowerPoint","slug":"powerpoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33647"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33648,"title":"Project","slug":"project","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33648"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33649,"title":"SharePoint","slug":"sharepoint","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33649"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33650,"title":"Teams","slug":"teams","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33650"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}},{"categoryId":33651,"title":"Word","slug":"word","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33651"},"image":{"src":"/img/background-image-2.fabfbd5c.png","width":0,"height":0}},{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"image":{"src":"/img/background-image-1.daf74cf0.png","width":0,"height":0}}],"description":"Hundreds of how-tos and tips for Word, Excel, Access, SharePoint, Project, and all your other Microsoft favorites.","relatedArticles":{"self":"https://dummies-api.dummies.com/v2/articles?category=33642&offset=0&size=5"}},"_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"}},"relatedCategoriesLoadedStatus":"success"},"listState":{"list":{"count":10,"total":2400,"items":[{"headers":{"creationTime":"2016-07-14T20:10:56+00:00","modifiedTime":"2022-04-26T16:17:54+00:00","timestamp":"2022-06-22T19:37:39+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":" <p><b>Rosemarie Withee</b> is President of Portal Integrators and Founder of Scrum Now with office in Seattle, WA and Laguna, Philippines. <b>Ken Withee</b> is a Microsoft Certified Technology Specialist in SharePoint, SQL Server, and .NET. <b>Jennifer Reed</b> is a Microsoft Certified Professional in Office 365 Administration and founder of Cloud611. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9718"}},{"authorId":10888,"name":"Rosemarie Withee","slug":"rosemarie-withee","description":" <p><b>Rosemarie Withee</b> is President of Portal Integrators and Founder of Scrum Now with office in Seattle, WA and Laguna, Philippines. <b>Ken Withee</b> is a Microsoft Certified Technology Specialist in SharePoint, SQL Server, and .NET. <b>Jennifer Reed</b> is a Microsoft Certified Professional in Office 365 Administration and founder of Cloud611. ","_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":"<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":" <p><b>Rosemarie Withee</b> is President of Portal Integrators and Founder of Scrum Now with office in Seattle, WA and Laguna, Philippines. <b>Ken Withee</b> is a Microsoft Certified Technology Specialist in SharePoint, SQL Server, and .NET. <b>Jennifer Reed</b> is a Microsoft Certified Professional in Office 365 Administration and founder of Cloud611. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/10888"}},{"authorId":9718,"name":"Ken Withee","slug":"ken-withee","description":" <p><b>Rosemarie Withee</b> is President of Portal Integrators and Founder of Scrum Now with office in Seattle, WA and Laguna, Philippines. <b>Ken Withee</b> is a Microsoft Certified Technology Specialist in SharePoint, SQL Server, and .NET. <b>Jennifer Reed</b> is a Microsoft Certified Professional in Office 365 Administration and founder of Cloud611. ","_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-62b36f83170ef\"></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-62b36f8317816\"></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-06-22T19:37:37+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 is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_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":"<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 is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_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-62b36f81c6e87\"></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-62b36f81c7671\"></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-06-22T19:37:37+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":"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","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 is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_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":"<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 is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_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-62b36f812828c\"></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-62b36f8128a09\"></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":"2018-09-18T15:20:50+00:00","modifiedTime":"2022-04-05T21:18:25+00:00","timestamp":"2022-06-22T19:37:34+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":" <p><b>Doug Lowe </b>is the information technology director at Blair, Church & Flynn Consulting Engineers, a civil engineering firm. He has written more than 50 <i>For Dummies</i> books on topics ranging from Java to electronics to PowerPoint.</p> ","_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":"<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":" <p><b>Doug Lowe </b>is the information technology director at Blair, Church & Flynn Consulting Engineers, a civil engineering firm. He has written more than 50 <i>For Dummies</i> books on topics ranging from Java to electronics to PowerPoint.</p> ","_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-62b36f7e4b3de\"></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-62b36f7e4bbe1\"></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-06-22T19:37:32+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 is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_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":"<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 is a language scholar who has traced the roots of Tolkien&#146;s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon. ","_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-62b36f7c0b6f2\"></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-62b36f7c0be69\"></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-06-22T19:37:31+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":"<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":" <p><b>Cynthia Snyder Dionisio</b> is a project management consultant, trainer, and author. She also leads the team that creates the <i>PMBOK Guide,</i> the standard for project management that is published by the Project Management Institute. She has written more than a dozen books, including <i>A Project Manager&#39;s Book of Forms</i> and <i>A Project Manager&#39;s Book of Tools and Techniques.</i> \t ","_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-62b36f7bac5e9\"></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-62b36f7bacd1d\"></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},{"headers":{"creationTime":"2016-03-27T16:47:00+00:00","modifiedTime":"2022-03-25T18:58:33+00:00","timestamp":"2022-06-22T19:37:31+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":"Word","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33651"},"slug":"word","categoryId":33651}],"title":"Word 2016 For Dummies Cheat Sheet","strippedTitle":"word 2016 for dummies cheat sheet","slug":"word-2016-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Get started learning to make the best use of Word 2016 with keyboard commands and shortcuts as well as useful tricks to remember.","noIndex":0,"noFollow":0},"content":"Word is one of the most used computer programs on the planet. Helping you to compose text is one of the things that computers do well, but that doesn’t make the text-writing chore easier or imply that using Word is simple enough that you don’t need help. So enjoy this Cheat Sheet.","description":"Word is one of the most used computer programs on the planet. Helping you to compose text is one of the things that computers do well, but that doesn’t make the text-writing chore easier or imply that using Word is simple enough that you don’t need help. So enjoy this Cheat Sheet.","blurb":"","authors":[{"authorId":9003,"name":"Dan Gookin","slug":"dan-gookin","description":" <p><b>Dan Gookin</b> wrote the very first <i>For Dummies</i> book in 1991. With more than 11 million copies in print, his books have been translated into 32 languages. <i>PCs For Dummies,</i> now in its 12th edition, is the bestselling beginning PC book in the world. Dan offers tips, games, and fun at www.wambooli.com. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9003"}}],"primaryCategoryTaxonomy":{"categoryId":33651,"title":"Word","slug":"word","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33651"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":141573,"title":"Understanding the Word 2016 Ribbon","slug":"understanding-the-word-2016-ribbon","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141573"}},{"articleId":141572,"title":"Word 2016 Keyboard Command Roundup","slug":"word-2016-keyboard-command-roundup","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141572"}},{"articleId":141571,"title":"Create Labels with Graphics in Word 2016","slug":"create-labels-with-graphics-in-word-2016","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141571"}},{"articleId":141570,"title":"Word 2016 on a Touchscreen","slug":"word-2016-on-a-touchscreen","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141570"}},{"articleId":141536,"title":"Getting to Know the Word 2016 Screen","slug":"getting-to-know-the-word-2016-screen","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141536"}}],"fromCategory":[{"articleId":259145,"title":"How to Add Graphics to Word 2019 Documents","slug":"how-to-add-graphics-to-word-2019-documents","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259145"}},{"articleId":259142,"title":"How to Add Date and Time Information to Word 2019 Documents","slug":"how-to-add-date-and-time-information-to-word-2019-documents","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259142"}},{"articleId":259134,"title":"Use Fields in Word 2019 to Add Dynamic Elements","slug":"use-fields-in-word-2019-to-add-dynamic-elements","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259134"}},{"articleId":259131,"title":"How to Use Word 2019's Master Document Feature","slug":"how-to-use-word-2019s-master-document-feature","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259131"}},{"articleId":259128,"title":"How Writers Can Use Word 2019's Outline View","slug":"how-writers-can-use-word-2019s-outline-view","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259128"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281901,"slug":"word-2016-for-dummies","isbn":"9781119076896","categoryList":["technology","software","microsoft-products","word"],"amazon":{"default":"https://www.amazon.com/gp/product/1119076897/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119076897/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/1119076897-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119076897/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119076897/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/word-2016-for-dummies-cover-9781119076896-203x255.jpg","width":203,"height":255},"title":"Word 2016 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9003\">Dan Gookin </b>wrote the first-ever For Dummies book, <i>DOS For Dummies</i>. The author of several bestsellers, including all previous editions of <i>Word For Dummies</i>, Dan has written books that have been translated into 32 languages with more than 11 million copies in print. </p>","authors":[{"authorId":9003,"name":"Dan Gookin","slug":"dan-gookin","description":" <p><b>Dan Gookin</b> wrote the very first <i>For Dummies</i> book in 1991. With more than 11 million copies in print, his books have been translated into 32 languages. <i>PCs For Dummies,</i> now in its 12th edition, is the bestselling beginning PC book in the world. Dan offers tips, games, and fun at www.wambooli.com. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9003"}}],"_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;word&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119076896&quot;]}]\" id=\"du-slot-62b36f7ba3c25\"></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;word&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119076896&quot;]}]\" id=\"du-slot-62b36f7ba43a3\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":141536,"title":"Getting to Know the Word 2016 Screen","slug":"getting-to-know-the-word-2016-screen","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141536"}},{"articleId":141573,"title":"Understanding the Word 2016 Ribbon","slug":"understanding-the-word-2016-ribbon","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141573"}},{"articleId":141572,"title":"Word 2016 Keyboard Command Roundup","slug":"word-2016-keyboard-command-roundup","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141572"}},{"articleId":141518,"title":"Using Word 2016’s Special-Character Keyboard Shortcuts","slug":"using-word-2016s-special-character-keyboard-shortcuts","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141518"}},{"articleId":141515,"title":"Word 2016 Tricks to Remember","slug":"word-2016-tricks-to-remember","categoryList":["technology","software","microsoft-products","word"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141515"}}],"content":[{"title":"Getting to know the Word 2016 screen","thumb":null,"image":null,"content":"<p>Behold Word 2016’s screen. You see the promise of a new document and a bewildering number of buttons and gizmos. Here are the important elements that you will most likely need to remember:</p>\n<p><img loading=\"lazy\" src=\"https://www.dummies.com/wp-content/uploads/488373.image0.jpg\" alt=\"image0.jpg\" width=\"441\" height=\"400\" /></p>\n"},{"title":"Understanding the Word 2016 Ribbon","thumb":null,"image":null,"content":"<p>Microsoft Word 2016’s Ribbon presents tabs that you can click to reveal groups of helpful icons. These icons represent command buttons, input boxes, and menus that are helpful when navigating through a Word document.</p>\n<p><img loading=\"lazy\" src=\"https://www.dummies.com/wp-content/uploads/488375.image0.jpg\" alt=\"image0.jpg\" width=\"535\" height=\"218\" /></p>\n"},{"title":"Word 2016 keyboard command roundup","thumb":null,"image":null,"content":"<p>Word 2016 has many keyboard commands to offer you. Whether you use a computer with a honking 105-key keyboard or a tablet with no keyboard, word processing remains a keyboard-bound activity. The following tables show how to access Microsoft Word 2016’s commands and functions.</p>\n<p>Here are all of the options you can utilize for cursor movement.</p>\n<table>\n<tbody>\n<tr>\n<th>Pressing This Key</th>\n<th>Moves the Insertion Pointer . . .</th>\n</tr>\n<tr>\n<td>uarr;</td>\n<td>Up one line of text</td>\n</tr>\n<tr>\n<td>darr;</td>\n<td>Down one line of text</td>\n</tr>\n<tr>\n<td>larr;</td>\n<td>Left to the next character</td>\n</tr>\n<tr>\n<td>→</td>\n<td>Right to the next character</td>\n</tr>\n<tr>\n<td>Ctrl+uarr;</td>\n<td>Up one paragraph</td>\n</tr>\n<tr>\n<td>Ctrl+darr;</td>\n<td>Down one paragraph</td>\n</tr>\n<tr>\n<td>Ctrl+larr;</td>\n<td>Left one word</td>\n</tr>\n<tr>\n<td>Ctrl+→</td>\n<td>Right one word</td>\n</tr>\n<tr>\n<td>PgUp</td>\n<td>Up one screen</td>\n</tr>\n<tr>\n<td>PgDn</td>\n<td>Down one screen</td>\n</tr>\n<tr>\n<td>Home</td>\n<td>To start of current line</td>\n</tr>\n<tr>\n<td>End</td>\n<td>To end of current line</td>\n</tr>\n<tr>\n<td>Ctrl+Home</td>\n<td>To top of document</td>\n</tr>\n<tr>\n<td>Ctrl+End</td>\n<td>To bottom of document</td>\n</tr>\n</tbody>\n</table>\n<p>Here are some basic editing commands that are always helpful when word processing.</p>\n<table>\n<tbody>\n<tr>\n<td>Copy</td>\n<td>Ctrl+C</td>\n</tr>\n<tr>\n<td>Cut</td>\n<td>Ctrl+X</td>\n</tr>\n<tr>\n<td>Paste</td>\n<td>Ctrl+V</td>\n</tr>\n<tr>\n<td>Undo</td>\n<td>Ctrl+Z</td>\n</tr>\n</tbody>\n</table>\n<p>Check out these useful commands when you need to do some text formatting.</p>\n<table>\n<tbody>\n<tr>\n<td>Bold</td>\n<td>Ctrl+B</td>\n</tr>\n<tr>\n<td>Italic</td>\n<td>Ctrl+I</td>\n</tr>\n<tr>\n<td>Double underline</td>\n<td>Ctrl+Shift+D</td>\n</tr>\n<tr>\n<td>Word underline</td>\n<td>Ctrl+Shift+W</td>\n</tr>\n<tr>\n<td>Small caps</td>\n<td>Ctrl+Shift+K</td>\n</tr>\n<tr>\n<td>Superscript</td>\n<td>Ctrl+Shift++</td>\n</tr>\n<tr>\n<td>Subscript</td>\n<td>Ctrl+=</td>\n</tr>\n<tr>\n<td>Clear formatting</td>\n<td>Ctrl+spacebar</td>\n</tr>\n<tr>\n<td>Grow font</td>\n<td>Ctrl+Shift+&gt;</td>\n</tr>\n<tr>\n<td>Shrink font</td>\n<td>Ctrl+Shift+&lt;</td>\n</tr>\n<tr>\n<td>ALL CAPS</td>\n<td>Ctrl+Shift+A</td>\n</tr>\n<tr>\n<td>Font dialog box</td>\n<td>Ctrl+D</td>\n</tr>\n</tbody>\n</table>\n<p>Here are some commands that will help simplify paragraph formatting.</p>\n<table>\n<tbody>\n<tr>\n<td>Center text</td>\n<td>Ctrl+E</td>\n</tr>\n<tr>\n<td>Left-align</td>\n<td>Ctrl+L</td>\n</tr>\n<tr>\n<td>Right-align</td>\n<td>Ctrl+R</td>\n</tr>\n<tr>\n<td>One-line spacing</td>\n<td>Ctrl+1</td>\n</tr>\n<tr>\n<td>1-1/2-line spacing</td>\n<td>Ctrl+5</td>\n</tr>\n<tr>\n<td>Two-line spacing</td>\n<td>Ctrl+2</td>\n</tr>\n<tr>\n<td>Justify</td>\n<td>Ctrl+J</td>\n</tr>\n<tr>\n<td>Indent</td>\n<td>Ctrl+M</td>\n</tr>\n<tr>\n<td>Unindent</td>\n<td>Ctrl+Shift+M</td>\n</tr>\n<tr>\n<td>Hanging indent</td>\n<td>Ctrl+T</td>\n</tr>\n<tr>\n<td>Un-hang indent</td>\n<td>Ctrl+Shift+T</td>\n</tr>\n</tbody>\n</table>\n<p>And just for fun, here are some popular Word keyboard shortcuts.</p>\n<table>\n<tbody>\n<tr>\n<td>Help</td>\n<td>F1</td>\n</tr>\n<tr>\n<td>Cancel</td>\n<td>Escape</td>\n</tr>\n<tr>\n<td>Go back</td>\n<td>Shift+F5</td>\n</tr>\n<tr>\n<td>New document</td>\n<td>Ctrl+N</td>\n</tr>\n<tr>\n<td>Open screen</td>\n<td>Ctrl+O</td>\n</tr>\n<tr>\n<td>Print</td>\n<td>Ctrl+P</td>\n</tr>\n<tr>\n<td>Close document</td>\n<td>Ctrl+W</td>\n</tr>\n<tr>\n<td>Quick save</td>\n<td>Ctrl+S</td>\n</tr>\n<tr>\n<td>Repeat</td>\n<td>Ctrl+Y</td>\n</tr>\n<tr>\n<td>Find</td>\n<td>Ctrl+F</td>\n</tr>\n<tr>\n<td>Find and replace</td>\n<td>Ctrl+H</td>\n</tr>\n<tr>\n<td>Insert hard page break</td>\n<td>Ctrl+Enter</td>\n</tr>\n</tbody>\n</table>\n<p>Haven’t found what you’re looking for? Check out these uncommon (but useful) Word keyboard shortcuts.</p>\n<table>\n<tbody>\n<tr>\n<td>Go to</td>\n<td>F5</td>\n</tr>\n<tr>\n<td>Show/hide nonprinting characters</td>\n<td>Ctrl+Shift+8</td>\n</tr>\n<tr>\n<td>File screen</td>\n<td>Alt+F</td>\n</tr>\n<tr>\n<td>Styles task pane</td>\n<td>Ctrl+Shift+Alt+S</td>\n</tr>\n<tr>\n<td>Word count</td>\n<td>Ctrl+Shift+G</td>\n</tr>\n<tr>\n<td>Symbol font</td>\n<td>Ctrl+Shift+Q</td>\n</tr>\n<tr>\n<td>Print Layout view</td>\n<td>Ctrl+Alt+P</td>\n</tr>\n<tr>\n<td>Draft (normal) mode</td>\n<td>Ctrl+Alt+N</td>\n</tr>\n<tr>\n<td>Outline mode</td>\n<td>Ctrl+Alt+O</td>\n</tr>\n<tr>\n<td>Split window</td>\n<td>Alt+Ctrl+S</td>\n</tr>\n<tr>\n<td>Track revisions</td>\n<td>Alt+Shift+E</td>\n</tr>\n</tbody>\n</table>\n<p>And finally, here are some commands that insert something.</p>\n<table>\n<tbody>\n<tr>\n<td>Today’s date</td>\n<td>Alt+Shift+D</td>\n</tr>\n<tr>\n<td>Current time</td>\n<td>Alt+Shift+T</td>\n</tr>\n<tr>\n<td>Paste special</td>\n<td>Alt+Ctrl+V</td>\n</tr>\n<tr>\n<td>Footnote</td>\n<td>Alt+Ctrl+F</td>\n</tr>\n<tr>\n<td>Endnote</td>\n<td>Alt+Ctrl+D</td>\n</tr>\n<tr>\n<td>Comment</td>\n<td>Ctrl+Alt+M</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Using Word 2016’s special-character keyboard shortcuts","thumb":null,"image":null,"content":"<p>Some key combinations insert characters into your Word 2016 document. If you find these characters useful in your day-to-day typing duties, you may want to consider using their keyboard shortcuts:</p>\n<table>\n<tbody>\n<tr>\n<th>Symbol Name</th>\n<th>Symbol</th>\n<th>Keys to Press</th>\n</tr>\n<tr>\n<td>Euro</td>\n<td>€</td>\n<td>Ctrl+Alt+E</td>\n</tr>\n<tr>\n<td>Trademark</td>\n<td>™</td>\n<td>Ctrl+Alt+T</td>\n</tr>\n<tr>\n<td>Copyright</td>\n<td>©</td>\n<td>Ctrl+Alt+C</td>\n</tr>\n<tr>\n<td>Registered</td>\n<td>®</td>\n<td>Ctrl+Alt+R</td>\n</tr>\n<tr>\n<td>En dash</td>\n<td>–</td>\n<td>Ctrl+minus key on the numeric keypad</td>\n</tr>\n<tr>\n<td>Em dash</td>\n<td>—</td>\n<td>Ctrl+Alt+minus key on the numeric keypad</td>\n</tr>\n<tr>\n<td>Unbreakable space</td>\n<td></td>\n<td>Ctrl+Shift+space</td>\n</tr>\n<tr>\n<td>Unbreakable hyphen</td>\n<td>&#8211;</td>\n<td>Ctrl+Shift+- (hyphen)</td>\n</tr>\n</tbody>\n</table>\n"},{"title":"Word 2016 tricks to remember","thumb":null,"image":null,"content":"<p>Here’s a short list of the most helpful Microsoft Word 2016 tricks that may come in handy for your word-processing needs. Keep these suggestions in mind when you compose a new document:</p>\n<ul class=\"level-one\">\n<li>\n<p class=\"first-para\"><b>Press Ctrl+Enter to start a new page.</b> This key combination inserts a hard page break, which forces a new page automatically.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Press Shift+Enter to insert a soft return.</b> This keypress is useful for breaking a line of text, such as in a document title or an address.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Use tabs to line up your text.</b> Never use spaces for this task. One tab is all you need. If you’re inserting more than one tab, you need to reset the tab stops.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Always use one tab between columns to line them up.</b> Doing so will make editing the information easier.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>If you need to change the page formatting in the middle of your document, start a new section.</b> Sections allow you to use multiple page-format attributes in a single document.</p>\n</li>\n<li>\n<p class=\"first-para\"><b>Save your styles in a template! </b>That way, you can use them for documents you create without having to rebuild all your styles over and over.</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":207468},{"headers":{"creationTime":"2018-09-18T16:01:59+00:00","modifiedTime":"2022-03-25T18:40:47+00:00","timestamp":"2022-06-22T19:37:31+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":"General Microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"},"slug":"general-microsoft","categoryId":33652}],"title":"Office 2019 All-in-One For Dummies Cheat Sheet","strippedTitle":"office 2019 all-in-one for dummies cheat sheet","slug":"office-2019-all-in-one-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"Get started with Office 2019 with handy tips for opening files quickly, customizing the Quick Access toolbar and changing color scemes.","noIndex":0,"noFollow":0},"content":"Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.","description":"Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.","blurb":"","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Peter Weverka</b> is a veteran <i>For Dummies</i> author who has written about a wide variety of applications. Along with two bestselling editions of <i>Office All-in-One For Dummies</i>, Peter has written <i>PowerPoint All-in-One For Dummies</i> and <i>Microsoft Money For Dummies</i>.</p>","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"primaryCategoryTaxonomy":{"categoryId":33652,"title":"General Microsoft","slug":"general-microsoft","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33652"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":259408,"title":"What Is Outlook?","slug":"what-is-outlook","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259408"}},{"articleId":259402,"title":"Detecting and Correcting Errors in Excel 2019 Formulas","slug":"detecting-and-correcting-errors-in-excel-2019-formulas","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259402"}},{"articleId":259390,"title":"How to Touch Up a Picture Using Office 2019 Tools","slug":"how-to-touch-up-a-picture-using-office-2019-tools","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259390"}},{"articleId":259292,"title":"How Excel Formulas Work","slug":"how-excel-formulas-work","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259292"}},{"articleId":259285,"title":"Office 2019 Chart Tricks for the Daring and Heroic","slug":"office-2019-chart-tricks-for-the-daring-and-heroic","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/259285"}}],"fromCategory":[{"articleId":291623,"title":"Office 2021 For Macs For Dummies Cheat Sheet","slug":"office-2021-for-macs-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/291623"}},{"articleId":290233,"title":"Microsoft 365 For Dummies Cheat Sheet","slug":"microsoft-365-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290233"}},{"articleId":290196,"title":"Office 2021 All-in-One For Dummies Cheat Sheet","slug":"office-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/290196"}},{"articleId":289688,"title":"Office 2021 For Seniors For Dummies Cheat Sheet","slug":"office-2021-for-seniors-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/289688"}},{"articleId":265320,"title":"How to Create Charts in Office 365","slug":"how-to-create-charts-in-office-365","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265320"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281801,"slug":"office-2019-all-in-one-for-dummies","isbn":"9781119513278","categoryList":["technology","software","microsoft-products","general-microsoft"],"amazon":{"default":"https://www.amazon.com/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119513278/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/1119513278-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119513278/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/office-2019-all-in-one-for-dummies-cover-9781119513278-203x255.jpg","width":203,"height":255},"title":"Office 2019 All-in-One For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9034\">Peter Weverka</b> is a veteran tech writer and long-time <i>For Dummies</i> author. Among his credits are <i>Office 2016 All-in-One For Dummies</i> and <i>Windows 10 For Seniors For Dummies</i>, both top sellers in their respective categories. </p>","authors":[{"authorId":9034,"name":"Peter Weverka","slug":"peter-weverka","description":" <p><b>Peter Weverka</b> is a veteran <i>For Dummies</i> author who has written about a wide variety of applications. Along with two bestselling editions of <i>Office All-in-One For Dummies</i>, Peter has written <i>PowerPoint All-in-One For Dummies</i> and <i>Microsoft Money For Dummies</i>.</p>","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9034"}}],"_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;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513278&quot;]}]\" id=\"du-slot-62b36f7b89a76\"></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;general-microsoft&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119513278&quot;]}]\" id=\"du-slot-62b36f7b8a1c3\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":255550,"title":"Speedy Ways to Open Office 2019 Files","slug":"speedy-ways-to-open-office-2019-files","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255550"}},{"articleId":255553,"title":"Customize the Office 2019 Quick Access Toolbar","slug":"customize-the-office-2019-quick-access-toolbar","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255553"}},{"articleId":255556,"title":"Change the Background and Color Schemes of the Office 2019 Applications","slug":"change-the-background-and-color-schemes-of-the-office-2019-applications","categoryList":["technology","software","microsoft-products","general-microsoft"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/255556"}}],"content":[{"title":"Speedy ways to open Office 2019 files","thumb":null,"image":null,"content":"<p>In the interest of getting to work faster, Office 2019 (and Windows 10) offers these speed techniques for opening files:</p>\n<ul>\n<li><strong>Backstage:</strong> Click the File tab in any Office application to open what Microsoft calls the backstage. From there, you can quickly open files:\n<ul>\n<li>On the Home window (go to the Home category), click the name of a file in the Recent list or Pinned list. The Recent list shows the names of files you recently opened. The Pinned list shows the names of files you deemed important enough to &#8220;pin.&#8221; To pin a file, click its push-pin icon.</li>\n<li>On the Open screen (go to the Open category), click the name of a file in the Pinned list or Recent list. The Pinned list appears at the top of the window. Scroll through files on the Recent list to find one you worked on recently.</li>\n</ul>\n</li>\n<li><strong>Windows Start screen</strong>: This screen (which appears when you click the Start button in the lower-left corner of the screen) offers a means of quickly opening files. Scroll to the name of an Office application and right-click its name. A pop-up menu appears. Under the word <em>Recent</em> on the menu are the names of files you recently opened. Click the name of a file to open it.</li>\n<li><strong>Windows taskbar:</strong> Right-click an Office application icon on the taskbar to see a list of files you recently opened. Then select the name of a file. The taskbar is located along the bottom of the Windows screen.</li>\n<li><strong>Ctrl+N:</strong> To open a new file in any Office application, press Ctrl+N. Pressing this keyboard shortcut opens a blank, default file.</li>\n</ul>\n"},{"title":"Customize the Office 2019 Quick Access toolbar","thumb":null,"image":null,"content":"<p>The Quick Access toolbar is always there in the upper-left corner of Office applications. This toolbar offers the AutoSave, Save, Undo, and Redo buttons, as well as the Touch/Mouse Mode button if your computer has a touchscreen. Put your favorite buttons on the Quick Access toolbar to keep them within reach:</p>\n<ul>\n<li>Right-click a button and choose Add to Quick Access Toolbar on the shortcut menu.</li>\n<li>Click the Customize Quick Access Toolbar button (located to the right of the Quick Access toolbar) and choose a button name on the drop-down list.</li>\n</ul>\n<p>If you change your mind about putting a button on the Quick Access toolbar, right-click the button and choose Remove from Quick Access toolbar on the shortcut menu.</p>\n"},{"title":"Change the background and color schemes of the Office 2019 applications","thumb":null,"image":null,"content":"<p>Want to play interior decorator with Word, Excel, PowerPoint, Outlook, Access, and Publisher? Follow these steps to change the look of the Office 2019 application screens:</p>\n<ol>\n<li><strong>In any Office application, go to the File tab and choose Account.</strong><br />\nThe Account window opens.</li>\n<li><strong>Choose an Office Background option.</strong><br />\nThese options — Clouds, Spring, Underwater, and others — place a faint design motif in the upper-right corner of screens.</li>\n<li><strong>Choose an Office Theme option.</strong><br />\nThese options — Colorful, Dark Gray, Black, and White — change the overall color of Office screens. If you choose the Colorful option, each Office application appears in a different color. For example, the Word screen is blue; the PowerPoint screen is red.</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":"Two years","lifeExpectancySetFrom":"2022-03-25T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255559},{"headers":{"creationTime":"2016-03-27T16:46:57+00:00","modifiedTime":"2022-03-25T14:20:10+00:00","timestamp":"2022-06-22T19:37:31+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":"Outlook","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33646"},"slug":"outlook","categoryId":33646}],"title":"Outlook 2016 For Dummies Cheat Sheet","strippedTitle":"outlook 2016 for dummies cheat sheet","slug":"outlook-2016-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"This Cheat Sheet serves as a handy guide to Outlook 2016's Mail, Calendar, Tasks, and Contacts tabs, and keyboard shortcuts.","noIndex":0,"noFollow":0},"content":"Sending email has never been easier than it is in Outlook 2016. You'll notice the familiar Ribbon interface, and you'll still find all the Outlook features you've come to love — plus some new ones.\r\n\r\nUse this handy Cheat Sheet to orient yourself with Outlook's new look and feel. There's also a helpful table of Outlook shortcut keys.","description":"Sending email has never been easier than it is in Outlook 2016. You'll notice the familiar Ribbon interface, and you'll still find all the Outlook features you've come to love — plus some new ones.\r\n\r\nUse this handy Cheat Sheet to orient yourself with Outlook's new look and feel. There's also a helpful table of Outlook shortcut keys.","blurb":"","authors":[{"authorId":9045,"name":"Bill Dyszel","slug":"bill-dyszel","description":" <p><b>Bill Dyszel</b> is a nationally known expert on personal information management and sales automation technology. He frequently speaks at various technology conferences, and he works as a consultant for organizations that need help selecting, developing, and implementing business solutions. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9045"}}],"primaryCategoryTaxonomy":{"categoryId":33646,"title":"Outlook","slug":"outlook","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33646"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":141107,"title":"Outlook 2016 Shortcuts","slug":"outlook-2016-shortcuts","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141107"}},{"articleId":141105,"title":"Outlook 2016's Contacts Home Tab","slug":"outlook-2016s-contacts-home-tab","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141105"}},{"articleId":141104,"title":"Outlook 2016's Tasks Home Tab","slug":"outlook-2016s-tasks-home-tab","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141104"}},{"articleId":141091,"title":"Outlook 2016's Mail Home Tab","slug":"outlook-2016s-mail-home-tab","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141091"}},{"articleId":141088,"title":"How to Change a Note's Size in Outlook","slug":"how-to-change-a-notes-size-in-outlook","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141088"}}],"fromCategory":[{"articleId":257449,"title":"How to Collaborate between Outlook 2019 and Exchange Server","slug":"how-to-collaborate-between-outlook-2019-and-exchange-server","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257449"}},{"articleId":257446,"title":"How to Take a Vote in Microsoft Outlook 2019","slug":"how-to-take-a-vote-in-microsoft-outlook-2019","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257446"}},{"articleId":257440,"title":"How to Set Up an RSS Feed in Microsoft Outlook 2019","slug":"how-to-set-up-an-rss-feed-in-microsoft-outlook-2019","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257440"}},{"articleId":257437,"title":"Social Media Basics and Microsoft Outlook RSS","slug":"social-media-basics-and-microsoft-outlook-rss","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257437"}},{"articleId":257432,"title":"How to Forward a Business Card from Outlook 2019","slug":"how-to-forward-a-business-card-from-outlook-2019","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/257432"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281809,"slug":"outlook-2016-for-dummies","isbn":"9781119076889","categoryList":["technology","software","microsoft-products","outlook"],"amazon":{"default":"https://www.amazon.com/gp/product/1119076889/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119076889/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/1119076889-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119076889/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119076889/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/outlook-2016-for-dummies-cover-9781119076889-203x255.jpg","width":203,"height":255},"title":"Outlook 2016 For Dummies","testBankPinActivationLink":"","bookOutOfPrint":false,"authorsInfo":"<p><b data-author-id=\"9045\">Bill Dyszel</b> is a nationally known expert on personal information management and sales automation technology. He frequently speaks at various technology conferences, and he works as a consultant for organizations that need help selecting, developing, and implementing business solutions. </p>","authors":[{"authorId":9045,"name":"Bill Dyszel","slug":"bill-dyszel","description":" <p><b>Bill Dyszel</b> is a nationally known expert on personal information management and sales automation technology. He frequently speaks at various technology conferences, and he works as a consultant for organizations that need help selecting, developing, and implementing business solutions. ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/9045"}}],"_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;outlook&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119076889&quot;]}]\" id=\"du-slot-62b36f7b2239a\"></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;outlook&quot;]},{&quot;key&quot;:&quot;isbn&quot;,&quot;values&quot;:[&quot;9781119076889&quot;]}]\" id=\"du-slot-62b36f7b22ad6\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":141091,"title":"Outlook 2016's Mail Home Tab","slug":"outlook-2016s-mail-home-tab","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141091"}},{"articleId":141077,"title":"Outlook 2016's Calendar Home Tab","slug":"outlook-2016s-calendar-home-tab","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141077"}},{"articleId":141105,"title":"Outlook 2016's Contacts Home Tab","slug":"outlook-2016s-contacts-home-tab","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141105"}},{"articleId":141104,"title":"Outlook 2016's Tasks Home Tab","slug":"outlook-2016s-tasks-home-tab","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141104"}},{"articleId":141107,"title":"Outlook 2016 Shortcuts","slug":"outlook-2016-shortcuts","categoryList":["technology","software","microsoft-products","outlook"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/141107"}}],"content":[{"title":"The Mail Home tab","thumb":null,"image":null,"content":"<p>The Mail Home tab on Outlook 2016&#8217;s Ribbon contains all the tools you need for daily email tasks as well as for managing the messages you accumulate and retain for reference. The following image shows you what each of Outlook 2016&#8217;s Mail Home tab buttons can help you do.</p>\n<p><img loading=\"lazy\" src=\"https://www.dummies.com/wp-content/uploads/491175.image0.jpg\" alt=\"image0.jpg\" width=\"535\" height=\"397\" /></p>\n"},{"title":"Calendar Home tab","thumb":null,"image":null,"content":"<p>The Calendar Home tab on the Outlook 2016 Ribbon lets you choose how you prefer to view your appointments. You can choose among views for a day, a workweek, a week, or a month, as shown in the following image. You can also choose a schedule view for seeing several schedules at once.</p>\n<p><img loading=\"lazy\" src=\"https://www.dummies.com/wp-content/uploads/491177.image0.jpg\" alt=\"image0.jpg\" width=\"535\" height=\"397\" /></p>\n"},{"title":"Contacts Home tab","thumb":null,"image":null,"content":"<p>Outlook 2016&#8217;s Contacts is more than just a list of names and email addresses. You can take advantage of the Contacts Home tab on the Outlook 2016 Ribbon to create new contacts, to arrange the way you view the contacts you have, or to create email messages or mail merge documents. The following image shows the popular Business Card view.</p>\n<p><img loading=\"lazy\" src=\"https://www.dummies.com/wp-content/uploads/491179.image0.jpg\" alt=\"image0.jpg\" width=\"535\" height=\"397\" /></p>\n"},{"title":"Tasks Home tab","thumb":null,"image":null,"content":"<p>More than an email program, Outlook 2016 can also help you schedule and track personal and professional projects. On the Tasks Home tab on the Outlook 2016 Ribbon, you&#8217;ll see tools for managing your workload more quickly and effectively, as shown in the following image. You can choose from a variety of views that can help you keep track of pressing priorities.</p>\n<p><img loading=\"lazy\" src=\"https://www.dummies.com/wp-content/uploads/491181.image0.jpg\" alt=\"image0.jpg\" width=\"535\" height=\"397\" /></p>\n"},{"title":"Keyboard shortcuts","thumb":null,"image":null,"content":"<p>You can accomplish tasks a lot faster when you use Outlook, and you can be even faster if you use Outlook&#8217;s shortcut keys. The following tables offer several handy shortcuts to help you work more quickly and more efficiently with Outlook 2016.</p>\n<table>\n<caption>Outlook 2016 Shortcuts</caption>\n<tbody>\n<tr>\n<th>This Shortcut</th>\n<th>Creates One of These</th>\n</tr>\n<tr>\n<td>Ctrl+Shift+A</td>\n<td>Appointment</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+C</td>\n<td>Contact</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+L</td>\n<td>Distribution list</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+E</td>\n<td>Folder</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+M</td>\n<td>Email message</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+N</td>\n<td>Note</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+K</td>\n<td>Task</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+Q</td>\n<td>Meeting request</td>\n</tr>\n<tr>\n<th>This Shortcut</th>\n<th>Switches To</th>\n</tr>\n<tr>\n<td>Ctrl+1</td>\n<td>Mail</td>\n</tr>\n<tr>\n<td>Ctrl+2</td>\n<td>Calendar</td>\n</tr>\n<tr>\n<td>Ctrl+3</td>\n<td>Contacts</td>\n</tr>\n<tr>\n<td>Ctrl+4</td>\n<td>Tasks</td>\n</tr>\n<tr>\n<td>Ctrl+5</td>\n<td>Notes</td>\n</tr>\n<tr>\n<td>Ctrl+6</td>\n<td>Folder List</td>\n</tr>\n<tr>\n<td>Ctrl+7</td>\n<td>Shortcuts</td>\n</tr>\n<tr>\n<td>Ctrl+8</td>\n<td>Journal</td>\n</tr>\n<tr>\n<th>This Shortcut</th>\n<th>Helps You Do This</th>\n</tr>\n<tr>\n<td>Ctrl+S or Shift+F12</td>\n<td>Save</td>\n</tr>\n<tr>\n<td>Alt+S</td>\n<td>Save and close; Send</td>\n</tr>\n<tr>\n<td>F12</td>\n<td>Save As</td>\n</tr>\n<tr>\n<td>Ctrl+Z</td>\n<td>Undo</td>\n</tr>\n<tr>\n<td>Ctrl+D</td>\n<td>Delete</td>\n</tr>\n<tr>\n<td>Ctrl+P</td>\n<td>Print</td>\n</tr>\n<tr>\n<td>F7</td>\n<td>Check spelling</td>\n</tr>\n<tr>\n<td>Ctrl+Shift+V</td>\n<td>Move to folder</td>\n</tr>\n<tr>\n<td>Ins</td>\n<td>Mark complete</td>\n</tr>\n<tr>\n<td>Ctrl+F</td>\n<td>Forward</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-03-25T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":207455},{"headers":{"creationTime":"2021-12-20T20:40:21+00:00","modifiedTime":"2022-03-22T21:00:53+00:00","timestamp":"2022-06-22T19:37:30+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":"Microsoft Project For Dummies Cheat Sheet","strippedTitle":"microsoft project for dummies cheat sheet","slug":"microsoft-project-for-dummies-cheat-sheet","canonicalUrl":"","seo":{"metaDescription":"This Cheat Sheet is a quick reference to creating a schedule in Microsoft Project, as well as 12 Project keyboard shortcuts.","noIndex":0,"noFollow":0},"content":"Microsoft Project offers a tremendous wealth of functionality. It is very robust and can handle all shapes and sizes of projects, from waterfall methods to agile methods and even a little bit of both in the same project schedule.\r\n\r\nBecause it is so robust, 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":"Microsoft Project offers a tremendous wealth of functionality. It is very robust and can handle all shapes and sizes of projects, from waterfall methods to agile methods and even a little bit of both in the same project schedule.\r\n\r\nBecause it is so robust, 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":19071,"name":"Cynthia Snyder Dionisio","slug":"cynthia-snyder-dionisio","description":" <p><b>Cynthia Snyder Dionisio</b> is a project management consultant, trainer, and author. She also leads the team that creates the <i>PMBOK Guide,</i> the standard for project management that is published by the Project Management Institute. She has written more than a dozen books, including <i>A Project Manager&#39;s Book of Forms</i> and <i>A Project Manager&#39;s Book of Tools and Techniques.</i> \t ","_links":{"self":"https://dummies-api.dummies.com/v2/authors/19071"}}],"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":[],"fromCategory":[{"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"}},{"articleId":262053,"title":"How to Enter Project Information into Microsoft Project 2019","slug":"how-to-enter-project-information-into-microsoft-project-2019","categoryList":["technology","software","microsoft-products","project"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/262053"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":289792,"slug":"microsoft-project-for-dummies","isbn":"9781119858621","categoryList":["technology","software","microsoft-products","project"],"amazon":{"default":"https://www.amazon.com/gp/product/1119858623/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119858623/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/1119858623-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119858623/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119858623/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119858621-203x255.jpg","width":203,"height":255},"title":"Microsoft Project For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"<p><p><b><b data-author-id=\"19071\">Cynthia Snyder Dionisio</b></b> is a project management consultant, trainer, and author. She also leads the team that creates the <i>PMBOK Guide,</i> the standard for project management that is published by the Project Management Institute. She has written more than a dozen books, including <i>A Project Manager&#39;s Book of Forms</i> and <i>A Project Manager&#39;s Book of Tools and Techniques.</i></p>","authors":[{"authorId":19071,"name":"Cynthia Snyder Dionisio","slug":"cynthia-snyder-dionisio","description":" <p><b>Cynthia Snyder Dionisio</b> is a project management consultant, trainer, and author. She also leads the team that creates the <i>PMBOK Guide,</i> the standard for project management that is published by the Project Management Institute. She has written more than a dozen books, including <i>A Project Manager&#39;s Book of Forms</i> and <i>A Project Manager&#39;s Book of Tools and Techniques.</i> \t ","_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;9781119858621&quot;]}]\" id=\"du-slot-62b36f7a33c2e\"></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;9781119858621&quot;]}]\" id=\"du-slot-62b36f7a34372\"></div></div>"},"articleType":{"articleType":"Cheat Sheet","articleList":[{"articleId":0,"title":"","slug":null,"categoryList":[],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/"}}],"content":[{"title":"How to create your schedule with Project","thumb":null,"image":null,"content":"<p>Project makes it easy to set your project schedule. In these ten easy steps, you will be on your way to project management success:</p>\n<ol>\n<li>Enter the project information, such as the project name and start date.</li>\n<li>Develop a work breakdown structure (WBS) to organize your work.</li>\n<li>Enter the tasks needed to create the WBS deliverables.</li>\n<li>Link your tasks to show dependencies and create a network diagram.</li>\n<li>Enter the resources who will work on your project, their cost/rate, and the time they have available.</li>\n<li>Estimate the effort or duration for each task.</li>\n<li>Assign resources to each task.</li>\n<li>Resolve any resource conflicts.</li>\n<li>Balance schedule, cost, resource, and performance constraints to meet stakeholder expectations.</li>\n<li>Set a baseline for your schedule.</li>\n</ol>\n"},{"title":"12 Project shortcut keys","thumb":null,"image":null,"content":"<p>Project maximizes efficiency as you manage projects — but Project shortcuts can 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 width=\"537\">\n<tbody>\n<tr>\n<td width=\"225\"><strong>Keystroke</strong></td>\n<td><strong>Result</strong></td>\n</tr>\n<tr>\n<td width=\"225\">Ctrl+N</td>\n<td>Opens a new blank Project</td>\n</tr>\n<tr>\n<td width=\"225\">Alt+Home</td>\n<td>Moves to the beginning of the project</td>\n</tr>\n<tr>\n<td width=\"225\">Alt+End</td>\n<td>Moves the end of a project</td>\n</tr>\n<tr>\n<td width=\"225\">Alt+Right Arrow</td>\n<td>Moves the timeline to the right</td>\n</tr>\n<tr>\n<td width=\"225\">Alt+Left Arrow</td>\n<td>Moves the timeline to the left</td>\n</tr>\n<tr>\n<td width=\"225\">Shift+F2</td>\n<td>Opens the Task Information dialog box</td>\n</tr>\n<tr>\n<td width=\"225\">Ctrl+F</td>\n<td>Opens the Find dialog box</td>\n</tr>\n<tr>\n<td width=\"225\">Ctrl+Z</td>\n<td>Undoes the previous action</td>\n</tr>\n<tr>\n<td width=\"225\">Ctrl+P</td>\n<td>Displays the Print preview in the Backstage</td>\n</tr>\n<tr>\n<td width=\"225\">Ctrl+S</td>\n<td>Saves the file</td>\n</tr>\n<tr>\n<td width=\"225\">Alt+Shift+Hyphen (–)</td>\n<td>Hides subtasks</td>\n</tr>\n<tr>\n<td width=\"225\">Alt+Shift+Plus Sign (+)</td>\n<td>Shows subtasks</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":"2021-12-20T00:00:00+00:00","dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":289963}],"_links":{"self":{"self":"https://dummies-api.dummies.com/v2/categories/33642/categoryArticles?sortField=time&sortOrder=1&size=10&offset=0"},"next":{"self":"https://dummies-api.dummies.com/v2/categories/33642/categoryArticles?sortField=time&sortOrder=1&size=10&offset=10"},"last":{"self":"https://dummies-api.dummies.com/v2/categories/33642/categoryArticles?sortField=time&sortOrder=1&size=10&offset=2390"}}},"objectTitle":"","status":"success","pageType":"article-category","objectId":"33642","page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{"categoriesFilter":[{"itemId":0,"itemName":"All Categories","count":2400},{"itemId":33643,"itemName":"Access","count":63},{"itemId":33644,"itemName":"Excel","count":1077},{"itemId":33652,"itemName":"General Microsoft","count":391},{"itemId":33645,"itemName":"OneDrive","count":3},{"itemId":33646,"itemName":"Outlook","count":90},{"itemId":33647,"itemName":"PowerPoint","count":193},{"itemId":33648,"itemName":"Project","count":51},{"itemId":33649,"itemName":"SharePoint","count":166},{"itemId":33650,"itemName":"Teams","count":12},{"itemId":33651,"itemName":"Word","count":354}],"articleTypeFilter":[{"articleType":"All Types","count":2400},{"articleType":"Articles","count":1905},{"articleType":"Cheat Sheet","count":59},{"articleType":"Step by Step","count":409},{"articleType":"Videos","count":27}]},"filterDataLoadedStatus":"success","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2022-06-23T12:59:04+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"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":287569,"title":"For the Hopeless Romantic","hasSubCategories":false,"url":"/collection/for-the-hopeless-romantic-287569"},{"collectionId":287567,"title":"For the Unabashed Hippie","hasSubCategories":false,"url":"/collection/for-the-unabashed-hippie-287567"},{"collectionId":292186,"title":"Just DIY It","hasSubCategories":false,"url":"/collection/just-diy-it-292186"},{"collectionId":290164,"title":"Make a Commitment to Better Yourself","hasSubCategories":false,"url":"/collection/make-a-commitment-to-better-yourself-290164"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"ArticleCategory","path":"/category/articles/microsoft-products-33642/","hash":"","query":{},"params":{"category":"microsoft-products-33642"},"fullPath":"/category/articles/microsoft-products-33642/","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

Article Categories

Book Categories

Collections

Explore all collections
BYOB (Be Your Own Boss)
Be a Rad Dad
For Those Seeking Peace of Mind
For the Aspiring Aficionado
For the Budding Cannabis Enthusiast
For the Exam-Season Crammer
For the Hopeless Romantic
For the Unabashed Hippie
Just DIY It
Make a Commitment to Better Yourself
  • Home
  • Technology Articles
  • Software Articles
  • Microsoft Products Articles

Microsoft Products Articles

Hundreds of how-tos and tips for Word, Excel, Access, SharePoint, Project, and all your other Microsoft favorites.

Browse By Category

Access

Excel

OneDrive

Outlook

PowerPoint

Project

SharePoint

Teams

Word

General Microsoft

Previous slideNext slide

Access

Excel

OneDrive

Outlook

PowerPoint

Project

SharePoint

Teams

Word

General Microsoft

Articles From Microsoft Products

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

Filter Results

2,400 results
2,400 results
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
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
Word Word 2016 For Dummies Cheat Sheet

Cheat Sheet / Updated 03-25-2022

Word is one of the most used computer programs on the planet. Helping you to compose text is one of the things that computers do well, but that doesn’t make the text-writing chore easier or imply that using Word is simple enough that you don’t need help. So enjoy this Cheat Sheet.

View Cheat Sheet
General Microsoft Office 2019 All-in-One For Dummies Cheat Sheet

Cheat Sheet / Updated 03-25-2022

Master the commands in one Office 2019 program and you are well on your way to mastering the other programs. Following is key information you can take to any Office 2019 program you are working in.

View Cheat Sheet
Outlook Outlook 2016 For Dummies Cheat Sheet

Cheat Sheet / Updated 03-25-2022

Sending email has never been easier than it is in Outlook 2016. You'll notice the familiar Ribbon interface, and you'll still find all the Outlook features you've come to love — plus some new ones. Use this handy Cheat Sheet to orient yourself with Outlook's new look and feel. There's also a helpful table of Outlook shortcut keys.

View Cheat Sheet
Project Microsoft Project For Dummies Cheat Sheet

Cheat Sheet / Updated 03-22-2022

Microsoft Project offers a tremendous wealth of functionality. It is very robust and can handle all shapes and sizes of projects, from waterfall methods to agile methods and even a little bit of both in the same project schedule. Because it is so robust, 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

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