I have a modified toolbar in Excel. One of the icons looks like a little clipboard with "12" on it. After copying a cell, I choose the destination cell and click that icon to paste value. Oh, and it works with undo.

I also have a paste format icon - the little clipboard shows "$I"

Another area has the stylized arrows to allow me to insert or delete cells, rows or columns.

While I was at it, I got rid of several icons on the default toolbars, since I never use them.

If you do certain things a lot in Excel, customized toolbars are definitely the way to go.

__________________Carol Marler, "Just My Opinion"

Pluto is no longer a planet and I am no longer an actuary. Please take my opinions as non-actuarial.

My latest favorite quotes, updated Mar 5, 2018.

Spoiler:

I should keep these four permanently.

Quote:

Originally Posted by rekrap

JMO is right

Quote:

Originally Posted by campbell

I agree with JMO.

Quote:

Originally Posted by Westley

And def agree w/ JMO.

Quote:

Originally Posted by MG

This. And everything else JMO wrote.

And this all purpose permanent quote:

Quote:

Originally Posted by Dr T Non-Fan

Yup, it is always someone else's fault.

MORE:

Quote:

Originally Posted by Sredni Vashtar

I feel like ERM is 90% buzzwords, and that the underlying agenda is to make sure at least one of your Corporate Officers is not dumb.

Quote:

Originally Posted by PeppermintPatty

But sometimes you get someone who has that charming mix of "don't care" and "don't get it", and there's just not much you can do.

If you do certain things a lot in Excel, customized toolbars are definitely the way to go.

And easy to put alt- keyboard shortcuts upon. Right click the icon, customize, right click again, and put ampersand in front of the desired letter.

EDIT: AFAIK you need to change to "text only(always)" or "image and text" for that. For compactness I use text only and a single letter name like &C or &G. (Alt-G is how I toggle design mode since I use controls on sheets.)

I have had this issue a number of times before as well. Sometimes, when I am working with Census files and I type in a formula (=B4/H6, say), instead of calculating the result, the formula stays and nothing happens. Is there a fix for this? If I repeat this in some other column, it works (on the same worksheet). Under the options, the calculations are set to automatic.

I have had this issue a number of times before as well. Sometimes, when I am working with Census files and I type in a formula (=B4/H6, say), instead of calculating the result, the formula stays and nothing happens. Is there a fix for this? If I repeat this in some other column, it works (on the same worksheet). Under the options, the calculations are set to automatic.

Any idea why this might be happening?

Thanks in advance.

sounds like the cell is formatted to text. it thinks you just want to see text there ("=b4/b6"), not the formula result.

And easy to put alt- keyboard shortcuts upon. Right click the icon, customize, right click again, and put ampersand in front of the desired letter.

EDIT: AFAIK you need to change to "text only(always)" or "image and text" for that. For compactness I use text only and a single letter name like &C or &G. (Alt-G is how I toggle design mode since I use controls on sheets.)

Anyone have an idea as to why this doesn't work with paste values? Or if it does work, what did you name the icon and which letter is the ampersand in front of?