See Absolute Address formulas for help with this type of formula. As in many other Windows programs, right clicking on a selection produces a popup menu that can be used on that selection. Rows, changing heights Point the mouse at the the lower boundary of the row to be resized. The pointer should change from a wide cross to a type of crosshair. Drag the boundary up or down as desired.
All button is the corner cell where the row border and column border intersect.
Clicking on it selects the entire worksheet. This can save time for formatting tasks. Selecting, general Select a cell by clicking and a range of cells by clicking and dragging. Graphic objects can be selected by clicking. Sorting You can quickly sort the rows in a range in Excel.