Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill 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? -- Thank-you and all suggestions are appreciated. |
#2
|
|||
|
|||
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. Anauna wrote: 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? -- Thank-you and all suggestions are appreciated. -- Dave Peterson |
#3
|
|||
|
|||
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...ts/default.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 "Anauna" wrote in message ... 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? -- Thank-you and all suggestions are appreciated. |
#4
|
|||
|
|||
Or a custom format of @*=
I use this one for "leaders" @*. Gord Dibben Excel MVP On Thu, 03 Mar 2005 09:03:40 -0600, Dave Peterson wrote: 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. Anauna wrote: 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? -- Thank-you and all suggestions are appreciated. |
#5
|
|||
|
|||
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. Gord Dibben wrote: Or a custom format of @*= I use this one for "leaders" @*. Gord Dibben Excel MVP On Thu, 03 Mar 2005 09:03:40 -0600, Dave Peterson wrote: 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. Anauna wrote: 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? -- Thank-you and all suggestions are appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL? | Excel Discussion (Misc queries) | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |