End All | search
Click here to view End All news from 60+ newspapers.
Bookmark or Share- Using wildcard characters in searches - Microsoft SupportUse wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
- Print rows with column headers on top of every pageIf a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets. Select the worksheet that you want to print.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere'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.
- Hide or show rows or columns - Microsoft SupportHow to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.
- Remove or turn off hyperlinks - Microsoft SupportRemove all hyperlinks at the same time. If you're using Word, Outlook, or Excel, you can remove all hyperlinks in a file by using a keyboard shortcut. In Word and Outlook: Press Ctrl+A to select all text.
More
