Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

Aligning and inserting dots

Posted by Crystal Frust on July 26, 2001 3:50 PM

I am working on a financial report for my company. I have had
a difficult time trying to find a way to insert lines
made up of dots and then aligning them vertically down
the spreadsheet. PLEASE,fill me in.

Crystal

Re: Aligning and inserting dots

Posted by lenze on July 27, 2001 7:03 AM

Assuming you don't wish to use the draw feature, you can merge the cells in the column where you want your dotted line to be. Then, choose Format>Cells and on the alignment tab, change the alignment to 90 degrees. Adjust column width as needed.

lenze

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.