Microsoft Excel Geek Tip:

Having Excel automatically enter consecutive numbers

You may want to enter consecutive numbers in a row of cells. Excel

has a nice feature that will do it automatically for you. To do

this:

Enter the first number of the string into a cell. Press and hold the Ctrl key.

While the Ctrl key is pressed, click the cells fill handle (the

small black square) and drag it over the range in which you want it

to fill in consecutive numbers automatically.

Let go of the mouse button.
Let go of the ctrl key.

Now, your consecutive numbers will be automatically filled in.

Microsoft Excel Geek Tip:

Getting information on your Clip Arts in Microsoft Excel

You can get all of the information that you want about Clip Arts in

Excel. To do this:

Click on Insert in the toolbar.
Select Picture.
Click on Clip Art…
When Microsoft Clip Gallery 3.0 opens click on the Clip Art that you

which to research.

Click on Clip Properties…
This will show you the file size and the name.
If you ever want to use the file again record its name. Then use the

Find feature that is located in the Edit menu in the toolbar to find

the Clip Art. Then you simply click on the picture to insert it.

Microsoft Excel Geek Tip:

Using Text Boxes in Excel

To create a Text Box with Excel, you need to have the Drawing

toolbar present. To do this:

Open the View menu.
Select Toolbars.
Click Drawing.

To insert a Text Box, simple click the Text Box button, the one with

the little A on it. Simply use your mouse to drag the box to the

size you want it. To format a text box, simply click in the Text

Box, open the format menu, and click Text Box. It’s that simple!

Microsoft Excel Geek Tip:

Using the AutoFilter feature of Excel

Microsoft Excel comes with a nice feature called AutoFilter.

AutoFilter is used with tables to single out a certain subset of

that table. For example, you may have a list with each salesman’s

name and the number of toothbrushes they have sold. To show a table

of only the salesman who sold over a certain amount of toothbrushes,

you can use auto filtering. To do this:

- Make sure all of the data in your table is correct.
- Open the Data menu.
- Select Filter.
- Click AutoFilter.
- Now, a down arrow will appear on the top cell of the range.
- Click the arrow and pick the minimum value that you want.

Now Excel with display the salesmen who meet your criteria. To

display the entire table again, click the down arrow and select All.

To completely disable AutoFilter, select AutoFilter from the Data

menu again.