Freeze panes to lock rows and columns - Microsoft Support
网页How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Using IF with AND, OR, and NOT functions in Excel
网页In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Excel not responding, hangs, freezes or stops working
网页This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook. These types of problems may occur for one or more of the reasons listed below.
Overview of formulas in Excel - Microsoft Support
网页If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour. With real-world examples and helpful visuals, you’ll be able to Sum, Count, Average, and Vlookup like a pro.
Using Flash Fill in Excel - Microsoft Support
网页Have Excel automatically fill your data when it detects a pattern. For example, the months of the year, the days in a month, or a sequence of numbers. You can also parse data, like splitting first and last names out of a column, or concatenate data, like joining first and last names from two columns.
INDIRECT function - Microsoft Support
网页Description. Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. Syntax. INDIRECT (ref_text, [a1]) The INDIRECT function syntax has the following arguments:
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.
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.
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.
UNIQUE function - Microsoft Support
网页The UNIQUE function returns a list of unique values in a list or range. Return unique values from a list of values. Return unique names from a list of names. Syntax. An array can be thought of as a row or column of values, or a combination of rows and columns of values.
Insert or delete rows and columns - Microsoft Support
网页Overview of formulas in Excel. You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.