![]() |
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é |
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é |
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é |
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 11:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com