Filling a Cell

There may be times when you need to fill a cell with a particular character or group of characters. For instance, you may need to fill a cell with the characters " Enter MPG " (with the spaces) for the entire width of the cell. Excel allows you to do this very easily. It repeats the characters over and over again, regardless of the cell width. To utilize this feature, follow these steps:

1. Type the characters that you want repeated in the cell.
2. Display the Home tab of the ribbon.
3. In the lower-right corner of the Alignment group, click the small icon. Excel displays the Alignment tab of the Format Cells dialog box. (See Figure 1.)



Figure 1. The Alignment tab of the Format Cells dialog box.

4. Use the Horizontal drop-down list to select the Fill option.
5. Click on OK.

Excel repeats whatever you typed in the cell, until the entire cell is filled. For instance, if you typed two characters, then those two characters are repeated over the width of the cell.

It might be helpful to provide a bit of history here. This "filling a cell" capability has its roots in the very early days of Excel. In those early days when most things were text-based, this type of capability was used to fill a cell with a dash (-) or an equal sign(=). In that way, the cell could act as a "border" between groups of numbers or between headings and the numbers under those headings.

With the advent of actual formatting, which has now been available in Excel for years and years (and years), the usefulness of filling a cell in this way is obviously lessened.

I think it still has some usability, however, if you want to fill a cell with a "directive" to the user as to what should be entered in the cell. That is the reason I provided, at the beginning of this tip, an example that filles the cell with the text " Enter MPG " (with the spaces). This could be a directive to the user to enter a "miles per gallon" figure. That way, no matter how wide the user made the column, it would always be filled with that text.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6254) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Filling a Cell.