How to correct a #REF! error - Microsoft Support
WEBIn the following example, =VLOOKUP(A8,A2:D5,5,FALSE) will return a #REF! error because it’s looking for a value to return from column 5, but the reference range is A:D, which is only 4 columns. Solution. Adjust the range to be larger or reduce the column lookup value to match the reference range.
Create custom functions in Excel - Microsoft Support
WEBAlthough Excel includes a multitude of built-in worksheet functions, chances are it doesn’t have a function for every type of calculation you perform. The designers of Excel couldn’t possibly anticipate every user's calculation needs. Instead, Excel provides you with the ability to create custom functions, which are explained in this article.
Repair a corrupted workbook - Microsoft Support
WEBWhen Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook: Click File > Open. Click the location and folder that contains the corrupted workbook.
Insert page numbers on worksheets - Microsoft Support
WEBSet a different number for the starting page. To number all of the worksheet pages in a workbook sequentially, first add page numbers to all worksheets in a workbook, and then use the following procedure to begin the page number for each worksheet with the appropriate number.
Add or remove items from a drop-down list - Microsoft Support
WEBIf you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type …
Overview of Excel tables - Microsoft Support
WEBTo quickly create a table in Excel, do the following: Select the cell or the range in the data. Select Home > Format as Table. Pick a table style. In the Format as Table dialog box, select the checkbox next to My table as headers if you want the first row of the range to be the header row, and then click OK.
Getting started with Quick access - Microsoft Support
WEBQuick access makes it simple to find your frequently used storage locations, including recently used shared libraries, channels, and folders. When you select Open, Quick access will appear in the left nav column, listing the shared document libraries that you use and a Show more... option.
FILTER function - Microsoft Support
WEBThe FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER (A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are …
Create a drop-down list - Microsoft Support
WEBLock or unlock specific areas of a protected worksheet. You can insert a drop-down list of valid entries (also called a drop-down menu or drop-down box) in Excel to make data entry easier, or to limit entries to certain items that you define.
RANDBETWEEN function - Microsoft Support
WEBThis article describes the formula syntax and usage of the RANDBETWEEN function in Microsoft Excel. Description. Returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated. Syntax. RANDBETWEEN (bottom, top)
Lock or unlock specific areas of a protected worksheet
WEBFollow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected. If prompted, enter the …