1. Select the range that you want to fill the blanks with dashes. 2. Click Kutools > Insert > Fill Blank Cells, see screenshot:3. In the Fill Blank Cells dialog, select Fixed value under Fillwith section, and enter the dash (-) into the Filled value text box, see screenshot:4...
2. In theFill Blank Cellsdialog box, ClickBased on valuesfromFill with, and checkDownfromOptions. See screenshot: 3. Then clickOKorApply. And all of the blank cells have been filled with the value above. See screenshots: By using the above methods, you can easily fill blank cells in ...
Easily access hundreds of templates, choose your favorite to download as a pdf file, and simply print to begin harnessing the power of worksheets in your class today! Fractions on a Number Line Worksheets Handwriting Practice Worksheets Tally Chart Worksheets Addition Worksheets Create a Missing ...
5. And then click OK, all of the blank cells in the range have been selected. Then input = and press Up arrow key on the keyboard. See screenshot:6. Then press Ctrl + Enter keys, all of the blank cells have been filled with the original merged data. See screenshot:...
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project. Open and create multiple documents in new tabs of the same window, rather than in new windows. Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! More...
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project. Open and create multiple documents in new tabs of the same window, rather than in new windows. Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! More...