Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Saturday, May 17, 2008 – Permalink –

Enter in Multiple WorkSheets

Group sheets


A common use for Excel is to keep periodic statistics; sales by quarter, or phone calls per month.

It can be tedious to try to create worksheets for each month and include duplicate data such as client or salesperson's names.

Set up the workbook with as many worksheets that may be needed; perhaps one for each month and one for cumulative year-end totals.

Click the tab for the first month, hold down the SHIFT key and select the last worksheet in the series.

All the sheets are now chosen. You will see [Group] on the Title bar.

Enter any common information on the first sheet and it will be duplicated on all of the grouped sheets.

When you are done, Right-click a sheet tab and choose Ungroup Sheets on the context menu.

Non-contiguous sheets can be selected using the Ctrl key.

If the sheets are grouped, they will all be printed together.

Also:


John Walkenbach:
Making an exact copy of a range of formulas

Microsoft KB:
Run a macro on multiple sheets in Group mode



See all Topics

Labels: , , ,


<Doug Klippert@ 7:51 AM

Comments: Post a Comment