| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I get Excel to print dashes right across a cell
In Symphony and Lotus 123 one could press two keys and repeat a dash or
underline right across a cell however wide. Can you do this in Excel? If so how? Please |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I get Excel to print dashes right across a cell
Activate the "Transition Navigation Keys" checkbox:
Tools Options Transition (tab) Transition Navigation Keys (check box) Now the "old" method works ... meaning type the backslash key and repeat text: eg, \- will display --------- or, \abc will show abcabcabc On Sat, 16 Sep 2006 07:47:02 -0700, arabenn wrote: In Symphony and Lotus 123 one could press two keys and repeat a dash or underline right across a cell however wide. Can you do this in Excel? If so how? Please |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I get Excel to print dashes right across a cell
You can also use a custom number format in the cell of: @*-
Entering a single quote mark ' or a dash - fills a dash across the entire cell. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "arabenn" wrote in message In Symphony and Lotus 123 one could press two keys and repeat a dash or underline right across a cell however wide. Can you do this in Excel? If so how? Please |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I get Excel to print dashes right across a cell
Enter a dash in the cell.
FormatCellsAlignmentHorizontalFill Which is heckuva lot more than 2 keys. Or Format as Jim suggests. Gord Dibben MS Excel MVP On Sat, 16 Sep 2006 07:47:02 -0700, arabenn wrote: In Symphony and Lotus 123 one could press two keys and repeat a dash or underline right across a cell however wide. Can you do this in Excel? If so how? Please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| missing cell borders in Excel | Excel Discussion (Misc queries) | |||
| Excel 2003 print problem with conditional formatting cell selected | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Linear Mode
