1.右侧文件，点击菜单中的选项。2.打开EXCEL选项对话框，选择“自定义功能区”。3.从右侧自定义功能区选项卡中，可以看到下方树状，有个“开发工具”复选框可勾选。勾选后点击确定，就可以看到开发工具选项卡了。选中原数据区域，CTRL+T把数据转换为Table, Table tools情境菜单就出来了。
1. How do I show the Tools menu in Excel? In newer versions of Microsoft Excel, the traditional "Tools" menu is no longer available. Instead, you can find the tools and options you need in the "Ribbon" interface at the top of the Excel window. Look for different tabs like "Home," ...
Step 1.To start the process, navigate the worksheet and select the data from which you want to create a pivot table. Then, you need to click on the“Insert”tab and choose the“Pivot Table”option from the newly appeared tools.
This tutorial demonstrates how to use table tools in Excel. Table Design Tab The Ribbon in Excel is dynamic. This means that when you insert a table, chart, or pivot table into your worksheet, a new tab appears on your Ribbon which relates to the object you inserted. To get to the ...
How to Use PivotTable Analyze Tab in Excel Selecting a cell inside a pivot table creates two additional tabs in the ribbon: PivotTable Analyze and Design. You can access different tools from the PivotTable Analyze tab. With the PivotTable Analyze tab, we can perform the following tasks. Chan...
A pivot table allows you to organize, sort, manage and analyze large data sets in a dynamic way. Pivot tables are one of Excel’s most powerful data analysis tools, used extensively by financial analysts around the world. In a pivot table, Excel essentially runs a database behind the scene...
In earlier versions of Excel, the data is displayed without a table unless the Header Row check box is selected (Table Tools, Design tab, Table Style Options group). What it means In Excel 97-2003, a table cannot be displayed without a header row. What to do In the Compatibility...
6. First, select a cell inside the table. Next, on the Table Design tab, in the Tools group, click Convert to Range. Result: a nicely formatted range of cells. To convert this table back to a normal range of cells (without table formatting), execute the following steps. ...
If you are involved with Excel, you know it is easy to customize. We can dress it any way we want to. Click on any cell in the Table, and an additional button, “Table Tools Design” will appear on the ribbon. This is optional and can be seen only when working with tables. ...
Go toPivot Table Tools>Design Click on the arrow to expand the list ofPivotTable Stylesand select one On top of that, we are going to format the data in the Pivot Table. After all, it should be clear that the values we’re summing up are $ amounts and not just plain numbers. Here...