Print thru using EXCEL 2007

  • Thread starter Thread starter pcor
  • Start date Start date
P

pcor

I am inputting data in sheet 1 col A to G
I want that same info to "PRINT THRU" to Sheets 2 and 3. Can you tell me how?
Thanks
 
Before you start "inputting", click on the Sheet1 tab, hold down <Shift> and
click on the Sheet3 tab.

This groups the sheets.
Anything done to one, will be done to *all* in the group.

When finished, don't forget to separate them.
Right click in a tab and choose "Ungroup".
 
That works very well thank you.
Now here is another..Is there a way to change the background color of the
sheets once they have been "Grouped" and returned to their original color
once they are "UNGROUPED"
Thanks
 
I don't know how.
You might be able to do that with code.
Post to the programming group.

You do have 2 notifications of "grouping" though:

In the Title Bar, after the WB name, "GROUP" is displayed,
And the sheet tabs are all white.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

That works very well thank you.
Now here is another..Is there a way to change the background color of the
sheets once they have been "Grouped" and returned to their original color
once they are "UNGROUPED"
Thanks
 
pcor said:
That works very well thank you.
Now here is another..Is there a way to change the background color of the
sheets once they have been "Grouped" and returned to their original color
once they are "UNGROUPED"
Thanks
Click to expand...

If you just want to know if sheets are grouped or not notice that the
tabs turn white when sheets are grouped.

gls858
 
Back
Top