Skip to main content
Library homepage
Loading table of contents menu...
Workforce LibreTexts

4.2: Entering Data

  • Page ID
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Types of Data
    Types of Data

    Excel is great tool for generating useful information from data. However, the data has to be entered before it can be analyzed and manipulated. There are numerous types of data, and numerous ways to streamline data entry. As data is typed, it appears in the active cell and in the formula bar. Pressing the Enter key will complete data entry and make the next cell in the column the Formula bar active cell. If moving to the next cell after completing data entry is not the desired outcome, try clicking the Enter check mark in the formula bar. The data will be entered, but the active cell remains the current cell. Pressing the Esc key before completing data entry will cancel data entry and restore the original cell contents.

    Streamlining data entry in Excel can be accomplished using several different features including keyboard shortcuts and Automatic Completion. Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse.

    Excel shortcuts
    Excel shortcuts

    There are hundreds of keyboard shortcuts available in Excel and many are also available in other Microsoft Office applications. A few keyboard equivalents are illustrated at right, but for more examples, use the shortcut F1 to open the Help pane, and type keyboard shortcuts in the Excel Help field.

    When entering data into a sheet that contains a lot of duplicates, Excel uses the Automatic Completion feature to speed up data entry. After typing a couple of characters, Excel guesses how to fill the rest of the cell based on data previously entered in the cells above. Automatic Completion To accept the suggestion (in highlighted text), press Enter, or alternatively, continue typing to replace the automatic entry.

    This page titled 4.2: Entering Data is shared under a CC BY-NC-SA 4.0 license and was authored, remixed, and/or curated by Marcus Lacher (Minnesota Libraries Publishing Project) via source content that was edited to the style and standards of the LibreTexts platform; a detailed edit history is available upon request.

    • Was this article helpful?