"How to Enter Data into Excel 2007 Worksheet?"


Enter data into excel 2007 worksheet?

Yes, to start using Excel, you need to know how to enter data into the Excel worksheet. The tutorial here shows you the very basic of entering text, number, date and time into the worksheet.


To enter text into a worksheet

  • Select the cell in which you want to enter the text.
  • Type in the text/data into the cell.
  • Press the Enter key. Text entries are left aligned by default.


To enter numbers into a worksheet

  • Select the cell in which you want to enter a number.
  • Type in the number into the cell and press Enter.
  • If you want to enter a negative number, type a minus sign in front of it or enclose it in parentheses (bracket), e.g. -15 or (15).
  • To indicate decimal places, you type a full stop such as 125.89.
  • The numbers will be right aligned by default.


To enter dates and times into a worksheet

  • Select the cell in which you want to enter the date or time.
  • Type in the date or time. Separate the date with either hyphens (-) or slashes (/).
  • Press Enter.
  • To enter the current date, press Ctrl+;
  • To enter the current time, press Ctrl+:


You may utilize the keyboard to help you speed up the data entry process. Below is a list of keys that you can use when you want to quickly enter your data.


To speed up your data entry

  • Enter key: Pressing the key will enters the data and moves the active cell highlight down to the next cell in the current column.
  • Tab key: Pressing the key will enters the data and moves the active cell highlight to the next cell in the current row.
  • Arrow keys: Pressing the key will enters the data and moves the active cell highlight to the next cell in the direction of the specific arrow key pressed.
  • Esc key: Pressing the key will will cancels the current data entry.


Related Topics:

Getting Started with Excel 2007
Excel 2007 Screen Elements
The New Excel 2007 Ribbon
Excel 2007 Status Bar
How to Save a Workbook Correctly?



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the enter data into Excel 2007 info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.