• The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default MS Excel 2007 Lecture # 5

    "How to Enter Data into Excel 2007 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.
    Find Me On Social Networks

    Facebook | Twitter | Google+



 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •