Using Excel’s Autofill feature to save time

If you need to fill in a range of headings, or a column of data, Autofill can really save you time. It can be used for consecutive numbering, days of the week, months of the year, years (such as 2014, 2015 …..) and much more. As long as you have at least the first 2 entries, Excel can generally guess how to continue the series.

Here’s an example of how you begin:-

Freeze panes - 1After typing in the first 2 items, select them and then hover with your mouse over the small black box at the very bottom corner, then hold down your left mouse button.

As you drag your mouse to the right (along Row 1), Excel will guess that you wanted Room 3, Room 4 …. and fill them in. As long as you keep your left mouse held down, additional Room numbers will be added – release button to see the result as shown below:-

Freeze panes - 2

 ~~~

If you enjoy this article, please click on “Like” to let me know – and/or write a comment below 🙂

Advertisements

Posted on March 26, 2015, in Learning Zone and tagged , , , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: