how to remove sort in excel after saving for 2011 for mac

The Custom Views feature allows you to set up and save different views to quickly switch among them.

You can set up a different view for each worksheet and save each view.

The following settings are included in custom views: the zoom level, the current cell selection, column widths and row heights, display settings on the Advanced tab of the Excel Options dialog box, the current size and position of the document window, the window pane arrangement (including frozen rows and columns ), and optionally print settings (including page setup) and hidden columns and rows.

To set the current view as the normal view, click the View tab.

Either check or uncheck the Print settings and Hidden rows, columns and filter settings boxes depending on what you want to include in the view.

As an example, were going to create a view with a 150 zoom and the Formula Bar and Headings hidden, so we can read our spreadsheet easily and have a bit more room on the worksheet.

Set up the view the way you want it and then click Custom Views in the Workbook Views section on the View tab.

You can also double-click the name of the view you want to show.

When you choose a custom view to show for a worksheet that is not currently active, Excel activates that worksheet and applies the view.

So, you must create custom views for each worksheet in each workbook separately and be sure to save your workbook with your custom views.

Since we launched in 2006, our articles have been read more than 1 billion times.

How To Remove Sort In Excel After Saving For 2011 For Mac