The Editing Group allows the user to manipulate data inside each cell using the AutoSum, Fill, and Clear Commands as will as sort & filter and Find & Select. We will first review AutoSum.
Let's go back to an example in a previous chapter. You are the owner of a construction company hiring three individuals to perform work for you. You have already used excel to calculate their weekly salary, but now you need more information; you need to know the total salary you expect to spend, the average salary, and the maximum and minimum salaries.
Now, using the AutoSum Icon and corresponding drop-down commands options, the user can allow excel to automatically calculate this information
Sum calculates the total numbers added together in a specified range. Average calculates the value of the cells added together in a specified range divided by the number of cells in the range. Count Numbers provides the number of cells selected in a range. Maximum provides the highest number in a selected range, and Minimum provides the lowest number in a range. While these numbers automatically include the cells above them, the user can specify in the Excel Formula Bar the correct ranges if needed.
In addition to using AutoSum, the Fill Command allows the user to continue a pattern of cell number, or copy the contents of one cell to the next cell in any direction. This could help when the user is creating a numbered list or needs to enter the same data points in many cells.
The Down, Right, Up, and Left Fill commands copy data from one cell to the next cell. Selecting the Series menu allows the user to select multiple methods for a cell to increase in value. Users can specify how much the cell increases and by what value, and whether the information increases in rows or columns. When the user is ready to fill cells, they should highlight the first cell (which has the starting number) and select the “Fill” icon on the menu, and select “Series”, and place the step value and the stop value (when the series should end) and click “Ok”. Their highlighted cells will then display the series in the cell.
This feature is especially helpful when creating numbered lists.
The Clear Command removes formatting and cell contents from selected cells. Once the Clear command is selected, a drop-down menu of options emerges with Clear All, Clear Formats, Clear Contents, Clear Comments, Clear Hyperlinks, and Remove Hyperlinks (if Hyperlinks are present).
The Clear All will remove all of the contents and formatting of the selected cells. This allows the user an easy way to delete information without accidentally moving other data into other columns or rows. Clear Formats removes any formatting (like Bold or Italics) applied to any of the select cells. Clear contents only clear the information inside the cell, not the formatting or cell settings. Clear Comments removes Comments from other users but not the Cell Contents, Clear Hyperlinks remove the hyperlinks from the Cell, but keeps the text, and Remove Hyperlinks removes all text and link from the applicable Cell.
Sort & Filter
One of the powerful features of Excel is to be able to analyze data. One way to analyze data is to sort it by specific fields. The Sort & Filter/feature in Excel allows the user to perform this action. To use the Sort & Filter process, select a cell, and then click on the Sort & Filter menu. A drop-down menu of options will emerge, allowing the user to Sort from Smallest to Largest, Largest to Smallest, Custom Sort, Filter, Clear a previous Sort & Filter, and Reapply a Cleared filter.
Smallest to largest moves all other columns in Excel to be in order with the smallest number in the selected column to be displayed first. Sort Largest to Smallest is the opposite, Custom Sort allows the user to apply multiple sort levels to the document.
Find & Select
Finally, the Find & Select Menu of Excel allows the user to find or replace text, numbers, formulas, comments, or other data in any cell. Selecting the Find & Select Icon will launch a drop-down menu which allows the user to find items, or replace one word or number with another in the entire worksheet. In addition, special search parameters (formulas, comments, conditional formatting, constants, and data validation are also parameters that can be used.