View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Filling a cell with "-"

Type
-
Into a cell.
You'll have to either preformat the cell as text or start with a leading
apostrophe:
'-

Then Format|cells|Alignment tab|Horizontal Text Alignment|choose Fill
(xl2003 menus)



dhstein wrote:

I want a cell to contain all "-" (hyphens) no matter how wide the column is.
So if I make it wider or narrower, there will be a line of hyphens. Thanks
for any help on this.


--

Dave Peterson