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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

test-J - 28 Mar 2007 01:50 GMT

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!

Reply to this Message

Max - 28 Mar 2007 02:53 GMT

Try inserting it as a new option to replace with within:
Tools > AutoCorrect options

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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!

Reply to this Message

Roger Govier - 28 Mar 2007 09:29 GMT

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.

Signature

Regards

Roger Govier

> In Excel, I prefer to copy & paste other items, but like to use an
> ellipsis
[quoted text clipped - 5 lines]
> something
> to get an Ellipsis in a handy fashion, "." (there's one) HELP!

Reply to this Message

Bob Umlas - 28 Mar 2007 19:10 GMT

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

Reply to this Message