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
|