ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Removed content in right columns and limited size of spreadsheet (https://www.excelbanter.com/new-users-excel/166223-removed-content-right-columns-limited-size-spreadsheet.html)

rosebud3377

Removed content in right columns and limited size of spreadsheet
 
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.

Bernard Liengme

Removed content in right columns and limited size of spreadsheet
 
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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rosebud3377" wrote in message
...
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.




Gord Dibben

Removed content in right columns and limited size of spreadsheet
 
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

On Thu, 15 Nov 2007 11:35:01 -0800, rosebud3377
wrote:

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.




All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com