Edit Cell Format

[Jason]

I am using Excel 2003.

When I would paste text into a cell from another source,
i. e. the internet, word, outlook, I would get a drop
down box at the bottom right corner of that cell.
When I clicked on the dropdown I normally had 3 choices
one was to keep original formatting, one other was to
match formatting. I no longer get that dropdown. What
can I do to get it back when I paste into my worksheets?

Thanks

 

[Bernard Liengme]

Use Tools|Options, open Edit tab, put check mark in Paste Options box.
You should see the icon even when you paste from within Excel not just with
external Copy.

Having said that, I have a networked PC at work with this checked but the
PasteOption icon still does not display. Our IT people have no answer but I
retire in a few weeks and am unconcerned