View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default 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?