Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I reposition a column on an excel spreadsheet

I want to move column J with data over to become column B. How to do this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default How do I reposition a column on an excel spreadsheet

Select Col J. Right clickCut
Select ColB. Right clickInsert Cut Cells

--
Jacob


"JonesALewis" wrote:

I want to move column J with data over to become column B. How to do this?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default How do I reposition a column on an excel spreadsheet

Jacob's was is a good way of doing it. Here is another. Highlight the column.
Hold down the Shift Key and Drag it to column B and Drop it. Note that when
you are holding the shift key and drag you get an I Beam to indicate where
you are about to drop the row. If you do not hold down the Shift key you do
not ge the I beam and instead XL shows you the column that you are about to
overwrite.
--
HTH...

Jim Thomlinson


"Jacob Skaria" wrote:

Select Col J. Right clickCut
Select ColB. Right clickInsert Cut Cells

--
Jacob


"JonesALewis" wrote:

I want to move column J with data over to become column B. How to do this?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default How do I reposition a column on an excel spreadsheet

Thanks Jim, I learned something new today.

rzink

"Jim Thomlinson" wrote:

Jacob's was is a good way of doing it. Here is another. Highlight the column.
Hold down the Shift Key and Drag it to column B and Drop it. Note that when
you are holding the shift key and drag you get an I Beam to indicate where
you are about to drop the row. If you do not hold down the Shift key you do
not ge the I beam and instead XL shows you the column that you are about to
overwrite.
--
HTH...

Jim Thomlinson


"Jacob Skaria" wrote:

Select Col J. Right clickCut
Select ColB. Right clickInsert Cut Cells

--
Jacob


"JonesALewis" wrote:

I want to move column J with data over to become column B. How to do this?

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
reposition user form Chad New Users to Excel 0 April 29th 08 09:49 PM
reposition windows amsterdam-quick Excel Discussion (Misc queries) 2 January 25th 08 08:42 PM
How can I reposition office clipboard mikeslostit Excel Discussion (Misc queries) 5 December 31st 07 04:38 PM
how to reposition the dataset from top to bottom in a column? arizona Excel Worksheet Functions 1 October 25th 06 02:47 AM
how to reposition a data table in chart JohnBonjer Charts and Charting in Excel 1 February 6th 06 11:12 AM


All times are GMT +1. The time now is 05:57 PM.

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

About Us

"It's about Microsoft Excel"