auto fill a cell with the same data

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.
 
K

Ken Wright

Format / Cells / Alignment Tab / Horizontal / Fill

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

kev

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...
 
J

JMay

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
 
K

Ken Schmidt

Another way to do this is by simply pressing the forward slash key (\) and
your desired character.

Ken Schmidt
 
K

Ken Wright

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