Replies

Wait! it seems like your procedure did work. But I don’t think step 8 is necessary. Just cntrl-clicking the sheets, going to File/page setup and clicking OK seems to be enough.

Wait! it seems like your procedure did work. But I don’t think step 8 is necessary. Just cntrl-clicking the sheets, going to File/page setup and clicking OK seems to be enough.

In step 8, Activate each tab, how do I do that? Once the Page Setup dialog comes up, clicking on the tabs has no effect.

In step 8, Activate each tab, how do I do that? Once the Page Setup dialog comes up, clicking on the tabs has no effect.

OK I got it now. Thanks for your help.

OK I got it now. Thanks for your help.

OK I see that going to the Print Preview button may be the problem. If I select all the sheets and instead go to File/Page Setup my changes are universal on all pages. The only problem is that I do not get to see the image and drag the margins where I want them, I have to enter them numerically. Or am I still missing something?

OK I see that going to the Print Preview button may be the problem. If I select all the sheets and instead go to File/Page Setup my changes are universal on all pages. The only problem is that I do not get to see the image and drag the margins where I want them, I have to enter them numerically. Or am I still missing something?

After hearing the comments here, I decided to look carefully to see if there was a user error. And it seems like there is. I did not realize that when you select multiple sheets and thereby create a group, that when you go to Print Preview for ANY of the sheets, you are actually still only formating for page 1 of the group. So when I was going to each tab of the group and saw that the format changes were there, I was actually looking at the first page every time, and the other pages were seen (unless I clicked the Next button) and not affected. A good clue is that at the bottom it says Page 1 of 4.
So my question now is how do I really select all sheets in order to make the formatting changes.

After hearing the comments here, I decided to look carefully to see if there was a user error. And it seems like there is. I did not realize that when you select multiple sheets and thereby create a group, that when you go to Print Preview for ANY of the sheets, you are actually still only formating for page 1 of the group. So when I was going to each tab of the group and saw that the format changes were there, I was actually looking at the first page every time, and the other pages were seen (unless I clicked the Next button) and not affected. A good clue is that at the bottom it says Page 1 of 4.
So my question now is how do I really select all sheets in order to make the formatting changes.

OK will do. I’ll report back if I find the problem.
Thanks for the help.

OK will do. I’ll report back if I find the problem.
Thanks for the help.

I did as you suggested, created a new workbook. Same thing. The formatting changes to the rest of the sheets in the Group are lost as soon as I de-select the Group.

I did as you suggested, created a new workbook. Same thing. The formatting changes to the rest of the sheets in the Group are lost as soon as I de-select the Group.

I tried it again, something strange is going on. I decided to test using something simple, I chose Center Horizontally. When I started, sheet A and sheet B were both left justified when viewed in Print Preview. I select both sheets by cntrl clicking on their tabs, they both turned white. I went into Print preview/setup/margins for sheet A and checked Center Horizontally. Print Preview now showed both sheets centered. Then I clicked on the tab for another sheet and therefore de-selected A and B as a Group. When I went and looked again at Print Preview for A and B, Sheet A was still centered, but Sheet B went back to being left justified. The change only seemed to affect both sheets as long as they remained both selected, as a Group.