ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Deleting unwanted colums on a worksheet (https://www.excelbanter.com/excel-worksheet-functions/82498-deleting-unwanted-colums-worksheet.html)

fraugfreak

Deleting unwanted colums on a worksheet
 
I need to know how to delete unwanted coulums on a worksheet. I remember
being taught this in school 10 years ago but i guess its been pushed out of
my memory after all this time. All the extra colums are slowing down our
programs. any help would be appreciated.

Don Guillett

Deleting unwanted colums on a worksheet
 
You cannot "delete" columns. Perhaps they are formatted so you should select
all of the unwanted columns by putting the cursor on the column labelhold
the shift keygoto the last to deletetouch the delete keysave.

You may then hide the columns

--
Don Guillett
SalesAid Software

"fraugfreak" wrote in message
...
I need to know how to delete unwanted coulums on a worksheet. I remember
being taught this in school 10 years ago but i guess its been pushed out
of
my memory after all this time. All the extra colums are slowing down our
programs. any help would be appreciated.




fraugfreak

Deleting unwanted colums on a worksheet
 
Thanks for the info!!! however when i try to do this its giving me an error
"Cannot shift objects off sheet". Any suggestions as to what this means???

"Don Guillett" wrote:

You cannot "delete" columns. Perhaps they are formatted so you should select
all of the unwanted columns by putting the cursor on the column labelhold
the shift keygoto the last to deletetouch the delete keysave.

You may then hide the columns

--
Don Guillett
SalesAid Software

"fraugfreak" wrote in message
...
I need to know how to delete unwanted coulums on a worksheet. I remember
being taught this in school 10 years ago but i guess its been pushed out
of
my memory after all this time. All the extra colums are slowing down our
programs. any help would be appreciated.





Don Guillett

Deleting unwanted colums on a worksheet
 
You should only get that if you were trying to insert columns where there
may be something in the last column.
Use ctrl+end to find the last.

--
Don Guillett
SalesAid Software

"fraugfreak" wrote in message
...
Thanks for the info!!! however when i try to do this its giving me an
error
"Cannot shift objects off sheet". Any suggestions as to what this
means???

"Don Guillett" wrote:

You cannot "delete" columns. Perhaps they are formatted so you should
select
all of the unwanted columns by putting the cursor on the column
labelhold
the shift keygoto the last to deletetouch the delete keysave.

You may then hide the columns

--
Don Guillett
SalesAid Software

"fraugfreak" wrote in message
...
I need to know how to delete unwanted coulums on a worksheet. I
remember
being taught this in school 10 years ago but i guess its been pushed
out
of
my memory after all this time. All the extra colums are slowing down
our
programs. any help would be appreciated.








All times are GMT +1. The time now is 06:10 AM.

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