Tip Printed from ExcelTip.com

---

Add a fancy line for Presentation


Tip submitted by:
Cycling-Rod, Lancashire, UK


Put this formula in A1:
=REPT("X",90)
and on pressing enter,
a line of X's will run along row 1. Alter the character
between the " ", and alter the 90 to shorten or extend the line.
With the cursor still in A1, experiment using cell format, changing the font,
etc, and see the effect. Ideal for presentation.