Excel Tip of the Day
Quickly add several sheets to an Excel workbook (97/2000/2001/2002)
If you need to add worksheets to an Excel file, chances are that you use the Insert | Worksheet menu command. There's a much faster way to go about this task: simply press [Shift][F11] and Excel adds a new blank worksheet before whichever sheet you were working on at the time. If you need to add several worksheets to a workbook, you can use either technique to create all of the sheets at once. While holding down the [Shift] key, click on the same number of worksheet tabs as new sheets you want to create. Then, use either the menu command or shortcut key as you normally would.
(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.