Collaborate on Excel workbooks at the same time with co-authoring
网页You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in …
Create a named range from selected cells in a worksheet
网页You can quickly create a named range by using a selection of cells in the worksheet. Note: Named ranges that are created from selecting cells have a workbook-level scope. Select the range you want to name, including the row or column labels. Click Formulas > …
Use the Name Manager in Excel - Microsoft Support
网页Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope.
Unhide the first column or row in a worksheet - Microsoft Support
网页To select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. On the Home tab, in the Editing group, click Find & Select, and then click Go To. In …
Analyze Data in Excel - Microsoft Support
网页Analyze Data in Excel empowers you to understand your data through natural language queries that allow you to ask questions about your data without having to write complicated formulas. In addition, Analyze Data provides high-level visual summaries, trends, and …
Insert the current Excel file name, path, or worksheet in a cell
网页Insert the current Excel file name, path, or worksheet in a cell. Let's say you want to add information to a spreadsheet report that confirms the location of a workbook and worksheet so you can quickly track and identify it. There are several ways you can do this task.
Why am I seeing the Name Conflict dialog box in Excel?
网页If you are seeing the Name Conflict dialog box in Excel, that's because you are trying to copy one or more worksheets to a workbook that has similar named ranges. Suppose the worksheet that you're trying to copy and the destination workbook where you want to copy the worksheet into both have a named range called InterestRates.
Create a relationship between tables in Excel - Microsoft Support
网页Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
Distribute the contents of a cell into adjacent columns
网页You can divide the contents of a cell and distribute the constituent parts into multiple adjacent cells. For example, if your worksheet contains a column Full Name, you can split that column into two columns—a First Name column and Last Name column.
Rename an Excel table - Microsoft Support
网页Go to Table Tools > Design > Properties > Table Name. On a Mac, go to the Table tab > Table Name. Highlight the table name and enter a new name. Tips: All of your tables will be shown in the Address bar, which appears to the left of the Formula bar.
Select worksheets - Microsoft Support
网页By clicking the sheet tabs at the bottom of the Excel window, you can quickly select one or more sheets. To enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. You can also format or print a …