Configure headers and footers for different sections of a document
Click Link to Previous to turn it off and unlink the header or footer from the previous section.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
New Office theme - Microsoft Support
Default Office theme colors. The color palette of the Office theme prioritizes the creation of modern and accessible content. The previous Office theme has been renamed Office Theme 2013–2022 and can still be accessed in the theme galleries of each Office application.. Change a theme and make it the default in Word or Excel
View and delete your browsing history in Internet Explorer
Select the History tab, and choose how you want to view your history by selecting a filter from the menu.To delete specific sites, right-click a site from any of these lists and then select Delete.Or, return to a page by selecting any site in the list.
Obtain a digital certificate and create a digital signature
This article explains how you can get or create a digital signature for use in Office documents. To learn more about how to use them in Office documents, see Add or remove a digital signature in Office files.. What is a digital signature?
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Word 2021, Word 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Office 2016, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Office 2013
FILTER function - Microsoft Support
An array can be thought of as a row of values, a column of values, or a combination of rows and columns of values. In the example above, the source array for our FILTER formula is range A5:D20. The FILTER function will return an array, which will spill if it's the final result of a formula.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
使用 vlookup、hlookup 和其他函数(如 index 和 match)根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup,然后链接到更多内容。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Insert data from picture - Microsoft Support
Take a picture of some printed data Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies.Just take a picture of each one, transfer the pictures to your computer (OneDrive is great for this). Then, click Data > From Picture > Picture From File and follow the on-screen instructions to convert picture to data.
Applies To: Excel for Microsoft 365
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
How to change your Xbox gamertag | Xbox Support
Press the Xbox button to open the guide, and then go to Profile & system.; Select your Xbox profile (or select Choose a profile and sign in to your account).; Select My profile > Customize profile, and then select your current gamertag.; Under Choose your new gamertag, enter the gamertag that you want in the available text box, and then select Check availability.
Customize the Quick Access Toolbar - Microsoft Support
Notes: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands.To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form:
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, InfoPath 2013, SharePoint Workspace 2010