Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shifting of data to fill into blank cells | Excel Discussion (Misc queries) | |||
Shifting the contents of cells | Setting up and Configuration of Excel | |||
Deleting and shifting cells and columns | Excel Worksheet Functions | |||
Deleting cells and shifting "right" | Excel Discussion (Misc queries) | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |