 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2005Fill a cell with a character
Hello, In Quattro I can place a backslash (\) followed by a character...say = and the character will fill the cell regarless of column width. Is there a process in Excel to achieve the similar outcome?  SignatureThank-you and all suggestions are appreciated. Format|Cells|Alignment tab|Horizontal Dropdown box|Fill You can also toggle a transition setting to get the same effect. Tools|options|Transition tab|check Transition navigation keys. But this will change how the Tab and home/ctrl-home key work, too. > Hello, > [quoted text clipped - 5 lines] > -- > Thank-you and all suggestions are appreciated. SignatureDave Peterson Or a custom format of @*= I use this one for "leaders" @*. Gord Dibben Excel MVP >Format|Cells|Alignment tab|Horizontal Dropdown box|Fill > [quoted text clipped - 13 lines] >> -- >> Thank-you and all suggestions are appreciated. This does work if you type and = (equal sign) and use @*= as the custom format. But if the OP wanted any old character repeated, then they'd have to use that character in the custom format, too. > Or a custom format of @*= > [quoted text clipped - 19 lines] > >> -- > >> Thank-you and all suggestions are appreciated. SignatureDave Peterson Hi Anauna, Use this format (format, cells, custom) to fill remainder with periods @*. Use this format to fill beginning with periods (leader dots) *.@ The format doesn't have to be text formats, the following would provide asterisk protection on dollar amount. **$#.###.00 http://www.mvps.org/dmcritchie/excel/formula.htm Using Formatting to Change the Way Numbers, Dates, Times, and Text Appear in Microsoft Excel, http://support.microsoft.com/default.aspx?scid=/support/Excel/Content/Formats/de fault.asp --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Hello, > > In Quattro I can place a backslash (\) followed by a character...say = and > the character will fill the cell regarless of column width. > > Is there a process in Excel to achieve the similar outcome? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.