Number 233 - September 2002

EXCEL Filling In Multiple Excel Worksheets
Office Tips edited by John Heenan, NOCCC - July 08, 2002
Issue 3.02 discussed how to enter the same value into multiple sheets in an Excel workbook. To do this, you hold down Ctrl and click one or more additional worksheet tabs. Now, if you go to Sheet 1 and enter something into cell A1, that value will appear in cell A1 on every selected sheet.	A word of caution: Make sure you deselect the multiple sheets within your workbook. It's all too easy to save your work with the tabs still selected. When you next open it, you could accidentally overwrite stuff all over the place!"
Number 233 - September 2002