Working on Excel, Instead of typing the same in each column, how do I paste?

Question

I forgot the code. I am new to Excel. How do I make a vertical column all have the same word/number?

Answer 1

Set the first field in the column to your desired number (let's say that is A1. In the next field down, enter "=$A$1", then use the drag box to copy that information to each subsequent field.

Answer 2

That depends on what you want to copy
1) entire column or
2) a cell in the column

Answer
1) select the column letter you want to copy, then while your mouse is over the column right click and choose copy then, select the column where you wish to insert the column then, from the menu bar click insert.
2) select the cell you want to copy, while your mouse is still over the selected cell, right click and choose copy. The highlight of the cell will change to a broken highlight. Click on the cell where you want to make a copy. While your mouse is still over the cell right click and choose paste.

Hope this helps.

Answer 3

U could use a cell refference to do a sell refference it is easy u just do simular to the followint "(=a1)" or if u want it to be a constant cell then u put a $ sign in front like this "($a1). but if u want to use a formula with it u could do sumthin like =sum(a1*a2) or it's sum=($a1*a2) I forget which way it goes it's been a while since I've used it but anywhere u put the $ sign it becomes a constant cell and what ever is in there will change when u paste it unlike the refferencing without it.

Answer 4

Click the cell you want to copy. Press Ctrl + C.
Highlight all the cells you want to copy to. Press Ctrl + V.

OR

Click in the cell you want to copy. Put your cursor in the lower right hand corner of the cell. When the pointer turns to a + sign, left click and drag to all the cells you want to copy.

Answer 5

Highlight the top cell with the info, and all the cells below it that you wish to copy the info to. Then hit Control+D and it fills downward.

This way you don't have to copy and paste multiple times (or copy once and paste multiple times).

Answer 6

Copy, Paste Special, Values Only. Or paste as text only.

Answer 7

type the word/number in one cell then use the fill handle (the little square thing at the bottom right of the selected cell) to drag out the area you want to fill.

Answer 8

copy what's in the cell, highlight the cells you want the identical information in (left click hold and drag) and paste

Answer 9

G1 =INDEX(Sheet2!J:J, MATCH(F1,Sheet2!E:E,1))