How to insert a slash into a blank cell

C

Claudia

I would like to insert 3 slash keys into my blank cell:

Eg: Charge # / / /

I can draw a line in but then they are not even or lined up. Is there a way
to get them in exact formation?

Thanks,
 
G

Gord Dibben

Slash plus number of spaces, say 6 then Enter.

Format>Cells>Alignment>Horizontal>Fill

As you widen the column your slashes will appear.

Make sure you have Transition Options set so's slash key does not bring up
Help.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to insert Certificated digital signature in Word for Mac 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Macro - insert slashes into a cell 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Dealing with a Pivot Table (when I don't want to) 0
Merging from an Excel file with graphics 1
Word 2007 flash screen upside down and Word2007 cannot be used 0
Auto populate value from one task to another in MS PROJECT 0

Top