Page Break Preview

[ChrisHockley]

I realize the page break preview is used for just that... however I like the clean layout that it creates in my document where the data is shown in typical Excel format but with a clean, grey background around it. Can you create this look easily in Normal View? I can easily remove the gridlines... is the grey that's besting me.

 

[Krayna]

Apparently this is an option (found here):
Create a small rectangle that matches the color you want used for your background. Save the small rectangle as a graphics file, using the PNG file format. Then, within Excel, follow these steps:

1. Display the Page Layout tab of the ribbon.
2. Click the Background tool, in the Page Setup group. Excel 2007 and Excel 2010 display the Sheet Background dialog box. In Excel 2013 and later versions you see the Insert Pictures screen in which you should click the Browse link at the right of the From a File option. You'll then see the Sheet Background dialog box.

Hope that helps Chris!

 

[ChrisHockley]

Apparently this is an option (found here):
Create a small rectangle that matches the color you want used for your background. Save the small rectangle as a graphics file, using the PNG file format. Then, within Excel, follow these steps:

1. Display the Page Layout tab of the ribbon.
2. Click the Background tool, in the Page Setup group. Excel 2007 and Excel 2010 display the Sheet Background dialog box. In Excel 2013 and later versions you see the Insert Pictures screen in which you should click the Browse link at the right of the From a File option. You'll then see the Sheet Background dialog box.

Hope that helps Chris!

This worked perfectly! Thank you.