Free counters!

 

Header_top
Editing the Same Cell in Several Sheets?
Often all worksheets in a workbook will have the same structure - And you need to update them all at once.

Often all worksheets in a workbook will have the same structure. Imagine you are logging data every hour each day. Each worksheet contains a day's data, and there are seven sheets in a workbook.

The sheets all have the same number of rows and columns (Time, Channel 1, Channel 2, etc). In a situation like this it is easy to simultaneously modify a particular cell in each worksheet:

1.

Select all the worksheets in a workbook: right-click a sheet tab then click "Select All Sheets" on the shortcut menu. Excel shows [Group] in its title bar.  

Select Multiple Sheets

Group Selected
Group Selection

2. Make your changes to one of the worksheets. The changes are automatically made on every other sheet selected as well.
3. De-select the worksheets by moving to one of the other sheets.
   
 
The changes you made on the first sheet will be made on all selected sheets.
Bottom_Border