Register now or log in to join your professional community.
by using auto fill
or copy and select then press enter
or use both formulas IF and ISBLANK
The below link provide correct answer.
https://www.ablebits.com/office-addins-blog/2014/05/02/fill-blanks-excel/
Four methods in this case:
1. Click on the relevant country cell and take the cursor to the right lower corner on the cell. watch the sign changing to +. Drag this + thru all the cells where you want the content copied.
2.Press Ctrl+d in the blank cell below the relevant populated cell. This will copy the content of the immediate upper cell.
3. Go the the relevant populated cell and press ctrl+c and then go to the cell where you want the content to be copied and press ctrl+v
4.Go the the relevant populated cell and click on 'copy' icon in the ribbon (under Home tab - left corner). Then go to the cell where you want the content to be copied and click on 'paste' icon in the ribbon (again under Home tab - left corner).
I guess no option available as of now. You need to copy-paste or CTRL+D (fill-down)
This can be done by making the cell with country name active, and then dragging the cell down from right bottom corner to the desired cells.
By using the mouse
Put the arrow on the left down corner for the cell until bold (+) appears and drag the plus to fill as we need
IN THE FIRST CELL WRIT UAE THEN SELECT THE CLUMN AND PRES COTROL+ENTER
do you mean empty cells ?
you can do it by find and replace command
find empty cells replace with UAE
By using the auto fill ORcopy and select then press enter
by using auto fill or using press
By Clicking the Edge of the Last Cell or By Drag it down up to where you want to fill. and to select the UAE Cell and Select below Cells up to where you want to fill and then press CTR+D
