Excel Tip of the Day
Spell check all sheets in a workbook at once (Excel 97/2000/2001/2002)
If a workbook contains several sheets, you probably spell check each sheet individually. However, you don't have to.
If you'd like to spell check an entire workbook, first right-click on any sheet tab ([control]-click in Excel 2001), and then choose Select All Sheets from the resulting shortcut menu. To spell check specific sheets, hold down the [Ctrl] key and click on the appropriate sheet tabs, or hold down the [Shift] key to select a block of adjacent worksheets.
After you've made your selection, simply press [F7] to launch the spell checker.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.