{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

II-DataEntryAndEdit

II-DataEntryAndEdit - II Data Entry Edit Determining the...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Entry and Edit 1 II. Data Entry & Edit Determining the Enter key order of movement One user-configurable option in Excel is where the next current cell will be located after you hit the enter key. The default after you hit the enter key is for Excel to move down one cell, but you can instead choose to have Excel move one cell up, one cell right, or one cell left instead. Set this option by selecting Tools, Options, Edit and choosing from the drop-down list in “Move selection after Enter, Direction”.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Data Entry and Edit 2 The Formula bar Excel’s Formula bar is located directly above the worksheet document window. It does three things: 1. At right, displays the contents of the current cell. For a cell holding a formula, it shows the formula, not the evaluated value the worksheet itself displays. In the example below, Cell D3. 2. At left in the “name box”, displays the cell reference or name of the current cell or range. In the example Cell D3 is named TotalSales. 3. At the time you’re entering a formula displays a red X mark and a green check mark to help you conveniently confirm or cancel the operation. Even if you have several worksheets visible in the Excel workspace at one time, there’s only one Formula bar. It applies to whichever worksheet has the focus. 1 1 You can tell which worksheet has the focus because its title bar is emphasized. Move the focus from one sheet to another by clicking anywhere within the sheet you want to move focus to.
Background image of page 2
Data Entry and Edit 3 Formats and when to apply them The “Format Cells” tabbed dialog includes all Excel’s formatting options. Open
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}