View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default 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