how to stop scroll to column
how to stop scroll and use shortcut to fill all column ?
1 answers ( 0 marked as helpful)
Two Options :
1- Copy the original cell (ctrl+c) , then highlight the range in which u want to past the original copied cell (ctrl+down arrow till the x sign) _ u should mark the end of each column with an (x) sign so as to not to past the original cell down till end of the sheet _ , then stop at the cell below to the original cell and paste (ctrl+v) .
2- highlght the original cell that u want to copy , then double click the right low corner of it , so that it can be pasted in the below cells in the same column till the (x) sign .