Can number of columns/rows in worksheet be reduced from 256/65536 in Excel 2000?

[PinpointJimbo]

Was wondering if there was any way to have a worksheet smaller than 256x65536 cells in Excel 2000 - ?

Impetus for this is using a background image, which causes the file size to balloon when it tiles infinitely across & down the sheet. Hiding cells has no effect and there seems to be no way to tell Excel to only insert the background image once.

Cheers

 

[Tom Urtis]

Was wondering if there was any way to have a worksheet smaller than 256x65536 cells in Excel 2000 - ?

No., unless you use a version at or before Excel5 which had 16384 rows, but still a set number that could not be changed.

 

[PinpointJimbo]

Helpful to be able to rule it out. Many thanks.

 

[shemayisroel]

Is your question to recuce rows/columns for printing purposes?

 

[shemayisroel]

Not exactly what you want but you could reset the used range, see below

http://contextures.com/xlfaqApp.html#Unused

 

[PinpointJimbo]

No it's just to keep the file size to a minimum when using a background image
(Format|Sheet|Background)
My file is about 750kb without background images on sheets, but is closer to 20Mb when background images are used (and tiled) on each sheet. Was hoping there was a way to avoid making the file so overweight.

 

[dave3009]

Is this not more to do with the image you are using rather than the size of a sheet.

I'm using Excel 2007, I applied a small jpg as a background and got a small file size (24.4kb) I then applied a poster quality image and the file became 28.7Mb.

Only a thought

Regards


Dave

 

[PinpointJimbo]

Actually that is right on the money.
My image is essentially a gradient gif, blending from blue into white, down the sheet. At 1024x768 pixels, the image adds over 19Mb to the Excel file size, while the same gif, trimmed to a bare minimum width, causes the file to increase only by 160kb. Great idea. Thanks!