Excel formula reference cell for sheet name cell


www.wllstreetre.co Excel 2010 Reference Sheet Note: Some third-party utilities, macros and add-ins can overwrite native shortcut keys Formatting shortcuts Bold CTRL + B Italic CTRL + I Underline CTRL + U Format Box CTRL + 1 Clear cell ALT + H + E + A Outline border SHIFT + CTRL + & Remove border SHIFT + CTRL + _ Insert a comment SHIFT + F2 The INDIRECT(ref_text,[a1]) function syntax has two arguments: ref_text This is a required reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string. commands to have Excel use the name in formulas place of a cell reference. If you want the name to be used in place of any reference to that cell anywhere it might appear in the worksheet, select a single cell before issuing the commands. If you want the name applied to only a particular range, select that range before issuing the commands ... Cell references and ; Defined names. Also, we will see how to make formulas using the function wizard or enter a function directly in a cell. Remember: For starters, any Excel formula begins with the equal sign (=). So, whatever formula you are going to write, begin by typing = either in the destination cell or in the Excel formula bar. www.wllstreetre.co Excel 2013 Reference Sheet Formatting shortcuts Bold CTRL + B Italic CTRL + I Underline CTRL + U Format Box CTRL + 1 Copy CTRL + C Paste CTRL + V Paste Only Formats ALT + E + S + T Paste Only Formulas ALT + E + S + F Paste Only Values ALT + E + S + V Cut CTRL + X Repeat CTRL + Y Undo CTRL + Z Delete cell contents Delete