Shifting all cells in a worksheet

[Guest]

I need to shift all the cells to the left on a worksheet. When I go to delete
and choose to shift cells left. It only shifts the cells that I have
highlighted. How can I get all the cells to shift over so I can get
everything organized correctly?

 

[Bob I]

R-click header of Column A and pick Delete. Everything will move left
one column.

 

[James Silverton]

Cory wrote on Fri, 27 Apr 2007 09:40:02 -0700:

C> I need to shift all the cells to the left on a worksheet.
C> When I go to delete and choose to shift cells left. It only
C> shifts the cells that I have highlighted. How can I get all
C> the cells to shift over so I can get everything organized
C> correctly?

Perhaps, I don't understand the problem but I think I can do it
easily .

1. Go to the end of the data: CTRL-End
2. Go to the left: Home
3. Highlight sufficient columns to insert.
4. Insert columns.
5. Click leftmost used column letter
6. Shift-click last datum
7. Pull the columns over.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not