How do I repeat an ellipsis without going into Insert/Symbol, etc

T

test-J

In Excel, I prefer to copy & paste other items, but like to use an ellipsis
frequently. i.e., is there a "frequently used" function, so that I don't
have to be copy/paste over & over, &/or go into Insert/Symbol, each time I
want an Ellipsis. Basically i want to click, or maybe Ctrl+click something
to get an Ellipsis in a handy fashion, "…" (there's one) HELP!
 
R

Roger Govier

Hi

View>Toolbars>Customise>Insert> in right hand pane scroll down till you
see the left and right ellipsis.
Drag to a convenient position on your toolbar.
When required, just click the appropriate left or right version.
 
B

Bob Umlas

Hold the alt key down, and ON THE NUMERIC KEYPAD, type 0133, then let go of
the alt key!
..
It's not just an Excel setting, BTW
Bob Umlas
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

Top