Page 81 - Excel Timesaving Techniques for Dummies

14_574272 ch12.qxd 10/1/04 10:38 PM Page 66
66
Technique 12: Data Entry Tricks
this worksheet contains exactly the same headings
that I entered in Sheet1. (Refer to Figure 12-5.) The
only difference between the two screen shots is that,
before taking Figure 12-6, I had the good sense to
stop and save the workbook so that there was no
danger that I could lose this data and have to go
through this Group editing procedure again.

Selecting another worksheet while in Group
mode immediately deselects all but the new
active worksheet and switches you back into
normal, single-sheet editing mode. Therefore,
don’t stop to check the entries on another
sheet until you’ve completed all the common
data entry, at which time you can ungroup the
sheets (by right-clicking a sheet tab in the
group and selecting Ungroup Sheets). Then • Figure 12-6: Sheet10 now contains the same entries that I
select the individual sheets to display their made in Sheet1 (refer to Figure 12-5) thanks
data by selecting their sheet tabs. to Group editing.