Assign a macro to a Form or a Control button - Microsoft Support
网页Add or edit a macro for a control on a worksheet. Enable or disable macros in Office files. Enable or disable ActiveX settings in Office files. Create a Form button or a Command button and assign a macro that performs an action when a user clicks the button.
Undo, redo, or repeat an action - Microsoft Support
网页Redo an action. To redo something you've undone, press Ctrl+Y or F4. (If F4 doesn't seem to work, you may need to press the F-Lock key or Fn Key, then F4) on your keyboard, or select Redo on the Quick Access toolbar. (The Redo button only appears after you've undone an action.)
Find and remove duplicates - Microsoft Support
网页How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
How to correct a #REF! error - Microsoft Support
网页When you use explicit cell references like this (where you reference each cell individually, separated by a comma) and delete a referenced row or column, Excel can’t resolve it, so it returns the #REF! error.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
网页Use the table_array argument in a VLOOKUP function. Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.
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)
Quick start: Create a macro - Microsoft Support
网页You want to format the names of the customers with overdue accounts in red, and also apply bold formatting. You can create and then run a macro that quickly applies these formatting changes to the cells you select.
Find or replace text and numbers on a worksheet
网页Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
Consolidate data in multiple worksheets - Microsoft Support
网页Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016. To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the …
Use Goal Seek to find the result you want by adjusting an input …
网页On the Home tab, in the Number group, click Percentage. Click Increase Decimal or Decrease Decimal to set the number of decimal places. If you know the result you want from a formula but aren't sure which input is needed to …
Insert, move, or delete page breaks in a worksheet
网页Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert. To print a worksheet with the exact number of pages that you want, you can adjust the page breaks in the worksheet before you print it. Tips: