Microsoft Excel 2003 hiding cell storage.

[gtr]

Hello everyone,

I'm working on a huge shipment spreadsheet and while printing i would like to hide numberous columns but, Microsoft Excel 2003 runs out of columns to hide!

Is there a command to allow more memory to store the hidden columns. Or is there a limit Microsoft has set and is unavoidable? Sort of like Outlook 2000's 2gig limit?

Thanks,

[bruceb]

One way would be to make a duplicate of the file spreadsheet
and then Delete the Columns you don't want to print.

Then print it out.

Since it's a duplicate or copy of the original file, your
original with all the data will still be intact.

[gtr]

I can't do that because it's a total sum at the end.:(

[rraehal]

You could copy the total column and in the copied spreadsheet use "Paste Special -> Values" instead of paste to keep the summary total.

You could also make a second tab in Excel and point the columns in tab 2 to the colums in tab 1 that you want to print. This would allow you to set up a printable template once and then print from tab 2 after changing tab 1.

=sheet1!A1 would copy the first tabs contents exactly. (or =sheet1!$A$1 for absolute reference that do not change on cut and paste operations.)

[ScaryBinary]

Can you just set the column widths to a really small number instead of hiding them?

[gtr]

Actually they are already small columns but i have so many based on one column per shipment quanity and there are so many shipments.

I guess i can't get around it since microsoft design the column hiding with a memory limit. I wish they would increase that size and perhaps the next office would do the trick?

Thanks anyways for everyone suggestions.