-
Vincenzo
AskWoody LoungerOK will do. I’ll report back if I find the problem.
Thanks for the help. -
Vincenzo
AskWoody LoungerI 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.
-
Vincenzo
AskWoody LoungerI 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.
-
Vincenzo
AskWoody LoungerI 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.
-
Vincenzo
AskWoody LoungerI 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.
-
Vincenzo
AskWoody LoungerWow! thanks everybody. I will try all these to see how they work.
-
Vincenzo
AskWoody LoungerWow! thanks everybody. I will try all these to see how they work.
-
Vincenzo
AskWoody LoungerGreat! That did it!
Thanks -
Vincenzo
AskWoody LoungerGreat! That did it!
Thanks -
Vincenzo
AskWoody LoungerThanks 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 -
Vincenzo
AskWoody LoungerThanks 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 -
Vincenzo
AskWoody LoungerThat did it! Thanks
By the way, any recommendations for a book or online tutorial on Excel? -
Vincenzo
AskWoody LoungerThat did it! Thanks
By the way, any recommendations for a book or online tutorial on Excel?
![]() |
Patch reliability is unclear, but widespread attacks make patching prudent. Go ahead and patch, but watch out for potential problems. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Do I need these C++ updates ?
by
Alex5723
3 minutes ago -
Woman in front of 2 mirrors. One shot 2 different reflections
by
Alex5723
10 hours, 21 minutes ago -
Steam drops macOS Mojave support, effectively ending life for many 32-bit games
by
Alex5723
12 hours, 8 minutes ago -
Requiring Bit-Locker key when it isnt activated after Win 11 update
by
BradH
7 hours, 37 minutes ago -
KB5032189 Not installing on either of my PCs
by
WSPseudoGeek
2 hours, 30 minutes ago -
Outlook.com – is there a way to delete all contacts in bulk?
by
Everard Tarascio
19 hours, 2 minutes ago -
Apple zero days fixed – November 30, 2023
by
Susan Bradley
5 hours, 16 minutes ago -
found a skneaky way to get windows 11 free still.
by
tjm1963
23 hours, 40 minutes ago -
Quickbooks – no new desktop subscriptions to be sold
by
Susan Bradley
1 day, 2 hours ago -
Does updating to Win10 from Win7 Retain your applications successfully?
by
WSMrKnobs
1 day ago -
Using Dropbox source data for a Connection in Excel with different machines
by
WSGfamily
1 day, 3 hours ago -
Microsoft installing HP Smart secretly on non HP PCs
by
Alex5723
1 day, 2 hours ago -
Fun Stuff – Mystery Zone
by
Lars220
1 day, 16 hours ago -
How to make sure GMAIL does not delete my account since they are not letting ..?
by
Gmail
15 hours, 6 minutes ago -
Windows Explorer – search for files that are not shortcuts?
by
edsel1924
1 day, 11 hours ago -
Windows 11 Insider Preview build 23595 released to DEV
by
joep517
1 day, 23 hours ago -
Windows 11 Insider Preview build 26002 released to Canary
by
joep517
1 day, 1 hour ago -
Windows 11 Insider Preview Build 22635.2776 released to BETA
by
joep517
1 day, 23 hours ago -
Getting ‘not genuine Windows’ after replacing HDD
by
opti1
1 day, 5 hours ago -
Amazon Alexa Echo Hunches
by
Richard C Algeni
2 days ago -
Microsoft Defender Application Guard for Office is being deprecated
by
Alex5723
2 days, 1 hour ago -
New BLUFFS attack lets attackers hijack Bluetooth connections
by
Alex5723
2 days, 2 hours ago -
Don’t have your online identity in just one account
by
Susan Bradley
4 hours, 8 minutes ago -
Sports Illustrated Published Articles by Fake, AI-Generated Writers
by
Cybertooth
1 day, 21 hours ago -
Windows 32bit to 64bit.
by
David Rennie
1 day, 4 hours ago -
Lost icons in notification area, Windows 10
by
Botswana12
6 hours, 47 minutes ago -
Test Apps in vm(?) so that I don’t break my current install
by
ruffhi
22 hours, 54 minutes ago -
Removing Copilot
by
cmar6
5 hours, 28 minutes ago -
How do I disable CoPilot
by
Rush2112
2 days, 1 hour ago -
MS-DEFCON 3: A slightly bumpy November
by
Susan Bradley
26 minutes ago
Recent blog posts
Key Links
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2023 by AskWoody Tech LLC. All Rights Reserved.