If you want, your grouped detail rows can have a corresponding summary row—a subtotal. To create these, do one of the following: Insert summary rows by using the Subtotal command . Use the Subtotal command, which inserts the SUBTOTAL function immediately below or above each group of detail rows and automatically creates the outline for you. For more information about using the Subtotal ...

The customizable Quick Access Toolbar contains a set of commands that are independent of the currently displayed tab on the ribbon. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.

Add a watermark, such as draft, confidential, or one of your own design like a company logo, to a worksheet in Exce

You weren't able to find your username. If the username lookup wasn't successful, try looking for your Microsoft account username within other products or services that you know are associated with that account.

Learn how to tell if your Office software is genuine. To help determine if your Microsoft software is genuine, go to our How to Tell site for more information. Here you'll learn about authentic packaging, including what to look for with product key labels, and Certificate of Authenticity (COA), how to report counterfeit software, and find out what your shopping and licensing options are.

Important: Office 2007 is no longer supported. Learn how to upgrade to a newer version.If you still need to install this version, you'll need an Office 2007 installation disc and a product key for the version you're trying to install.

Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.

Change audio sources. When you join a Teams meeting, you can choose your source of audio from the meeting pre-join screen. Available audio settings vary depending on the source you choose.

Whether you’re starting from a Microsoft template or updating one of your own, Word's built-in tools help you update templates to suit your needs. To update your template, open the file, make the changes you want, and then save the template. In Microsoft Word, you can create a template by saving a document as a .dotx file, .dot file, or a .dotm fie (a .dotm file type allows you to enable ...

Problem. Resolution. You have a OneDrive file open. Close the file once you finish editing. You're syncing a lot of files. No action required. OneDrive will upload all files, but this may take some time if your internet speed is slow.