Activate Office - Microsoft Support
网页Select your version of Microsoft 365 below to learn how to activate Microsoft 365. Activate Microsoft 365 or a non-subscription version of Office. Activate Office that's pre-installed on a new Windows device. Activate an Office purchase or offer that's included on a new Windows device.
Command-line switches for Microsoft Office products
网页This article describes how to do both. It also includes a table that lists all of the switches and parameters that are available in the desktop Office apps. About commands, switches, and parameters. Startup command names and locations. Use a switch once by adding it to the Run command. Make a switch available for reuse by creating a shortcut.
How do I turn on AutoSave? - Microsoft Support
网页AutoSave is available when a file is saved to Microsoft OneDrive or SharePoint in Microsoft 365, but you need to save or open the file from within Excel, PowerPoint or …
Keyboard shortcuts in Excel - Microsoft Support
网页A plus sign (+) in a shortcut means that you need to press multiple keys at the same time. A comma sign (,) in a shortcut means that you need to press multiple keys in order. This article describes the keyboard shortcuts, function keys, and some other common shortcut keys in Excel for Windows.
Import data from the web - Microsoft Support
网页Select Data > Get & Transform > From Web. Press CTRL+V to paste the URL into the text box, and then select OK. In the Navigator pane, under Display Options, select the Results table. Power Query will preview it for you in the Table View pane on the right. Select Load.
Video: Add and delete table rows and columns - Microsoft Support
网页Try it! When your table needs more data, add rows and columns, or remove them to get rid of empty cells. Add a row. Select a cell. Select the Table Tools Layout tab > Insert Above …
How can I merge two or more tables? - Microsoft Support
网页You can merge (combine) rows from one table into another simply by pasting the data in the first empty cells below the target table. The table will increase in size to include the new rows. If the rows in both tables match up, you can merge the columns of one table with another—by pasting them in the first empty cells to the right of the table.
Excel Functions Translator - Microsoft Support
网页Supports all of Excel's localized languages and functions, with 80 languages, and 800 functions. Provides an efficient way to search for any part of a function's name in both languages selected. Displays a scrollable, and categorized list of English functions, and their corresponding localized functions.
Format an Excel table - Microsoft Support
网页Convert an Excel table to a range. Filter data in a range or table. Format an Excel table by applying different table styles or colors.
Create relationships in Diagram View in Power Pivot
网页The Power Pivot add-in includes a Diagram View that lets you work with a data model in a visual layout. In this view, you can drag and drop fields between tables to create a relationship. You can also view additional, predefined relationships and choose which one is …
Sort data in a range or table - Microsoft Support
网页To find the top or bottom values in a range of cells or table, such as the top 10 grades or the bottom 5 sales amounts, use AutoFilter or conditional formatting. Check out the video to see how it's done. Windows Web. Sort text. Sort numbers. Sort dates or times. Sort by more than one column or row. Sort by cell color, font color, or icon.
跳至内容