Let's say that you have a workbook that contains many worksheets, and on each worksheet is a cell that displays summary information about the other cells on that worksheet. You can use this command to:Įasily display important information in a more prominent position. The sum of the values of the cell ranges named Week1 and Week 2 as an array formula.Īlternatively, you can copy and paste a cell reference and then use the Link Cells command to create a cell reference. The value in the cell named Liability subtracted from the value in the cell named Asset. Note: This functionality doesn't work in Excel for the web. The values in all cells, but you must press Ctrl+Shift+Enter after you type in your formula. In one or several formulas, you can use a cell reference to refer to:ĭata from one or more contiguous cells on the worksheet.ĭata contained in different areas of a worksheet.ĭata on other worksheets in the same workbook. LessĪ cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |