word-excel-access-help.com logo
Excel Spreadsheet Data
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Additional Resources







Excel Spreadsheet Data | Microsoft Excel XP

Microsoft Excel XP logo
Learn step-by-step everything about entering Excel spreadsheet data. Learn how to enter text, values, fractions, date, time or even current date & time.

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.

Excel Office Helper 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. (↑↓→←)


Excel Office Helper
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.

Excel Office Helper
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
- Print
- 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