Remove Columns

[AlexanderBB]

One of my worksheets stops at column "Z" and there's nothing to the right of it.
How did I do this ? Can't remember and can't find how from Google.
Thanks.

 

[eduzs]

Click in the box between "1" row and "A" column to select entire worksheet, right click "A" column label and select "Show/Reshow/Unhide" (sorry my version is not EN) menu.

 

[DanteAmor]

Maybe you hide the columns, then select all the cells, select a column and select show.
Maybe you changed the width of columns. Select all the cells, change the column width to 10.

 

[AlexanderBB]

I don't think it's Hide/Unhide. There's just nothing to the right of Col Z and nowhere to click & Unhide (if it were hidden).
Rather its somehow limited the number of Columns in the worksheet. You can't scroll horizontally past Z, whereas Excl normally will keep going.

 

[DanteAmor]

I don't think it's Hide/Unhide. There's just nothing to the right of Col Z and nowhere to click & Unhide (if it were hidden).
Rather its somehow limited the number of Columns in the worksheet. You can't scroll horizontally past Z, whereas Excl normally will keep going.

You tried the way to show?

 

[eduzs]

ALT+F11
On the immediate window (down side of the screen) type:
range("a:xfd").entirecolumn.hidden=false
and Enter.

 

[AlexanderBB]

> You tried the way to show?
Not sure how to try that, there's nothing hidden to show.
If I delete any columns, "Z" changes to "Y" and Y is the last one.
It's quite good this way, the worksheet remains the size wanted. Someone must have told me how to do it..

 

[AlexanderBB]

Also there is no row Heading past the last column.
This isn't a set "scroll area" and doesn't changed when saved/closed.

 

[eduzs]

I suppose you are not following the above suggestions to try a possible solution.

 

[DanteAmor]

> You tried the way to show?
Not sure how to try that, there's nothing hidden to show.
If I delete any columns, "Z" changes to "Y" and Y is the last one.
It's quite good this way, the worksheet remains the size wanted. Someone must have told me how to do it..

Select all the cells, select any column, for examlple column "A" from pop up menu select show.