Repair a corrupted workbook - Microsoft Support
Use a macro to extract data from a corrupted workbook If a chart is linked to the corrupted workbook, try using a macro to extract the source data of the chart.. Copy the following macro code and paste it in a module sheet: Sub GetChartValues() Dim NumberOfRows As Integer
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Insert a table of contents - Microsoft Support
Note: If you use a Manual Table of Contents style, Word won't use your headings to create a table of contents and won't be able to update it automatically. Instead, Word will use placeholder text to create the look of a table of contents so you can manually type each entry into the table of contents.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
在 Windows 中配對藍牙裝置 - Microsoft 支援服務
在快速設定中: 若要尋找藍牙的快速設定,請選取工作列右側的時間和日期旁 的 [網路]、[音效] 或 [電池] 圖示。 選取[藍牙] 將其開啟。如果在未連接任何藍牙裝置的情況下開啟此功能,它可能會顯示為[未連線] 。 如果您在快速設定中沒有看到藍牙 ,您可能需要新增它。
Sign out of Office - Microsoft Support
Note: If you're using Microsoft 365, you should stay signed in so that Office stays activated.If you sign out, Office will prompt you to sign back in. To learn more, see What happens when you sign out of Office.
Applies To: Microsoft 365 for home
Control the formatting when you paste text - Microsoft Support
Merge Formatting (M) This option discards most formatting that was applied directly to the copied text, but it retains formatting that is considered emphasis, such as bold and italic, when it is applied to only a portion of the selection.The text takes on the style characteristics of the paragraph where it is pasted. The text also takes on any direct formatting or character style properties of ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
How to recover a hacked or compromised Microsoft account
Step 1: Clear your PC of viruses or malware before you change your password. If you have a good antivirus program installed, make sure it's up to date and then do a full scan of your system.
Customize the navigation on your SharePoint site
The following communication site shows a footer that's been added. Labels and links appear on the right side of the footer. When you add labels and links to your footer, they follow the Edit link and appear to the right.. On your site, select Edit on the right side of the footer (Edit appears on your footer after you've turned the footer control on).
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint in Microsoft 365, Microsoft 365 admin
Create a flow chart with SmartArt - Microsoft Support
Change the colors of your flow chart. To quickly add a designer-quality look and polish to your SmartArt graphic, you can change the colors or apply a SmartArt Style to your flow chart.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Excel 2019, Word 2019, PowerPoint 2019, Excel 2016, Word 2016, PowerPoint 2016
How to use two-step verification with your Microsoft account
Important: If you turn on two-step verification, you will always need two forms of identification.This means that if you forget your password, you need two contact methods. Or if you lose your contact method, your password alone won't get you back into your account—and it can take you 30 days to regain access.
Change TCP/IP settings - Microsoft Support
TCP/IP defines how your PC communicates with other PCs. To make it easier to manage TCP/IP settings, we recommend using automated Dynamic Host Configuration Protocol (DHCP).