Solved

Is it possible to change the background colour outside of the print range within Excel in page break preview?

Posted on 2013-01-09
4
760 Views
Last Modified: 2013-01-09
An Excel template is opened by several users.
The template is saved in page break view so that the document to be printed is clearly presented.

I have added other detail outside of the print area and used contrasting colours to the grey background.
This works fine for most users of the template.
One or two users however have difficulty reading this detail because the background isn't very dark.

I have tried adjusting brightness and contrast on their monitor to no avail.

Is there any settings in Windows or Excel that I can adjust to change the background colour? (Win7/XP)
0
Comment
Question by:spar-kle
  • 2
4 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 38758483
can you post a sample of what you are talking about to understand your problem as not too clear ?
gowflow
0
 

Author Comment

by:spar-kle
ID: 38758538
I hope this demonstrates
Sample.xlsx
0
 
LVL 16

Accepted Solution

by:
terencino earned 500 total points
ID: 38758609
I don't think you can change the dark gray off-print section. A couple of options:
1. Used a text box instead
2.Put the information on another sheet, copy it, then Paste Special > Picture Link. If they double-click it will go to the source range on the other sheet
Hope that helps
...Terry
0
 

Author Closing Comment

by:spar-kle
ID: 38759423
Thanks for your help
Des
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question