auto fill a cell with the same data

  • Thread starter Thread starter Kev
  • Start date Start date
K

Kev

i want to fill a cell with '-----'. if it is a wide cell
or narrower cell,is there a key stroke that you can
precede the character '-' with to fill the entire cell
instead of entering the character lots of times to fill it?

Thanks - Kev.
 
Format / Cells / Alignment Tab / Horizontal / Fill

This will fill the cell with whatever character(s) you put in the cell.
 
Thanks Ken!

-----Original Message-----
Format / Cells / Alignment Tab / Horizontal / Fill

This will fill the cell with whatever character(s) you put in the cell.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

---------------------------------------------------------- ------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/2003


.
Click to expand...
 
In Cell A1 enter:
=REPT("-",CELL("width",A1)*1.73)
And copy whereever... You'll have to F9 (Recalc)
Occationally, if you change column widths after-the-fact;
Just thought I'd throw this in,,,,
HTH
 
Another way to do this is by simply pressing the forward slash key (\) and
your desired character.

Ken Schmidt
 
You need to enable Tools / Options / Transition Keys for that method to work, but it's probably
easier than my suggestion. :-)
 
Back
Top