Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
shifting of data to fill into blank cells tikchye_oldLearner57 Excel Discussion (Misc queries) 6 April 11th 07 11:02 PM
Shifting the contents of cells MTC Setting up and Configuration of Excel 1 August 1st 06 12:10 PM
Deleting and shifting cells and columns Curt1521 Excel Worksheet Functions 7 May 8th 06 04:14 PM
Deleting cells and shifting "right" CDWhite Excel Discussion (Misc queries) 5 April 15th 06 02:50 AM
stop excel from shifting cells up when a query returns no data DrLostinExcel Excel Worksheet Functions 2 November 9th 04 06:44 PM


All times are GMT +1. The time now is 07:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"