Insert or delete a worksheet
Insert a worksheet * Select the New Sheet plus icon at the bottom of the workbook. * Or, select Home > Insert > Insert Sheet . Rename a worksheet * Double-click the sheet name on the Sheet tab to quickly rename it. * Or, right-click on the Sheet tab, click Rename , and type a new name. Move a work…
Fill Data Automatically in Worksheet Cells
* Select one or more cells you want to use as a basis for filling additional cells. For a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. For the series 2, 4, 6, 8..., type 2 and 4. For the series 2, 2, 2, 2..., type 2 in first cell only. * Drag the fill handle . * If needed, click Auto Fi…
Introduction to Formulas in Excel
Create a formula that refers to values in other cells * Select a cell. * Type the equal sign =. Note: Formulas in Excel always begin with the equal sign. * Select a cell or type its address in the selected cell. * Enter an operator. For example, – for subtraction. * Select the next cell, or type its address …
Printing in Excel
Print a Worksheet or Workbook Before you print Before you print anything in Excel, remember that there are many options available for an optimal print experience. For more information, see Printing in Excel . Important: Some formatting, such as colored text or cell shading, may look good on the screen but not lo…
