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 to insert the page break. On the Page Layout tab, in the Page Setup group, click Breaks. Click Insert Page Break.
Insert page numbers on worksheets - Microsoft Support
You can insert page numbers on multiple worksheets in your workbook by using the Page Setup dialog box. For example, if your workbook contains two worksheets that are both two pages long, the first worksheet will contain two pages numbered 1 and 2. The second worksheet will also contain two pages numbered 1 and 2.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Customize the list of recently used files in Office apps
Click the File tab. Click Options. Click Advanced. Under Display, in the Show this number of Recent Documents list, click the number of files that you want to display. Tip: To not see any files in the recently used files list, set the Show this number of Recent Documents list to zero.
Filter data in a range or table - Microsoft Support
Filter a range of data. Select any cell within the range. Select Data > Filter. Select the column header arrow . Select Text Filters or Number Filters, and then select a comparison, like Between. Enter the filter criteria and select OK.
Filter data in a range or table - Microsoft Support
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Print rows with column headers on top of every page
On the Sheet tab, under Print titles, do one or both of the following: In the Rows to repeat at top box, type the reference of the rows that contain the column labels. In the Columns to repeat at left box, type the reference of the columns that contain the row labels.
Use COUNTA to count cells that aren't blank - Microsoft Support
Count unique values among duplicates. View an example of how to use the COUNTA function to count cells that are not empty in a range of data.
Switch between relative, absolute, and mixed references
Press F4 to switch between the reference types. The table below summarizes how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. For a formula being copied: If the reference is: It changes to: $A$1 (absolute column and absolute row) $A$1 (the reference is absolute)
Manage workbook links - Microsoft Support
In the Excel web app, you can manage workbook links to ensure that your data is up to date and accurate. This article explains how to manage workbook links, including how to refresh and update them, how to fix broken links, and how to work with the new security warning feature.
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)