Mohsin Web
You are Unregistered, please Login Or Register to gain Full access.
Note: If You Want To Visit Us As Guest Then Click On Do Not Display Again

Sorting and Filling

Go down

Sorting and Filling

Post by Admin on Sat Jun 20, 2009 11:05 am


Basic Sorts
To execute a basic descending or ascending sort based on one column,
highlight the cells that will be sorted and click the Sort Ascending
(A-Z) button or Sort Descending (Z-A) button on the standard

Complex Sorts
To sort by multiple columns, follow these steps:

  1. Highlight the cells, rows, or columns that will be sorted.
  2. Select Data|Sort from the menu bar.
  3. From the Sort dialog box, select the first column for
    sorting from the Sort By drop-down menu and choose either
    ascending or descending.
  4. Select the second column and, if necessary, the third sort column
    from the Then By drop-down menus.

  5. If the cells you highlighted included the text headings in the
    first row, mark My list has...Header row and the
    first row will remain at the top of the worksheet.
  6. Click the Options button for special non-alphabetic or
    numeric sorts such as months of the year and days of the week.

  7. Click OK to execute the sort.

The Autofill feature allows you to quickly fill cells with repetitive
or sequential data such as chronological dates or numbers, and repeated

  1. Type the beginning number or date of an incrementing 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.

If you want to autofill a column with cells displaying the same
number or date you must enter identical data to two adjacent cells
in a column. Highlight the two cells and drag the handle
of the selection with the mouse.

Alternating Text and Numbers with Autofill
The Autofill feature can also be used for alternating text or
numbers. For example, to make a repeating list of the days of the
week, type the seven days into seven adjacent cells in a column.
Highlight the seven cells and drag down with the mouse.

Autofilling Functions
Autofill can also be used to copy functions. In the example
below, 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)". This function can then
be copied to the remaining cells of column C by activating cell
C2 and dragging the handle down to fill in the remaining cells.
The autofill feature will automatically update the row numbers as
shown below if the cells are reference relatively.



Posts : 136
Age : 23
Location :

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum