Microsoft Excel contains features that make software accessible (accessibility: The quality of a given system of hardware or software that makes it usable by people with one or more physical disabilities, such as restricted mobility, blindness, or deafness.) to a wider range of users, including those who have limited dexterity, low vision, or other disabilities.
Show or hide shortcut keys in ScreenTips
- On the Tools menu, click Customize.
- Click the Options tab.
- Under Other, select or clear the Show ScreenTips on toolbars check box.
Note Changing this setting affects all of your Microsoft Office programs.
Get more information about keyboard shortcuts.
Change text size and color
Zoom the display in or out
In the Zoom box , click the size you want, or enter a number from 10 to 400.
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).
Make toolbar buttons or drop-down list boxes larger
Zoom by using the Microsoft Intellimouse pointing device
Some mouse devices and other pointing devices, such as the Microsoft IntelliMouse pointing device, have built-in scrolling and zooming capabilities that you can use to move around and zoom in or out on your worksheet or chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.). For more information, see the instructions for your pointing device.
|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 (outline: Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.)
||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.
If you use the Microsoft IntelliMouse pointing device to zoom more often than you use it to scroll on a sheet, you can set the wheel button to zoom instead of scroll. On the Tools menu, click Options, click the General tab, and then select the Zoom on roll with IntelliMouse check box.
Customize toolbars and menus
Create a toolbar
- On the Tools menu, click Customize.
- Click the Toolbars tab.
- Click New.
- In the Toolbar name box, type the name you want, and then click OK.
- Click the Commands tab.
- Do one of the following:
Add a button to the toolbar
- Click a category in the Categories box.
- Drag the command you want from the Commands box to the displayed toolbar.
Add a built-in menu to the toolbar
- In the Categories box, click Built-in Menus.
- Drag the menu you want from the Commands box to the displayed toolbar.
- When you have added all the buttons and menus you want, click Close.
Add a button to a toolbar
Add a command to a menu
- 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.
- On the Tools menu, click Customize, and then click the Commands tab.
- In the Categories list, click the category for the command.
- Drag the command you want from the Commands list over the menu you want to add it to.
- When the menu displays a list of commands, point to where you want the command to appear, and then release the mouse button.
Automate entering and editing
Correct spelling and typing errors as you type
To correct your common typing errors automatically, you must specify the commonly-mistyped word in advance.
- On the Tools menu, click AutoCorrect Options, and then click the AutoCorrect tab.
- Make sure the Replace text as you type check box is selected.
- In the Replace box, type the word you often mistype or misspell, for example, type usualy.
- In the With box, type the correct spelling of the word, for example, type usually.
- 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.
Quickly fill in repeated entries in a column
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.