File formats that are supported in Excel - Microsoft Support
网页To take advantage of the new features of Excel 2010, you can save the workbook to an Excel 2010 file format. However, you also have the option to continue to work in Compatibility Mode, which retains the original file format for backward compatibility.
How to correct a #VALUE! error in the CONCATENATE function
网页In the following example, we want to concatenate D2, E2, and F2, where E2 has a #VALUE! error. The error in E2 causes the function to display the #VALUE! error. In order for it to work successfully, you will need to replace the error with a value other than the error.
Open files from the File menu - Microsoft Support
网页To access files from your Microsoft 365 Groups or SharePoint Online document libraries click the Sites - Your Company link. You'll get a list of your frequently Groups and Sites to select from. Pick the one you want and browse to the file you want to open.
Excel specifications and limits - Microsoft Support
网页In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.
Create a PivotTable with an external data source - Microsoft …
网页Click Insert > PivotTable. In the Create PivotTable dialog box, click From External Data Source. Click Choose Connection. On the Connections tab, in the Show box, keep All Connections selected, or pick the connection category that has the data source you want to …
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.
Count the number of rows or columns in Excel - Microsoft Support
网页Count the number of rows, columns, or cells in Excel by using the status bar at the bottom of the Excel screen. You can also customize the status bar.
Cancel printing - Microsoft Support
网页You’ve started a print job, but you want to cancel it. You can attempt to stop printing either directly from Excel or from Windows. However, you can cancel printing from your computer only if the job hasn’t been entirely sent to the printer.
Create a combination chart - Microsoft Support
网页In the chart, select a data series. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. and then click the 2-D chart that you want to add to the existing chart. To combine charts, you should have more than one data series.
Handling data source errors (Power Query) - Microsoft Support
网页Changes to the flow of data all along the way can cause problems that end up as errors when you attempt to refresh data. Some errors may be easy to fix, some may be transient, and some may be hard to diagnose. What follows is a set of strategies you can take to handle errors that come your way.
NORMINV function - Microsoft Support
网页Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation. Note: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage.