software

How would you transfer all your data from one column into another column? Eg
from Column A to column B?Several ways come to mind.
1)copy and paste
2)insert a new column A
3) in B1 enter =A1 and copy down
I am not sure what you are trying to accomplish
quot;Wesselquot; wrote:

gt; How would you transfer all your data from one column into another column? Eg
gt; from Column A to column B?
gt;

quot;Transferquot; indicates to me that you want to move the data.

Cut and paste the entire column A to Column B

Copy and paste if you want data in A to remain.

Alternative to copy and paste would be to enter =A1 in B1 then
double-click on the fill handle to copy down.Gord Dibben MS Excel MVPOn Tue, 10 Jan 2006 12:31:05 -0800, Wessel
gt; wrote:

gt;How would you transfer all your data from one column into another column? Eg
gt;from Column A to column B?One way,
Click on the column header to select the whole column, next slide your
cursor just below the header until it changes back to the arrow, next hold
down the mouse button and drag the column where you want it.

HTH
JG

quot;Wesselquot; wrote:

gt; How would you transfer all your data from one column into another column? Eg
gt; from Column A to column B?
gt;

Thanks for your replys guys, I guess I should make myself more clear. What I
am trying to do is as follows: I have been letting each column represent a
day, and each cell a task I have been doing. So now I have about 10 columns
filled in. But to make the sheet more presentable, I want to insert blank
columns for Saturday and Sunday. (I don't work then!) So, how do I go back
and insert blank columns? Because, if I use the cut/copyamp;paste option, surely
I would just be dumping the data from one column onto another one? Unless, I
suppose, I start from the last column, which has nothing to the right of it,
cut and paste that a few places to the right, and then, working my way from
right to left, move each column a few spots to the right, until I have some
empty columns in the middle representing Sat Sun. But is there a more
efficient way? My eventual goal is to be able to make the computer do
whatever I want simply by snapping my fingers at it, so getting advice from
you guys is a first step in that direction.
quot;Ray Aquot; wrote:

gt; Several ways come to mind.
gt; 1)copy and paste
gt; 2)insert a new column A
gt; 3) in B1 enter =A1 and copy down
gt; I am not sure what you are trying to accomplish
gt;
gt;
gt;
gt; quot;Wesselquot; wrote:
gt;
gt; gt; How would you transfer all your data from one column into another column? Eg
gt; gt; from Column A to column B?
gt; gt;

Insertgt;Columns wherever you wish.

i.e. select column C amp; D and Insertgt;Columns to get two blank columns.Gord Dibben MS Excel MVP

On Wed, 11 Jan 2006 10:36:03 -0800, Wessel gt;
wrote:

gt;Thanks for your replys guys, I guess I should make myself more clear. What I
gt;am trying to do is as follows: I have been letting each column represent a
gt;day, and each cell a task I have been doing. So now I have about 10 columns
gt;filled in. But to make the sheet more presentable, I want to insert blank
gt;columns for Saturday and Sunday. (I don't work then!) So, how do I go back
gt;and insert blank columns? Because, if I use the cut/copyamp;paste option, surely
gt;I would just be dumping the data from one column onto another one? Unless, I
gt;suppose, I start from the last column, which has nothing to the right of it,
gt;cut and paste that a few places to the right, and then, working my way from
gt;right to left, move each column a few spots to the right, until I have some
gt;empty columns in the middle representing Sat Sun. But is there a more
gt;efficient way? My eventual goal is to be able to make the computer do
gt;whatever I want simply by snapping my fingers at it, so getting advice from
gt;you guys is a first step in that direction.
gt;quot;Ray Aquot; wrote:
gt;
gt;gt; Several ways come to mind.
gt;gt; 1)copy and paste
gt;gt; 2)insert a new column A
gt;gt; 3) in B1 enter =A1 and copy down
gt;gt; I am not sure what you are trying to accomplish
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Wesselquot; wrote:
gt;gt;
gt;gt; gt; How would you transfer all your data from one column into another column? Eg
gt;gt; gt; from Column A to column B?
gt;gt; gt;