+ Reply to Thread
Results 1 to 4 of 4

Deleting unwanted colums on a worksheet

  1. #1
    fraugfreak
    Guest

    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.

  2. #2
    Don Guillett
    Guest

    Re: 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 label>hold
    the shift key>goto the last to delete>touch the delete key>save.

    You may then hide the columns

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "fraugfreak" <[email protected]> wrote in message
    news:[email protected]...
    >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.




  3. #3
    fraugfreak
    Guest

    Re: 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 label>hold
    > the shift key>goto the last to delete>touch the delete key>save.
    >
    > You may then hide the columns
    >
    > --
    > Don Guillett
    > SalesAid Software
    > [email protected]
    > "fraugfreak" <[email protected]> wrote in message
    > news:[email protected]...
    > >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.

    >
    >
    >


  4. #4
    Don Guillett
    Guest

    Re: 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
    [email protected]
    "fraugfreak" <[email protected]> wrote in message
    news:[email protected]...
    > 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
    >> label>hold
    >> the shift key>goto the last to delete>touch the delete key>save.
    >>
    >> You may then hide the columns
    >>
    >> --
    >> Don Guillett
    >> SalesAid Software
    >> [email protected]
    >> "fraugfreak" <[email protected]> wrote in message
    >> news:[email protected]...
    >> >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.

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1