|
|
|
This page presents how to work with Microsoft Excel 2007 features and its redesigned interface. You may also visit our Excel Question page.
|
Select cells, ranges, rows, or columns on a worksheet
On a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.), you can select cells, ranges (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.), rows, or columns — for example, to format the data in the selection, or to insert other cells, rows, or columns. You can also select all or part of the cell contents and turn on Editing mode so that you can modify the data.
You can select cells and ranges in a Microsoft Office Excel table just as you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.
Note If a worksheet has been protected, you might not be able to select cells or their contents on a worksheet.
What do you want to do?
Select cells, ranges, rows, or columns
Select the contents of a cell
Select rows and columns in an Excel table
Select cells, ranges, rows, or columns
|
To select
|
Do this
|
|
A single cell
|
Click the cell, or press the arrow keys to move to the cell.
|
|
A range of cells
|
Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection.
You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.
|
|
A large range of cells
|
Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.
|
|
All cells on a worksheet
|
Click the Select All button.
To select the entire worksheet, you can also press CTRL+A.
Note If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
|
|
Nonadjacent cells or cell ranges
|
Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. To stop adding cells or ranges to the selection, press SHIFT+F8 again.
Note You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.
|
|
An entire row or column
|
Click the row or column heading.
 Row heading
 Column heading
You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).
Note If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell. Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column.
|
|
Adjacent rows or columns
|
Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
|
|
Nonadjacent rows or columns
|
Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.
|
|
The first or last cell in a row or column
|
Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).
|
|
The first or last cell on a worksheet or in a Microsoft Office Excel table
|
Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.
Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.
|
|
Cells to the last used cell on the worksheet (lower-right corner)
|
Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner).
|
|
Cells to the beginning of the worksheet
|
Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.
|
|
More or fewer cells than the active selection
|
Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.) and the cell that you click becomes the new selection.
|
Tip To cancel a selection of cells, click any cell on the worksheet.
Notes
- Excel marks selected cells or ranges by highlighting them. These highlights do not appear in a printout. If you want to display cells with a highlight when you print a worksheet, you can use formatting features to apply cell shading.
For more information, see Apply or remove cell shading.
Top of Page
Select the contents of a cell
Top of Page
Select rows and columns in an Excel table
You can select cells and ranges in a table just as you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.
|
To select
|
Do this
|
|
A table column with or without table headers
|
Click the top edge of the column header or the column in the table. The following selection arrow appears to indicate that clicking selects the column.
Note Clicking the top edge once selects the table column data; clicking it twice selects the whole table column.
You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW.
Note Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the whole table column.
|
|
A table row
|
Click the left border of the table row. The following selection arrow appears to indicate that clicking selects the row.
You can click the first cell in the table row, and then press CTRL+SHIFT+RIGHT ARROW.
|
|
All table rows and columns
|
Click the upper-left corner of the table. The following selection arrow appears to indicate that clicking selects the table data in the entire table.
Click the upper-left corner of the table twice to select the whole table, including the table headers.
You can also click anywhere in the table, and then press CTRL+A to select all table data in the table, or you can click the top-left most cell in the table, and then press CTRL+SHIFT+END.
Press CTRL+A twice to select the whole table, including the table headers.
|
Top of Page
See Also
Excel > Worksheet and Excel table basics > Selecting and navigating
Select specific cells or ranges
Whether or not you define named cells or ranges (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) on your worksheet, you can use the Name box (Name box: Box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. To name a cell or range, type the name in the Name box and press ENTER. To move to and select a named cell, click its name in the Name box.) to quickly locate and select specific cells or ranges by entering their names or their cell references (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.).
The Name box is located to the left of the formula bar.
You can also select named or unnamed cells or ranges by using the Go To command.
Important To select named cells and ranges, you must first define their names on your worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). For information about how to name cells or ranges, see Define and use names in formulas.
What do you want to do?
Select named or unnamed cells or ranges by using the Name box
Select named or unnamed cells or ranges by using the Go To command
Select named or unnamed cells or ranges by using the Name box
In the Name box, located at the left end of the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), do one of the following:
- To select a named cell or range, type its name, and then press ENTER.
Tip You can also click the arrow next to the Name box to display the list of named cells or ranges, and then click the name that you want.
- To select two or more named cell references or ranges, click the arrow next to the Name box, and then click the name of the first cell reference or range that you want to select. Then hold down CTRL while you click the names of other cells or ranges in the Name box.
Note The currently selected cell or range will remain selected along with the cells or ranges that you select in the Name box.
- To select an unnamed cell reference or range, type the cell reference of the cell or range of cells that you want to select, and then press ENTER.
Tip For example, type B3 to select that cell, or type B1:B3 to select a range of three cells.
Note In the Name box, you cannot delete or change names that have been defined for cells or ranges. You can only delete or change names in the Name Manager dialog box (Formulas tab, Defined Names group). For more information, see Define and use names in formulas.
Top of Page
Select named or unnamed cells or ranges by using the Go To command
- On the Home tab, in the Editing group, click Find & Select, and then click Go To.
Keyboard shortcut You can also press CTRL+G.
- In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box.
For example, in the Reference box, type B3 to select that cell, or type B1:B3 to select a range of three cells. You can select multiple cells or ranges by entering them in the Reference box, separated by commas.
Note In the Go to list, you can view all the named or unnamed cells or ranges that you previously selected by using the Go To command. To return to a previous selection, double-click the name of the cell reference in the Go to list.
Tip To quickly find and select all cells that contain specific types of data (such as formulas) or only cells that meet specific criteria (such as visible cells only or the last cell on the worksheet that contains data or formatting), click Special in the Go To dialog box, and then click the option that you want in the Go To Special dialog box.
Top of Page
See Also
Excel > Worksheet and Excel table basics > Selecting and navigating
Select all cells on a worksheet
To select all cells on a worksheet, do one of the following:
- Click the Select All button.
Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
Tip If you want to select all cells in the active range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.), press CTRL+SHIFT+*.
See Also
Excel > Worksheet and Excel table basics > Selecting and navigating
Select one or multiple worksheets
By clicking the tabs of worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) (or sheets) at the bottom of the window, you can quickly select a different sheet. If you want to enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. You can also format or print a selection of sheets at the same time.
Tip When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.
Notes
- Data that you enter or edit in the active sheet (active sheet: The sheet that you're working on in a workbook. The name on the tab of the active sheet is bold.) is reflected in all selected sheets. These changes might replace data on the active sheet and, perhaps unintentionally, on other selected sheets.
- Data that you copy or cut in grouped sheets cannot be pasted on another sheet, because the size of the copy area includes all layers of the selected sheets and is therefore different from the paste area in a single sheet. Make sure that only one sheet is selected before you copy or move data to another worksheet.
- When you save a workbook that contains grouped sheets and then close the workbook, the sheets that you selected remain grouped when you reopen that workbook.
See Also
Excel > Worksheet and Excel table basics > Selecting and navigating
Move or scroll through a worksheet
There are different ways to scroll through a worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). You can use the arrow keys, the scroll bars, or the mouse to move between cells and to move quickly to different areas of the worksheet.
In Microsoft Office Excel 2007, you can take advantage of increased scroll speeds, easy scrolling to the end of ranges, and ScreenTips that let you know where you are in the worksheet. You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars.
What do you want to do?
Use the arrow keys to move through a worksheet
Use the scroll bars to move through a worksheet
Scroll and zoom by using the mouse
Use the arrow keys to move through a worksheet
To move between cells on a worksheet, click any cell or use the arrow keys. When you move to a cell, it becomes the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.).
|
To scroll
|
Do this
|
|
To the start and end of ranges
|
Press CTRL+an arrow key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet.
To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key.
|
|
One row up or down
|
Press SCROLL LOCK, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.
|
|
One column left or right
|
Press SCROLL LOCK, and then use the LEFT ARROW key or RIGHT ARROW key to scroll one column left or right.
|
|
One window up or down
|
Press PAGE UP or PAGE DOWN.
|
|
One window left or right
|
Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key.
|
|
A large distance
|
Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.
|
Note When SCROLL LOCK is on, Scroll Lock is displayed on the status bar. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right. To use the arrow keys to move between cells, you must turn SCROLL LOCK off.
Top of Page
Use the scroll bars to move through a worksheet
If you do not see the scroll bars, do the following to display them:
- Click the Microsoft Office Button
, and then click Excel Options.
- Click Advanced, and then under Display options for this workbook, make sure that the Show horizontal scroll bar and the Show vertical scroll bar check boxes are selected, and then click OK.
The following table describes different ways for using the scroll bars to move through a worksheet.
|
To scroll
|
Do this
|
|
One row up or down
|
Click the scroll arrows  or  on the vertical scroll bar to move the sheet one row up or down.
|
|
One column left or right
|
Click the scroll arrows  or  on the horizontal scroll bar to move the sheet one column to the left or right.
|
|
Scroll through a worksheet with increased scroll speed
|
While scrolling, hold down the mouse at the farthest end of the screen for more than 10 seconds to increase the scrolling speed.
Moving the mouse in the opposite direction slows down the scroll speed.
|
|
One window up or down
|
Click above or below the scroll box  on the vertical scroll bar.
|
|
One window left or right
|
Click to the left or right of the scroll box on the horizontal scroll bar.
|
|
A large distance
|
Hold down SHIFT while dragging the scroll box .
|
Notes
- When you use the scroll boxes to move through a worksheet, Excel displays a ScreenTip to indicate row numbers or column letters (or numbers, if the R1C1 reference style is specified for the workbook) so that you know where you are in the worksheet.
- The size of a scroll box indicates the proportional amount of the used area of the sheet that is visible in the window. The position of a scroll box indicates the relative location of the visible area within the worksheet.
- You can quickly split the window so that you can scroll in two or four panes simultaneously. Point to the split box
on either the vertical or the horizontal scroll bar. When the pointer becomes a double-headed arrow 
, drag the split bar onto the worksheet where you want to split the window. Double-click the split bar to remove it.
Top of Page
Scroll and zoom by using the mouse
Some mouse devices and other pointing devices, such as the Microsoft IntelliMouse pointing device, have built-in scrolling and zooming capabilities that you can use to move around and zoom in or out on your worksheet or chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.). You can also use the mouse to scroll in dialog boxes that have drop-down lists with scroll bars. For more information, see the instructions for your pointing device.
|
To
|
Do this
|
|
Scroll up or down a few rows at a time
|
Rotate the wheel forward or back.
|
|
Scroll through a worksheet with increased scroll speed
|
While scrolling, hold down the mouse at the farthest end of the screen for more than 10 seconds to increase the scrolling speed.
Moving the mouse in the opposite direction slows down the scroll speed.
|
|
Pan through a worksheet
|
Hold down the wheel button, and drag the pointer away from the origin mark in any direction that you want to scroll. To speed up scrolling, move the pointer away from the origin mark. To slow down scrolling, move the pointer closer to the origin mark.
|
|
Pan through a worksheet automatically
|
Click the wheel button, and then move the mouse in the direction that you want to scroll. To speed up scrolling, move the pointer away from the origin mark. To slow down scrolling, move the pointer closer to the origin mark. To stop automatic scrolling, click any mouse button.
|
|
Zoom in or out
|
Hold down CTRL while you rotate the IntelliMouse wheel forward or back. The percentage of the zoomed worksheet is displayed on the status bar.
|
|
Show detail in outlines (outline: Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.)
|
Point to a cell that summarizes data in the outline, and then hold down SHIFT while you rotate the wheel forward.
|
|
Hide detail in outlines
|
Point to any cell that contains detail data, and then hold down SHIFT while you rotate the wheel back.
|
Top of Page
See Also
Excel > Worksheet and Excel table basics > Selecting and navigating
Find and select cells that meet specific conditions
You can use the Go To command to quickly find and select all cells that contain specific types of data (such as formulas) or only cells that meet specific criteria (such as the last cell on the worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) that contains data or formatting).
- Do one of the following:
How to select ranges, rows, or columns
|
To select
|
Do this
|
|
A single cell
|
Click the cell, or press the arrow keys to move to the cell.
|
|
A range of cells
|
Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection.
You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.
|
|
A large range of cells
|
Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.
|
|
All cells on a worksheet
|
Click the Select All button.
To select the entire worksheet, you can also press CTRL+A.
Note If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
|
|
Nonadjacent cells or cell ranges
|
Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.
You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. To stop adding cells or ranges to the selection, press SHIFT+F8 again.
Note You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.
|
|
An entire row or column
|
Click the row or column heading.
 Row heading
