Useful Inconsistencies of New Windows

When you create multiple windows of the same Microsoft Office 2007 workbook, anything you do in one window happens in all windows—almost. New entries; formatting changes; inserted or deleted rows, columns, or sheets; and just about any other editing changes are reflected in all windows. Display characteristics—or views—are not. This enables you to zoom in or out and change anything on the View tab of the Tools, Options dialog box and almost anything on the View menu.

In Pacific Sales.xls:1, formulas are displayed, the sheet is zoomed in, and scroll bars, row and column headings, and gridlines are removed—all in an effort to review the formulas in the Summary sheet to make sure they refer to the proper cells. You can also use this technique to audit your worksheets.

If you create a view like Pacific Sales.xls:1  and you want to be able to re-create it in the future, choose View, Custom View to save it. If you want to be able to re-create the entire workspace, including additional windows and their view settings, use the File, Save Workspace command.

Sort and filter list

AutoFilter arrow will be automatically added to the top of the list header row.
Using the "list" command to create a list, will automatically list to add the AutoFilter arrow. In this lecture, you will learn how to use AutoFilter arrows to sort and filter the list data.
(A) how to sort
Click the "descending order" to see the latest orders.
AutoFilter arrow, just click on the column and select the Sort command in the menu that appears, you can sort any column in the list. The sort function by clicking the AutoFilter button is another new feature in MS Office 2010 in Excel.
Suppose you sort in descending on the "Date" column sort so that you can see the latest order, click the arrow on the "Date" header, and then click the "descending order" so that you can.
(B) How to screening
"Pankin in order to filter the list to only display Pankin sales.
As simple as the filter list data and sort the list data. Simply click the AutoFilter arrow and choose to. Excel 2010 will automatically display only the specified data. For example, you can filter by name to view Pankin all sales rather than sales for all. Alternatively, you can filter by date, to view a specific date sales and their sales staff. No matter which column of the specified data, Excel 2010 will display only the column, and a list of all the filtered rows in the other columns.
Can add to the list on the right, rather than add to the list on the left.
Using the "list" command, the worksheet can have more than one list. Can add or delete rows in a list, but not add or delete rows in the list next to it, this is a new feature in Excel 2010.
You can also use the "list" command for each list will automatically provide its own AutoFilter arrows on these lists alone to sort. Office Standard 2010 versions of Excel before, you can only have a list with an AutoFilter arrow. In Excel 2010, when you click on each list, can activate the AutoFilter arrow in the list.
Note, however, if you have a list of the two side by side, and filtered a list, another list looks like filtered AutoFilter to hide entire rows, rather than just hide the screening list line.