Microsoft Office Tutorials and References
In Depth Information
Selecting Cells in a Worksheet
If your name doesn’t appear in the pop-up box after you enter a comment
and you want it to appear there, go to the File tab, choose Options, select
the General category in the Excel Options dialog box, and enter your name in
the User Name text box.
You can print the comments in a worksheet. On the Page Layout tab, click
the Page Setup group button, and on the Sheet tab of the Page Setup dialog
box, open the Comments drop-down list and choose At End of Sheet or As
Displayed on Sheet.
Selecting Cells in a Worksheet
To format, copy, move, delete, and format numbers and words in a
worksheet, you have to select the cells in which the numbers and words are
found. Here are ways to select cells and the data inside them:
A block of cells: Drag diagonally across the worksheet from one corner
of the block of cells to the opposite corner. You can also click in one
corner and Shift+click the opposite corner.
Adjacent cells in a row or column: Drag across the cells.
Cells in various places: While holding down the Ctrl key, click different
cells.
A row or rows: Click a row number to select an entire row. Click and
drag down the row numbers to select several adjacent rows.
A column or columns: Click a column letter to select an entire column.
Click and drag across letters to select adjacent columns.
Entire worksheet: Click the Select All button, the square to the left of
the column letters and above the row numbers; press Ctrl+A; or press
Ctrl+Shift+Spacebar.
Press Ctrl+Spacebar to select the column that the active cell is in; press
Shift+Spacebar to select the row where the active cell is.
You can enter the same data item in several different cells by selecting cells
and then entering the data in one cell and pressing Ctrl+Enter. This
technique comes in very handy, for example, when you want to enter a
placeholder zero (0) in several different cells.
Search JabSto ::




Custom Search