Hints and tips home » Excel hints and tips » edit and format multiple worksheets in one operation

edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

Added by Meenesh on 3rd October 2006

More Excel hints and tips, like:

• Number format shortcut
• ##### displaying in Excel
• Colouring cells containing formulas