How to stop background from repeating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top