ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Repetitive keystroke (https://www.excelbanter.com/excel-discussion-misc-queries/113276-repetitive-keystroke.html)

Andre Croteau

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é



Biff

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é




Biff

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é








Andre Croteau

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é







All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com