You could then take matters one step further by saving a blank copy of this altered workbook (with this global format change) as your default workbook. Thereafter, the auto- formatting functionality is effectively disabled. Next, apply a different number format (such as the Accounting format with zero decimal places and no dollar sign symbols) from the Home tab's Number group. To do this, select the entire workbook as follows: Select all sheet tabs by right- clicking a worksheet tab and clicking the Select All Sheets option, and then clicking the leftmost top corner of one of the worksheets. While there isn't a specific option for disabling the General format's auto- formatting functionality, you can effectively disable it with a simple trick: Change your workbook's default number format to something other than the General number format. Usually, CPAs tend to appreciate the General format because it can save time, but sometimes this adoptive format behavior can be counterproductive-for example, when such format changes aren't desired. Once a cell adopts the new number format, the General number format no longer applies, and the cell will keep the newly applied number format even if numbers with differing formats are subsequently entered. As examples, if you type $45.55 into a cell with General formatting, the cell automatically becomes formatted as currency with two decimal places, or if you enter 37.1%, the cell becomes formatted as a percentage with one decimal place. This is because, as a default, Excel worksheets are globally formatted using the General format, which automatically adopts the number format you use to initially enter numbers into a cell. This card is one of two titles available for Excel 2011: Excel 2011 Introduction and Excel 2011 Charts, Tables & PivotTables.However, these adjustment options do not completely disable Excel's automatic application of number formats as data are entered.
This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. Relative Cell References, Moving or Copying Data: Cut, Copy, and Paste Drag and Drop.įormatting Numbers, Aligning Cell Contents, Borders, Shading, Clearing Formatting, Renaming a Sheet, Selecting Sheets, Moving Sheets, Copying Sheets, Inserting a Worksheet, Deleting Sheets, Moving Among Sheets, Printing the Worksheet, Printing a Specific Area, Setting a Page Break, Repeating Rows or Columns on Every Page of a Printout. Normal View, Entering New Data, Entering Data into a Selected Range, Replacing the Contents of a Cell, Undo or Redo an Action, Editing the Contents of a Cell, Clearing Cells or Ranges of Cells, Inserting Rows or Columns, Inserting Cells, Deleting Rows, Columns, or Cells, Column Width and Row Height, Changing Column Width to Fit, Entering Dates, Copying to Adjacent Cells, Entering a Sequence of Numbers, Excel Formulas, Entering a Formula, Commonly Used Functions, Entering a SUM Â�Function Quickly, Using the Formula Builder, Absolute vs.
The following topics are covered:īeginning a New Workbook, Opening an Existing Document, Page Layout vs. Normal View, Entering New Data, Entering Data i Laminated quick reference card showing step-by-step instructions and shortcuts for Microsoft Excel 2011 for Mac.
The following topics are covered: Beginning a New Workbook, Opening an Existing Document, Page Layout vs. Laminated quick reference card showing step-by-step instructions and shortcuts for Microsoft Excel 2011 for Mac.