Column heading
You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).
Note If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell. Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column.
|
|
Adjacent rows or columns
|
Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
|
|
Nonadjacent rows or columns
|
Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.
|
|
The first or last cell in a row or column
|
Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).
|
|
The first or last cell on a worksheet or in a Microsoft Office Excel table
|
Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.
Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.
|
|
Cells to the last used cell on the worksheet (lower-right corner)
|
Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner).
|
|
Cells to the beginning of the worksheet
|
Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.
|
|
More or fewer cells than the active selection
|
Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.) and the cell that you click becomes the new selection.
|
- On the Home tab, in the Editing group, click Find & Select, and then click Go To.
Keyboard shortcut You can also press CTRL+G.
- Click Special.
- In the Go To Special dialog box, click one of the following options.
|
Click
|
To select
|
|
Comments
|
Cells that contain comments.
|
|
Constants
|
Cells that contain constants (constant: A value that is not calculated and, therefore, does not change. For example, the number 210, and the text "Quarterly Earnings" are constants. An expression, or a value resulting from an expression, is not a constant.).
|
|
Formulas
|
Cells that contain formulas (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).).
Note The check boxes below Formulas define the type of formula that you want to select.
|
|
Blanks
|
Blank cells.
|
|
Current region
|
The current region (current region: The block of filled-in cells that includes the currently selected cell or cells. The region extends in all directions to the first empty row or column.), such as an entire list.
|
|
Current array
|
An entire array (array: Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.) if the active cell (active cell: The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.) is contained in an array.
|
|
Objects
|
Graphical objects, including charts and buttons, on the worksheet and in text boxes.
|
|
Row differences
|
All cells that differ from the active cell in a selected row. There is always one active cell in a selection, whether this is a range, row, or column. By pressing ENTER or TAB, you can change the location of the active cell, which by default is the first cell in a row.
If more than one row is selected, the comparison is done for each individual row of that selection, and the cell that is used in the comparison for each additional row is located in the same column as the active cell.
|
|
Column differences
|
All cells that differ from the active cell in a selected column. There is always one active cell in a selection, whether this is a range, row, or column. By pressing ENTER or TAB, you can change the location of the active cell, which by default is the first cell in a column.
If more than one column is selected, the comparison is done for each individual column of that selection, and the cell that is used in the comparison for each additional column is located in the same row as the active cell.
|
|
Precedents
|
Cells that are referenced by the formula in the active cell. Under Dependents, do one of the following:
Click Direct only to find only cells that are directly referenced by formulas.
Click All levels to find all cells that are directly or indirectly referenced by the cells in the selection.
|
|
Dependents
|
Cells with formulas that refer to the active cell.
Click Direct only to find only cells with formulas that refer directly to the active cell.
Click All levels to find all cells that directly or indirectly refer to the active cell.
|
|
Last cell
|
The last cell on the worksheet that contains data or formatting.
|
|
Visible cells only
|
Only cells that are visible in a range that crosses hidden rows or columns.
|
|
Conditional formats
|
Only cells that have conditional formats applied. Under Data validation, do one of the following:
Click All to find all cells that have conditional formats applied.
Click Same to find cells that have the same conditional formats as the currently selected cell.
|
|
Data validation
|
Only cells that have data validation rules applied.
Click All to find all cells that have data validation applied.
Click Same to find cells that have the same data validation as the currently selected cell.
|
See Also
Excel > Worksheet and Excel table basics > Selecting and navigating
Hide or display scroll bars in a workbook
By default, a horizontal and vertical scroll bar are displayed in an Excel workbook (workbook: A spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data.) so that you can scroll through the data in its worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). However, you can turn scroll bars on or off as needed.
- Click the Microsoft Office Button , and then click Excel Options.
- In the Advanced category, under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box to hide or display the scroll bars.
See Also
Excel > Worksheet and Excel table basics > Selecting and navigating
Excel status bar options
The status bar at the bottom of Microsoft Office programs displays status on options that are selected to appear on the status bar. Many options are selected by default, but you can customize the status bar and turn options on or off. For more information about customizing the status bar, see Customize the status bar.
In Microsoft Office Excel 2007, the following options are available on the status bar.
|
This option
|
Displays the following on the status bar
|
|
Cell Mode
|
Selected by default, this option displays the current cell editing mode on the left side of the status bar. One of the following modes is displayed.
- Ready to indicate a general state.
- Enter to indicate content entry mode. It is displayed when you select a cell and start typing, or when you press F2 twice.
- Edit to indicate in-cell editing mode. It is displayed when you double-click a cell, or when you press F2 so that you can enter or edit data in a cell.
- Point to indicate formula cell selection mode. It is displayed when you start a formula and then click the cells that you want to include in the formula.
|
|
Signatures
|
Selected by default, this option indicates that the active workbook has been digitally signed.
|
|
Information Management Policy
|
Selected by default, this option indicates that Information Rights Management (IRM) has been used to restrict permission to content in the active workbook.
|
|
Permissions
|
Selected by default, this option displays an icon next to the Cell Mode indicator that you can click to view the current read and edit document permissions. This icon displays only when access to the document has been restricted (Microsoft Office Button , Prepare, Restrict Permission, Restricted Access).
|
|
Caps Lock
|
When selected, this option displays Caps Lock to indicate that CAPS LOCK is turned on to allow typing in uppercase characters. This option is not selected by default.
|
|
Num Lock
|
When selected, this option displays Num Lock to indicate that NUM LOCK is turned on to allow using the keys on the numeric keypad to enter numbers in the worksheet. This option is not selected by default.
|
|
Scroll Lock
|
Selected by default, this option displays Scroll Lock to indicate that SCROLL LOCK is turned on to allow scrolling in the worksheet by using the arrow keys.
|
|
Fixed Decimal
|
Selected by default, this option displays Fixed Decimal to indicate that all numerical values that you enter on the worksheet will be displayed with fixed decimals. This option is turned on when you select the Automatically insert a decimal point check box under Editing options on the Advanced tab of the Excel Options dialog box (Microsoft Office Button , Excel Options, Advanced).
|
|
Overtype Mode
|
When selected, this option displays Overtype to indicate that INSERT was pressed to activate overtype mode while editing cell contents in cell editing mode (double-click a cell or press F2). This option is not selected by default.
|
|
End Mode
|
Selected by default, this option displays End Mode to indicate that END was pressed to activate end mode. Pressing END followed by an arrow key moves the selection in the direction of the arrow key, stopping at the start and end of data, and then the start or end of the worksheet.
|
|
Macro Recording
|
Selected by default, this option displays a button next to the Cell Mode indicator that you can click to start recording a macro.
|
|
Selection Mode
|
Selected by default, this option displays one of the following cell selection modes.
- Extend Selection when you press F8 to extend the cell selection by using arrow keys.
- Add to Selection when you press SHIFT+F8 to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
|
|
Page Number
|
Selected by default, this option displays the page number of the selected worksheet page and the number of pages in the worksheet when you are working in Page Layout view or Print Preview view.
|
|
Average
|
Selected by default, this option displays the average that is calculated from selected cells that contain numerical values.
|
|
Count
|
Selected by default, this option displays the number of selected cells.
|
|
Numerical Count
|
When selected, this option displays the number of selected cells that contain numerical values. This option is not selected by default.
|
|
Minimum
|
When selected, this option displays the minimum numerical value in selected cells. This option is not selected by default.
|
|
Maximum
|
When selected, this option displays the maximum numerical value in selected cells. This option is not selected by default.
|
|
Sum
|
Selected by default, this option displays the sum of numerical values in selected cells.
|
|
View Shortcuts
|
Selected by default, this option displays the Normal view, Page Layout view, and Page Break Preview buttons. You can click these buttons to change the current view.
|
|
Zoom
|
Selected by default, this option displays the Zoom level. You can click Zoom to open the Zoom dialog box, where you can specify the percentage of magnification that you want to use.
|
|
Zoom Slider
|
Selected by default, this option displays the Zoom slider with the Zoom out and Zoom in buttons. You can then drag the slider or click the Zoom out and Zoom in buttons to magnify the content of the worksheet to have a closer look, or to reduce the size of the content on the worksheet so that you can view more content.
|
See Also
