Replies

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.

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.

Wow! thanks everybody. I will try all these to see how they work.

Wow! thanks everybody. I will try all these to see how they work.

Great! That did it!
Thanks

Great! That did it!
Thanks

Thanks for the info.
When I went there and clicked the selection box next to Rows to Repeat at Top, I cntrl-clicked the 2 rows at the top, and it selected them all the way across the sheet. I hit Enter, then clicked OK, and it said “Print titles must be contiguous and complete rows or columns”. But it seems like they are.
Any ideas?
Thanks

Thanks for the info.
When I went there and clicked the selection box next to Rows to Repeat at Top, I cntrl-clicked the 2 rows at the top, and it selected them all the way across the sheet. I hit Enter, then clicked OK, and it said “Print titles must be contiguous and complete rows or columns”. But it seems like they are.
Any ideas?
Thanks

That did it! Thanks
By the way, any recommendations for a book or online tutorial on Excel?

That did it! Thanks
By the way, any recommendations for a book or online tutorial on Excel?