<div>
Did you check the Conditional Formatting rules?<br />
If you place data in one of these cells is it no longer grey?
</div>


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

Developer

Murray Brown

<div>
If columns were hidden you wouldn't see the headers for those columns.<br />
<br />
The sheet is in Page Break Preview mode. The Blue line indicates the Print Area.<br />
<br />
On the View tab there are numerous options on the left hand end.<br />
Normal - usual view with row and column headers, page break show as dotted line on the grid<br />
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<br />
Page Layout - Like a Print Preview, showing headers and footers etc.
</div>


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.

Senior Associate

Norie

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
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?<br />
<br />
Thanks<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/02_w06/1442909/Image1.JPG" target="_blank" title="Image1.JPG (95 KB)"><img alt="Image1.JPG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2020/02_w06/800_1442909/Image1.JPG" /></a>
</div>
</div>


Image1.JPG

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



Excel VBA Grey area where cells are unused

Act! (previously known as Sage ACT!) is a customer relationship management (CRM) software application which is used to keep track of client and prospect details in a single database that can be shared by multiple users. Act! features include contact, company and opportunity management, a calendar, communication tools, the ability to track prospective customers, "dashboards", reports, and the ability to synchronize data from other applications or other Act! users over the web.

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.