Create Excel Spreasheets More Quickly

Do you spend too much time and energy typing information in an Excel spreadsheet?

Would you like faster way to do this?

How about sequential information - like numbers or dates?

Houston computer service expert Cheryl Smith shares a few tips: 

For Repeated data:

1. Enter the first data in cell desired.
2. Highlight all cells in which you want this data to appear
3. Use function command: Control D, Control F or Edit Fill

For Sequential data:

1.       Enter the first data preferred such as; January, Monday, or a date 8-25-2010 etc.

2.       Click at the bottom of this cell allowing the Fill Handle (black cross) to appear

3.       Drag this handle to the end of desired cells; this will automatically fill in the information for you.

If you have any questions, feel free to ask our Houston IT support experts in the “Ask The Experts!” box on the right.

We hope you have found this information helpful. If you would like to learn more about this subject, please feel free to contact us:

·         Questions about this article?

·         Suggest a topic

·         Learn more about our Houston IT Consulting