Shifting all cells in a worksheet
 

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?

Shifting all cells in a worksheet
 

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

Cory wrote:

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?

Shifting all cells in a worksheet
 

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