Excel Spreadsheet Data
 |
 |
 |
 |
 |
 |
 |
Additional Resources
Excel Spreadsheet Data | Microsoft Excel XP |
 |
With all those pretty horizontal and vertical lines, spreadsheets sure look impressive. And with those official-looking row and column indicators, spreadsheets seem to be saying: "Hey, I'm important, you'd better take me seriously."
A spreadsheet is only as good as the Excel spreadsheet data you put into it, however. Whether that data be Grandma's Secret Recipes or June 1993 Mid-West Sales Figures, a spreadsheet needs data to find fulfillment.
This page reveals how to enter al sorts of Excel spreadsheet data from simple text to complex fractions into your spreadsheets.
 |
What's on this page... Entering Text Entering Values Entering the CURRENT Date or Time Entering Date & Times Entering Fractions Entering the Same Data into a Range of Cells |
How Data Works
Each spreadsheet in a workbook is made up of cells,and a cell can hold any of four types of data:
| ► | VALUE (including a date, time, percentage or currency value) |
| ► | TEXT |
| ► | Logical Value (TRUE or FALSE) |
| ► | FORMULA, which returns a value, text, or logical value. |
Entering Text
Enter text as Excel spreadsheet data are the most easiest to do.To enter text (rather than a value or a formula) into a cell, follow these steps:
| 1. | Move the cell pointer to the appropriate cell (this makes it the active cell). |
| 2. | Type the text. |
| 3. | Press ENTER or any of the four direction keys on the keyboard. (↑↓→←) |
|
|
If you enter text that's longer than its columns current width, one of two things happens: ► If the cells to the immediate right are blank, Excel displays the text in its entirety, splitting the entry into adjacent cells. ► If an adjacent cell is not blank, Excel displays as much of the text as possible. (The full text is contained in the cell; it's just not displayed - REMEDY - Make the column wider!). |
In either case, you can always see the text that you're typing because it appears in the formula bar as well as in the cell.
If you need to display a long text entry that's adjacent to a cell with an entry, you can edit your text to make it shorter, increase the width of the column, or wrap the text within the cell so that it occupies more than one line.
|
|
Force Multiple Lines If you have lengthy text in a cell, you can force Excel to display the Excel spreadsheet data in multiple lines within the cell. Use ALT+ENTER to start a new line in a cell. When you add this line break, Excel automatically changes the cells format to Wrap Text. |
| Back to Top |
| See also... Enter Values | Enter Current Date & Time | Enter Date & Time |
| Enter Fractions | Enter the same Data into a Range of cells |
| Return to Excel XP from Excel Spreadsheet Data |
Excel XP Topics
- Tips- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter