Removed content in right columns and limited size of spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rosebud3377 - 15 Nov 2007 19:35 GMT

I was trying to get rid of the contents in the columns to the right of my
spreadsheet and instead I accidently deleted everything to the right (area is
now grey). Now I can't insert new columns because I have limited the size of
the spreadsheet. How can I recover columns to the right? I can't just click
undo because I have saved and gone out of the spreadsheet.

Reply to this Message

Bernard Liengme - 15 Nov 2007 19:41 GMT

The data in deleted columns is lost
I do not understand how you think you have limited the size of the worksheet
That is not possible
tell us more
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

>I was trying to get rid of the contents in the columns to the right of my
> spreadsheet and instead I accidently deleted everything to the right (area
[quoted text clipped - 4 lines]
> click
> undo because I have saved and gone out of the spreadsheet.

Reply to this Message

Gord Dibben - 15 Nov 2007 21:40 GMT

Sounds like you hid the columns.

CTRL + a(twice in 2003) to select all.

Right-click on a column header and "Unhide"

Gord Dibben MS Excel MVP

>I was trying to get rid of the contents in the columns to the right of my
>spreadsheet and instead I accidently deleted everything to the right (area is
>now grey). Now I can't insert new columns because I have limited the size of
>the spreadsheet. How can I recover columns to the right? I can't just click
>undo because I have saved and gone out of the spreadsheet.

Reply to this Message