You can automatically repeat one or more characters to fill the cell by starting the character string with the characters slash-slash-r (//r). For instance, to fill a cell with hyphens:
This feature can be useful for drawing lines to demark areas of your spreadsheet when printed. Another way is to fill a cell with hyphens and plus signs:
However, if you wish to enter a character string that begins with a slash (/), you must be sure to begin the entry with the special text-indicator character ' (apostrophe).