Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Excel VBA Grey area where cells are unused

Hi

I have a client spreadsheet where unused cells to the right are automatically grey. What causes this and how would I set up and additional sheet to act like this?

Thanks

Image1.JPG
ACTVBAMicrosoft Excel

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
Darrell Porter

Did you check the Conditional Formatting rules?
If you place data in one of these cells is it no longer grey?
ASKER CERTIFIED SOLUTION
Norie

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Murray Brown

ASKER
Thanks very much
Rob Henson

If columns were hidden you wouldn't see the headers for those columns.

The sheet is in Page Break Preview mode. The Blue line indicates the Print Area.

On the View tab there are numerous options on the left hand end.
Normal - usual view with row and column headers, page break show as dotted line on the grid
Page Break Preview - Outside of the Print Area is greyed out, the page breaks show as blue lines, dotted for an automatic break, solid for a manual break. The blue lines can be dragged around to change the page breaks
Page Layout - Like a Print Preview, showing headers and footers etc.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck