ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to stop background from repeating (https://www.excelbanter.com/excel-discussion-misc-queries/102488-how-stop-background-repeating.html)

Steve

How to stop background from repeating
 
I added a background to an Excel spreadsheet. Unfortunately it repeats the
image all the way to the bottom of the worksheet, making a 30K document about
3MB in size. How can I have it only display the image once immediately behind
my content without repeating? If I cannot limit that, is there a way to force
the worksheet to be only 100 rows long and 15 columns wide, eliminating the
repetitive images simply by reducing the "physical" size of the worksheet?

exceluserforeman

How to stop background from repeating
 
Make the sheet a template

"Steve" wrote:

I added a background to an Excel spreadsheet. Unfortunately it repeats the
image all the way to the bottom of the worksheet, making a 30K document about
3MB in size. How can I have it only display the image once immediately behind
my content without repeating? If I cannot limit that, is there a way to force
the worksheet to be only 100 rows long and 15 columns wide, eliminating the
repetitive images simply by reducing the "physical" size of the worksheet?


Earl Kiosterud

How to stop background from repeating
 
The original poster doesn't show, so I'm replying to this reply.

The added size of the file doesn't have to do with the tiling (repeating) of
the background image). It's a function of the image size, uncompressed.
The compressed image file might only be 100K or so, but Excel apparently
saves the uncompressed (bitmap, or raster) image. Generally, that's the
width x the height, in pixels, times 3, in bytes. The only way to make that
smaller is to make the image smaller, in pixels. It will appear smaller on
the screen, since Excel seems to put background images on the sheet in
actual size (screen pixel for image pixel) -- you'll see that zooming in and
out doesn't change the size of the background image.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"exceluserforeman" wrote in
message ...
Make the sheet a template

"Steve" wrote:

I added a background to an Excel spreadsheet. Unfortunately it repeats
the
image all the way to the bottom of the worksheet, making a 30K document
about
3MB in size. How can I have it only display the image once immediately
behind
my content without repeating? If I cannot limit that, is there a way to
force
the worksheet to be only 100 rows long and 15 columns wide, eliminating
the
repetitive images simply by reducing the "physical" size of the
worksheet?





All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com