• Home
  • About

Entries RSS | Comments RSS
  • Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

  • Categories

  • Archives

  • Recent Posts

    • Open a Second Window in Outlook 2007
    • Excel Twitters 20090103
    • Excel Twitters 2008127
    • Have an Excellent Christmas!
    • Open a New Tab in Firefox
  • Pages

    • About
  • Subscribe in a reader

Three Data Entry Tips for Excel

Posted on March 24th, 2008 by Debra Dalgleish
  1. To enter today’s date in a cell:   Ctrl+;
  2. To copy the data from the cell above:  Ctrl+’
  3. To create a line break within a cell:  Alt+Enter

Line Break

Share/Save/Bookmark

Filed under: Data Entry, Excel

Grab the Excel Color Palettes »

2 Responses to “Three Data Entry Tips for Excel”


  1. Comment from edataprocessing
    Time: June 2, 2008, 10:22 am

    very nice information. Keep posting such things


  2. Comment from Jagannathan .S
    Time: August 26, 2008, 6:06 am

    To copy the data from the cell above: Ctrl+’ in addition we can also use Ctrld

Leave a Reply

  • Subscribe

    Subscribe in a reader
  • Email Updates

    Subscribe by Email
  • Calendar

    March 2008
    S M T W T F S
        Apr »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
  • Contextures

    • Contextures Excel Pages
    • My Video Tutorials
  • Excel

    • Daily Dose of Excel
    • Excel Team Blog
    • Jan Karel Pieterse
    • JP’s Excel/Outlook
    • PTS Blog
    • Spreadsheet Page Blog
    • TVMCalcs Excel Blog
  • General

    • Hodge Blog
    • J-Walk Blog
    • SuiteMinute