Adding commands to the Quick Access Toolbar

Suppose you'd like to add a couple more commands to the Quick Access toolbar. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.

Adding commands to the Quick Access Toolbar

Suppose you'd like to add a couple more commands to the Quick Access toolbar. Also, say you're a big fan of AutoText, which lets you assign long strings of text to a couple keystrokes. You can add the AutoText button to the Quick Access Toolbar, so you can quickly create and use AutoText to collect frequently used commands.

How to format Footnotes and Endnotes

Word inserts insert different types of footnotes and endnotes in the Word document using the Footnotes and Endnotes predefined styles for footnotes and endnotes. You can modify the following predefined styles for footnotes and endnotes according to the specific requirements:

Easily organize shapes in Excel

Every time you add, move, or resize shapes, it's not easy to align them by default. Excel proposes features for arranging and aligning shapes:

Open and edit files in Protected View

Microsoft Word, Excel, and PowerPoint open the file in the Protected View mode when you open a file from an online location, such as a cloud storage location, email message, or another insecure location. In the Protected View mode, most editing functions are disabled. Microsoft apps do this to prevent malicious code from accessing your computer.

Microsoft Office Themes in Excel

The appearance of any Microsoft document, such as an Excel workbook, is determined by a Theme (also known as document Theme) — a combination of colors, fonts, and effects. Themes help to create creative and professional-looking documents without a professional designer.

AutoFit feature

By default, if you type more text than fits into the placeholder, PowerPoint applies an AutoFit (if not disabled). PowerPoint uses different AutoFit algorithms for different objects:

How to create automatic numbers and captions for figures: images, pictures, and other illustrations

Microsoft Word offers functionality to create automatically updated numbers for figures, tables, and equations. You can define descriptions (captions) for figures in your document and reference them from the document content using the Captions feature. The numbering and links can be automatically updated on adding, moving, or deleting a figure.

Auto preview attachments in Outlook

The Auto Preview feature quickly previews email attachments in the Reading pane or the open message window. However, it also exposes users to security risks like malicious Word documents, Excel workbooks, PowerPoint presentations, Visio diagrams, PDF files, and images. If you need complete control over your email messages and want to prioritize security, turn off the Auto Preview feature in Outlook.

Logarithmic trend equation and forecast

If the growth or decay of the data first rapidly accelerates and then slows down over time, the best type of trend line is logarithmic. See more about the different types of trendlines you can create in Excel: