hat
Nou itilize jeneralman fonksyon Excel a pou ranpli selil vid yo nan seleksyon an. Men, li pral ranplase done ki deja egziste nan seleksyon an, epi kopye fòma a nan selil vid. Men Kutools pou Excel's Ranpli selil vid ap ede ou ranpli sèlman selil vid nan seleksyon san yo pa afekte done ki egziste deja oswa kopye fòma. Ak Ranpli selil Blank sèvis piblik, ou ka byen vit ranpli selil vid nan yon seri jan sa a:
eng
We generally use Excel's Fill function to fill blank cells in selection. Nevertheless, it will overwrite existing data in the selection, and copy the formatting to blank cells. But Kutools for Excel's Fill Blank cells will help you fill only blank cells in selection without affecting existing data or copying formatting. With Fill Blank Cells utility, you can quickly fill blank cells in a range as follows: