Ask Your Question

combination of keys

asked 2017-08-27 15:39:42 +0200

dimzev gravatar image

In Columns A, B,D,F there are 3562 entries while and the column C is empty. How can I use the combination of keys to select all column C cells ... up to 3562 line to be able to copy a command?

edit retag flag offensive close merge delete


"... to copy a command" Do you mean that you have formula in C2 and want quickly copy it to all other cells of column (C3:C3562)?

JohnSUN gravatar imageJohnSUN ( 2017-08-27 17:18:41 +0200 )edit

yes i want copy the formule quiqly from C2 to C3562

dimzev gravatar imagedimzev ( 2017-08-28 09:24:02 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-08-28 10:34:48 +0200

JohnSUN gravatar image

Create formula in cell C2, select this cell and double-click small black dot (square) in bottom-right corner of cell (mouse cursor will change to "crosshair"). If previous (or next) column not contain empty cells then formula will be filled until last row.


If you don't want to use mouse then you can press Shift+Ctrl+T - cursor will moved to "Name Box" where you can write range address with keyboard. When you press Enter range will be selected


Small tip. If you select two cells in column C before pressing Shift+Ctrl+T (for example C2:C3) then in Name Box you will have "template" of address - write with the keyboard will have less

edit flag offensive delete link more


thank you my friend !!! very usefull your help!!! thank you

dimzev gravatar imagedimzev ( 2017-08-28 11:39:12 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-27 15:39:42 +0200

Seen: 53 times

Last updated: Aug 28 '17