Home
MS Office - How to ?
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Free e-books
VIDEO Tutorials
Office 2007 Guides
Excel 2007 Tutorials
PowerPoint 2007 Guides
Word 2007 Tutorials
MS Office Template
Free Clip Art
Keyboard Shortcut
Tips and Tricks
MS Outlook
MS Publisher
Free Newsletter
MS Windows
Contact Us
Site Map
Google Docs and ...
You and This Site
Resources Page

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


How to Enter Data into the Excel Worksheet?



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 and then type in the text.
  • Text entries are left aligned by default.

    To enter numbers into a worksheet

  • Select the cell in which you want to enter a number and type in the number.
  • 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 and then type in the date or time. Separate the date with either hyphens (-) or slashes (/).
  • To enter the current date, press Ctrl+;
  • To enter the current time, press Ctrl+:

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.


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

    Google
     

    Back to Top


    Recommended book:

    Revealed! 101 Excel Secrets Revealed! 101 Excel Secrets


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


    footer for enter data page