2006-06-14 04:21:39 · 6 answers · asked by Journeyedgrl 2 in Computers & Internet ➔ Software
If you want to just paste the values, you can copy the first column, and then move to the second column, and go to Edit, then paste special, and select "values". If you want to copy formats, select "formats", etc.
2006-06-14 04:26:40 · answer #1 · answered by SVS 1 · 1⤊ 0⤋
Copy the column, then highlight the new column then click on "paste special" in the edit menu. One of your options is content w/o formulas or formatting. That should get you just the data.
2006-06-14 11:27:44 · answer #2 · answered by macTard 3 · 0⤊ 0⤋
copy the column and then do a paste special values to the new column
2006-06-14 11:27:13 · answer #3 · answered by Interested Dude 7 · 0⤊ 0⤋
Highlight the column you wish to repeat.
Select "EDIT", "COPY".
Place cursor in first cell of new column.
Select "EDIT", "PASTE SPECIAL", "VALUES".
This will put the numbers without formulas into the new column.
2006-06-14 11:45:36 · answer #4 · answered by Anonymous · 0⤊ 0⤋
i don't know abt exactly copying but why don't u shift the columns by either inserting new columns to shift the columns to right or by simply deleting the whole column if u want to move to left. inserting deleting is very easy just right click on any cell and u have the option to insert.... delet the cloumns, rows etc
2006-06-14 11:25:51 · answer #5 · answered by gr8_steph 2 · 0⤊ 0⤋
Look for a little square at the bottom-right edge of each box.Click,hold on it and drag.The formula in it gets copied.Its contents get copied.If I helped,please give me 10 points.
2006-06-14 11:26:05 · answer #6 · answered by eminem197796 3 · 0⤊ 0⤋