Excel 2010 Bible

(National Geographic (Little) Kids) #1

Part IV: Using Advanced Excel Features


568


Filling a cell with a repeating character

The asterisk (*) symbol specifies a repeating character in a number format string. The repeating
character completely fills the cell and adjusts if the column width changes. The following format
string, for example, displays the contents of a cell padded on the right with dashes:

General*-;-General*-;General*-;General*-
Free download pdf