How to enter data Quickly?

image_pdf

 

Here are two time-savers you can use to enter data in Excel:

AutoFill enter the months of the year, the days of the week, multiples of 2 or 3, or other data in a series. You type one or more entries, and then extend the series. For extending series drag the cell to following cells.

For writing series as 1, 3, 5, 7 write first 3-4 entries in cells, select those cells and then drag from last cell to complete the series.

image007

AutoComplete If the first few letters you type in a cell match an entry you've already made in that column, Excel will fill in the remaining characters for you. Just press ENTER when you see them added. This works for text or for text with numbers. It does not work for numbers only, for dates, or for times.

676 total views, 1 views today

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>