| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repetitive keystroke
Hello,
I'm drawing a blank on this: In one cell, I want to have the repetitive keystroke, so that it will expand when I increase the column width. Surely there is a better way than =REPT("=",CELL("width")) (and even that is not an exact solution) I remember in Lotus, it was the key "\" in front of a character, but I've tried many variations of this without success. rgds André |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repetitive keystroke
Hi!
Try this: Select the cell in question Goto FormatCellsAlignment tabHorizontalFillOK Biff "Andre Croteau" wrote in message ... Hello, I'm drawing a blank on this: In one cell, I want to have the repetitive keystroke, so that it will expand when I increase the column width. Surely there is a better way than =REPT("=",CELL("width")) (and even that is not an exact solution) I remember in Lotus, it was the key "\" in front of a character, but I've tried many variations of this without success. rgds André |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repetitive keystroke
You're welcome!
Biff "Andre Croteau" wrote in message ... Thats what I like, quick and efficient!!! Thank you André "Biff" wrote in message ... Hi! Try this: Select the cell in question Goto FormatCellsAlignment tabHorizontalFillOK Biff "Andre Croteau" wrote in message ... Hello, I'm drawing a blank on this: In one cell, I want to have the repetitive keystroke, so that it will expand when I increase the column width. Surely there is a better way than =REPT("=",CELL("width")) (and even that is not an exact solution) I remember in Lotus, it was the key "\" in front of a character, but I've tried many variations of this without success. rgds André |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repetitive keystroke
Thats what I like, quick and efficient!!!
Thank you André "Biff" wrote in message ... Hi! Try this: Select the cell in question Goto FormatCellsAlignment tabHorizontalFillOK Biff "Andre Croteau" wrote in message ... Hello, I'm drawing a blank on this: In one cell, I want to have the repetitive keystroke, so that it will expand when I increase the column width. Surely there is a better way than =REPT("=",CELL("width")) (and even that is not an exact solution) I remember in Lotus, it was the key "\" in front of a character, but I've tried many variations of this without success. rgds André |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a keystroke to go between tabs in a workbook? | Excel Worksheet Functions | |||
| mapping keystroke to a cell | Excel Discussion (Misc queries) | |||
| Macro -- repetitive tasks | Excel Discussion (Misc queries) | |||
| Using macro to run repetitive tasks | Excel Discussion (Misc queries) | |||
| How do I insert the keystroke ShiftF3 into a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
