Hiding and Unhiding Rows and Columns || Using Functions || Function Wizard
Hiding Rows and Columns
- Click to highlight the row(column) you would like to hide.
- Go to Format, row(column) and click hide.
- Notice how the row(column) is hidden.
Unhide Row or Column
Go to Format, row(column) and click Unhide.3.
Row(column) should reappear.
- Highlight row(column) before hidden row(column) and highlight row after hidden
Using Functions - Ready to use formulas
- A function always begins with an equal sign.
- The data Excel will use to calculate the function is enclosed in parenthesis.
- When there is a comma (,) between cell references, in a function, Excel uses each cell
to perform the calculation.
Example: =Sum(A1,A3) is the same as =A1+A3
- When there is a colon : between cell references in a function, Excel uses the displayed
cells and all the cells between them to perform the calculation.
Example: =Sum(A1:A3) is the same as =A1+A2=A3
- Click the cell you want to place the function.
- Click the Function Wizard button on the toolbar.
- Click the function category and function name.
- At the next dialog box, move the window so that you can see the worksheet.
- Click the cell that contains the first number to calculate. Press tab to
select second number and so forth. Click finish when all numbers are used and see your
calculation in the cell you place your function.
- Select the cells that contain the number you would like to calculate.
- The area at the bottom automatically displays the number that you have
- Right click to display the result of a different calculation. Move the mouse
over this area and press the right button to make the selection.
©1999, Kathy D. Adkins