Last answered:

05 Mar 2023

Posted on:

13 Nov 2022

1

how to stop scroll to column

how to stop scroll and use shortcut to fill all column ?

1 answers ( 0 marked as helpful)
Posted on:

05 Mar 2023

0

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 .

Submit an answer