Lock or unlock specific areas of a protected worksheet
网页Follow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect …
Split panes to lock rows or columns in separate worksheet areas
网页By splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. To split this worksheet as shown above, you select below the row where you want the split – selecting row 13 splits the worksheet below row 12. Then, click View > Window > Split.
Protect a worksheet - Microsoft Support
网页The following sections describe how to protect and unprotect a worksheet in Excel for Windows. : If you don’t want other users to see your formulas, you can hide them from being seen in cells or the Formula bar.
Insert, move, or delete page breaks in a worksheet
网页To insert a vertical page break, select the row below where you want to insert the page break. To insert a horizontal page break, select the column to the right of where you want …
Outline (group) data in a worksheet - Microsoft Support
网页If you have a list of data you want to group and summarize, you can create an outline of up to eight levels. Each inner level, represented by a higher number in the outline symbols, displays detail data for the preceding outer level, represented by a lower number in the outline symbols.
Set or clear a print area on a worksheet - Microsoft Support
网页If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet.
Use the Field List to arrange fields in a PivotTable
网页Rearrange fields in your PivotTable (pivot table) by using the Field List, and show the Field List again when it disappears.
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.
Group or ungroup data in a PivotTable - Microsoft Support
网页Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list date and time fields in the PivotTable into quarters and months. Windows Mac. Group data. Group selected items. Group by date and time. Name a group. Ungroup grouped data. Need more help?
Insert subtotals in a list of data in a worksheet - Microsoft Support
网页Insert subtotals in a list of data in a worksheet. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013. You can automatically calculate subtotals and grand totals in a list for a column by using the Subtotal command.
Expand, collapse, or show details in a PivotTable or PivotChart
网页In a PivotTable or PivotChart, you can expand or collapse to any level of data detail, and even for all levels of detail in one operation. On Windows and the Mac, you can also expand or collapse to a level of detail beyond the next level.
跳至内容