TEXT function - Microsoft Support
Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.
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 2019 for Mac, Excel 2016
Open your entire favorites bar in Microsoft Edge
Choose Open all, or Open all in new window, or Open all in new InPrivate window.
Activate Office - Microsoft Support
Learn how to activate Office pre-installed on new Windows 10 PCs or with a new product key.
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, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Microsoft 365 admin, Project for Office 365
Set apps to run automatically when you start your device
Note: If you see the icon next to the On/Off toggle for an app, you can select it to see the registry location that contains the path for the app. Apps installed through Microsoft Store (.MSIX apps) don’t have these icons. If you select the icon for these apps, File Explorer opens and highlights the executable file.
How to adjust power and sleep settings in Windows
To adjust power and sleep settings in Windows 10, go to Start , and select Settings > System > Power & sleep.. Under Screen, select how long you want your device to wait before turning the screen off when you're not using your device.
使用 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
Upgrade Windows Home to Windows Pro - Microsoft Support
Important: The following steps apply only to devices currently running an activated copy of Windows 11 Home.If you’re not activated, we recommend you activate Windows 11 Home first. For more info, see Activate Windows.
Change your browser home page - Microsoft Support
On the General tab, under Home page, enter the URL of the site you want to set as a homepage.You can add more than one URL. Or, to add the site you're currently viewing, select Use current.If you add more than one URL, put each URL on its own line.
Use Snipping Tool to capture screenshots - Microsoft Support
To capture a video snip, open Snipping Tool, select the Record button, then select New recording, or press Windows logo key + Shift + R.Select the area of the screen you wish to record, then select Start.When you are done, select Stop.At this point you can save the recording as-is or select Edit in Clipchamp to work with it in the Clipchamp video editor.
Change the size of your desktop icons in Windows
To resize desktop icons, right-click (or press and hold) the desktop, point to View, then select Large icons, Medium icons, or Small icons.