- 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
- Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, select the table cells you want to reference instead of typing their cell reference in the formula Let's use the following example data to enter a formula that automatically uses structured references to calculate the amount of a sales commission
- Add citations in a Word document - Microsoft Support
In Word, you can easily add citations when writing a document where you need to cite your sources, such as a research paper Citations can be added in various formats, including APA, Chicago-style, GOST, IEEE, ISO 690, and MLA Afterwards, you can create a bibliography of the sources you used to write your paper
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
This argument can be a cell reference, or a fixed value such as "smith" or 21,000 The second argument is the range of cells, C2-:E7, in which to search for the value you want to find
- Create or change a cell reference - Microsoft Support
If you are creating a reference in a single cell, press Enter If you are creating a reference in an array formula (such A1:G4), press Ctrl+Shift+Enter The reference can be a single cell or a range of cells, and the array formula can be one that calculates single or multiple results
- How to correct a #VALUE! error - Microsoft Support
#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed Or, there's something wrong with the cells you are referencing " The error is very general, and it can be hard to find the exact cause of it The information on this page shows common problems and solutions for the error
- Create a bibliography, citations, and references - Microsoft Support
Go to References > Insert Citation, and choose the source you are citing To add details, like page numbers if you're citing a book, select Citation Options, and then Edit Citation With cited sources in your document, you're ready to create a bibliography Put your cursor where you want the bibliography
- Use cell references in a formula - Microsoft Support
Do one of the following, select the cell that contains the value you want or type its cell reference You can refer to a single cell, a range of cells, a location in another worksheet, or a location in another workbook
|