Microsoft Office Tutorials and References
In Depth Information
Selecting complete rows and columns
Quick Analysis?
When you select a range of data, Excel may display a Quick Analysis button at the lower right corner
of the selection. Click the icon, and you’fill see a list of analysis options that you can quickly apply to
the selected data. You can add conditional formatting, create a chart, add formulas, create a pivot
table, and generate Sparkline graphics. The exact options vary, depending on the data in the range.
These options provide nothing that you can’t do using standard commands, and all these options are
discussed elsewhere in this topic. If you fi nd the Quick Analysis icon annoying, choose File
to display the Excel Options dialog box, select the General tab, and deselect Show Quick Analysis
options on selection.
Selecting complete rows and columns
Often, you’fill need to select an entire row or column. For example, you may want to apply
the same numeric format or the same alignment options to an entire row or column. You
can select entire rows and columns in much the same manner as you select ranges:
Click the row or column header to select a single row or column.
To select multiple adjacent rows or columns, drag over the row or column header.
To select multiple (nonadjacent) rows or columns, press Ctrl while you click the
row or column headers that you want.
Press Ctrl+Spacebar to select a column. The column of the active cell (or columns
of the selected cells) is highlighted.
Press Shift+Spacebar to select a row. The row of the active cell (or rows of the
selected cells) is highlighted.
Search JabSto ::

Custom Search