Show or hide the ribbon in Office - Microsoft Support
Show the ribbon when hidden, and set options to shows tabs and commands, just tabs, or automatically hide the ribbon for the maximum document space.
Customize the Quick Access Toolbar - Microsoft Support
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. Notes: You cannot increase …
How to find and enable missing Copilot button in Microsoft 365 …
Open any Microsoft 365 application (such as Word, Excel, or PowerPoint). Select File > Account. There are two settings here that can cause Copilot to not appear in your Microsoft 365 apps. …
Display or hide formulas - Microsoft Support
You can control the display of formulas in the following ways: Note: This procedure also prevents the cells that contain the formula from being edited. Select the range of cells whose formulas …
Split text into different columns with functions - Microsoft Support
This article shows you how to extract various components from a variety of name formats using these handy functions. You can also split text into different columns with the Convert Text to …
Show different calculations in PivotTable value fields
Instead of writing your own formulas in calculated fields, you can use Show Values As to quickly present values in different ways. It also provides several new calculation options, such as % of …
How to correct a #N/A error in the VLOOKUP function
Solution: You can try to fix this by adjusting your VLOOKUP to reference the correct column. If that’s not possible, then try moving your columns.
Filter data (Power Query) - Microsoft Support
In Power Query, you can include or exclude rows based on a column value. A filtered column contains a small filter icon ( ) in the column header. If you want to remove one or more column …
Apply sensitivity labels to your files and email - Microsoft Support
You can apply sensitivity labels to your files and emails to keep them compliant with your organization's information protection policies.
Keyboard shortcuts in Microsoft 365
Many users find that using Microsoft 365 apps with keyboard shortcuts on an external keyboard helps them work more efficiently. For users with mobility or vision disabilities, keyboard …
Hide or Unhide worksheets - Microsoft Support
You can hide any worksheet to remove it from view. The data in hidden worksheets is not visible, but it can still be referenced from other worksheets and workbooks, and you can easily unhide …