Accessibility features in Excel

1. On the Tools menu, click Customize.

2. Click the Options tab.

3. Under Other, select or clear the Show ScreenTips on toolbars check box.

Note  Changing this setting affects all of your Microsoft Office programs.

To enlarge the selected area to fill the window, click Selection.

Note  Zooming in or out does not affect printing. Sheets are printed at 100 percent unless you change the scaling on the Page tab of the Page Setup dialog box (File menu).

Do one of the following:

You can move around and zoom on your worksheet or chart sheet by using the Microsoft IntelliMouse pointing device. For information about changing options and viewing troubleshooting tips for the Microsoft IntelliMouse, see the IntelliPoint Online User's Guide. (Click the Microsoft Windows Start button, point to Programs, and then point to Microsoft Input Devices.)

To	Do this
Scroll up or down a few rows at a time	Rotate the wheel forward or back.
Pan through a worksheet	Hold down the wheel button, and drag the pointer away from the origin mark in the direction you want to scroll. To speed up scrolling, drag away from the origin mark; to slow down scrolling, drag toward the origin mark.
Pan through a worksheet automatically	Click the wheel button, and then move the mouse in the direction you want to scroll. To speed up scrolling, drag away from the origin mark; to slow down scrolling, drag toward the origin mark. To stop automatic scrolling, click any mouse button.
Zoom in or out	Hold down CTRL, and then rotate the IntelliMouse wheel forward or back.
Show detail in outlines	Point to a cell that summarizes data in the outline, hold down SHIFT, and then roll the wheel forward.
Hide detail in outlines	Point to any cell that contains detail data, hold down SHIFT, and then roll the wheel back.

Tip

1. On the Tools menu, click Customize.
2. Click the Toolbars tab.
3. Click New.
4. In the Toolbar name box, type the name you want, and then click OK.
5. Click the Commands tab.
6. Do one of the following:

   Add a button to the toolbar

   1. Click a category in the Categories box.
   2. Drag the command you want from the Commands box to the displayed toolbar.

   Add a built-in menu to the toolbar

   1. In the Categories box, click Built-in Menus.
   2. Drag the menu you want from the Commands box to the displayed toolbar.
7. When you have added all the buttons and menus you want, click Close.

1. Make sure the toolbar you want to change is visible.

   How?

   1. On the View menu, point to Toolbars.
   2. Do one of the following:
      • Click the toolbar you want to display.
      • To view more toolbars, click Customize. In the Customize dialog box, click the Toolbars tab, and then select the check box for the toolbar you want to display. Click Close.
2. Click the Toolbar Options arrow .
3. Point to Add or Remove Buttons, and then click Customize.
4. Click the Commands tab.
5. In the Categories box, click a category for the command you want the button to perform.
6. Drag the command or macro you want from the Commands box to the displayed toolbar.
7. On the Customize dialog box, click Close.

1. Display the toolbar that has the menu you want to add a command to: Click Customize on the Tools menu, click the Toolbars tab, select the check box for the toolbar, and then click Close.

2. On the Tools menu, click Customize, and then click the Commands tab.

3. In the Categories list, click the category for the command.

4. Drag the command you want from the Commands list over the menu you want to add it to.

5. When the menu displays a list of commands, point to where you want the command to appear, and then release the mouse button.

To correct your common typing errors automatically, you must specify the commonly-mistyped word in advance.

1. On the Tools menu, click AutoCorrect Options, and then click the AutoCorrect tab.

2. Make sure the Replace text as you type check box is selected.

3. In the Replace box, type the word you often mistype or misspell, for example, type usualy.

4. In the With box, type the correct spelling of the word, for example, type usually.

5. Click Add.

Note  If you save a long phrase or passage of text as an AutoCorrect entry, you can enter the text later by typing only a few letters. For example, you could type afd to enter "Aperture Film Distributors."

Select the text you want to reuse, copy it, click Autocorrect Options on the Tools menu, and then click the AutoCorrect tab. In the Replace box, type a unique sequence of characters, a sequence that you would not usually type in a workbook. Click in the With box, press CTRL+V to paste the copied text, and then click Add.

If the first few characters you type in a cell match an existing entry in that column, Microsoft Excel fills in the remaining characters for you. Excel completes only those entries that contain text or a combination of text and numbers; entries that contain only numbers, dates, or times are not completed.

• To accept the proposed entry, press ENTER. The completed entry exactly matches the pattern of uppercase and lowercase letters of the existing entries.

• To replace the automatically entered characters, continue typing.

• To delete the automatically entered characters, press BACKSPACE.

• To select from a list of entries already in the column, press ALT + DOWN ARROW, or right-click the cell and then click Pick from List on the shortcut menu.