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)
 
PrintPrint CloseClose

Copyright © 2001 - 2025 MJ Technologies, LLC.  All rights reserved.