• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 8. Using Excel 2003 > Speed Data Entry

Speed Data Entry

Excel can often predict what data you want to enter into a worksheet. By spotting trends in your data, Excel uses educated guesses to fill in cell data for you. Excel uses data fills to copy and extend data from one cell to several additional cells.

To Do: Use Data Fills

One of the most common data fills you perform is to use Excel's capability to copy one cell's data to several other cells. You might want to create a pro forma balance sheet for the previous five-year period, for example. You can insert a two-line label across the top of each year's data. The first line would contain five occurrences of the label Year, and the second line would hold the numbers 2003 through 2007. To use the data-fill feature in Excel to create the five similar labels, perform these simple steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint