MS Excel Question > General Discussion

Posted: 5/15/2007 8:14:05 AM EDT

Howdy all, I'm having some trouble figuring out how to get rid of something in Excel. Right now I have a spreadsheet that covers from A1 to A48 vertically and A1 to CD1 horizontally.

For some reason, Excel allows me to scroll right (not by clicking the -> arrow on the scroll bar, but physically grabbing the scroll button and moving it) all the way to CO1. Is there some way to truncate this extra white space so I don't have the option of scrolling to it anymore? It's driving me nuts.

Posted: 5/15/2007 8:18:46 AM EDT

[#1]

Hide the blank cells when you don't want to look at them.

Posted: 5/15/2007 8:21:39 AM EDT

[#2]

You may have put a space in one of the boxes so it thinks that there is some info in a box near CO. try selecting all of the whitespace and hitting the delete button

Actually i just tried that and it didnt do anything so sorry. im no help

Posted: 5/15/2007 8:32:57 AM EDT

[#3]

Anyone?

Posted: 5/15/2007 8:40:49 AM EDT

[#4]

Click on the header of CE1, hold down shift + cntl, and hit the right arrow. This will highlight every column to the far right side of the page. Right click, and hit delete. This should do it.

If not, highlight everything you want, copy, and paste into a new sheet.

Posted: 5/15/2007 9:16:20 AM EDT

[#5]

Quoted:
Click on the header of CE1, hold down shift + cntl, and hit the right arrow. This will highlight every column to the far right side of the page. Right click, and hit delete. This should do it.

If not, highlight everything you want, copy, and paste into a new sheet.

1st idea didn't work.

2nd idea made all my macros become broken.

Anyone else have any ideas?

Posted: 5/15/2007 9:19:31 AM EDT

[#6]

select all columns to right of your last column, as mentioned above, then Format->Column->Hide

Posted: 5/15/2007 10:58:18 AM EDT

[#7]

Quoted:
select all columns to right of your last column, as mentioned above, then Format->Column->Hide

I still would to be able to add information into these columns at a later date though without having to unhide and hide them continually.

Posted: 5/15/2007 11:11:16 AM EDT

[#8]

Did you try deleting the columns, saving the file, closing Excel and then re-opening the file?

ETA - Make sure when you save it before closing it that you don't have a cell in the far right selected. Select cell A-1 before saving to be sure.

Warning

Confirm Action

[ARCHIVED THREAD] - MS Excel Question

[ARCHIVED THREAD] - MS Excel Question