Back | Back To Start | Next

Sorting

To sort means to alphabetize.

The Sort Buttons

Autofill

The Autofill feature allows you to quickly fill cells with data such as months or numbers, and repeated text.

1. Type the beginning number or date of a series or the text that will be repeated into a cell.
2. Select the handle at the bottom, right corner of the cell with the left mouse button and drag it down as many cells as you want to fill.
3. Release the mouse button.

Autofill Functions

Autofill can also be used to copy functions.

In the example, column A and column B each contain lists of numbers and column C contains the sums of columns A and B for each row.

The function in cell C2 would be "=SUM(A2:B2)".

To copy this function:

1. Select the handle at the bottom, right corner of the cell.
2. Hold down the left mouse button.
3. Drag down as many cells as you want to fill.

Links to other Excel Online Tutorials:

Excel Full Online tutorials - Excel full tutorial covering most of the functional and operational questions.

MS Excel Very big basic tutorial Tutorial - In this tutorial you get a look into all the required basics. From easy basics of a spreadsheet to charts and graphs.

MS Excel Microsoft Excel - Office 2000 / XP Tutorial - Tutorial covering excel basics including: opening excel, entering data, aligning text, ending a sum and using charts.

MS Excel Tutorials and Projects - Excel spreadsheet creation and projects to help you create your first spreadsheets.

MS Office Training Courseware - Microsoft Office basic programs training and tutorials courseware. Course contains MS Excel, MS Word, MS Access, MS PowerPoint, MS Project and Windows XP Fundamentals. All materials are available for free download.

Merging Cells in Excel - Making your worksheets more "readable" by merging cells.

The Best Chart Types - Choosing a Chart Type For Your Spreadsheet.

Excel Printing - All You Need to Know - How to print properly from excel questions and answers.

Excel Functions and Formulas - This excel tutorial is providing the basics about formulas and functions.

Suggested Reading

Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us

| Terms of Conditions |

Unless otherwise stated, all images and text
Spreadsheet123