Daily posts of Excel tips…and other stuff
Archive for the ‘Tools Options’ Category.
In Excel, you can get the Username by using Application.UserName. The Username is what is entered on the General tab of Tools > Options. Inexplicably, you cannot get the user's initials, but you can in some other Office programs. I read a suggestion to automate Publisher and get the user initials via [...]
Recently I got a new computer at work. I had the occasion to use your comments at Power User Setup and it was great to not have to wrack my brain remembering all that stuff. There is one annoyance that should be added to the list: The blasted clipboard toolbar that appears when [...]
I recently got a new (to me) PC at work. I went from 512 of RAM to 1G, which is quite nice. Anyway, I used the post and comments on Power User Setup to get Excel humming the way it was. One comment, by John Walkenbach, was that he unchecks the Move [...]
I installed Office on a friend's computer the other day, and it got me thinking: What Excel setting do I change when I install? It's too long in between installs for me to remember. Usually, I just start using Excel then run into the same problems that caused me to change the setting [...]
This one comes up all the time, and I thought it was worth a post. You enter a formula and it calculates correctly. Then you fill or copy the formula and you get the same answer, but you know the answer should be different.
Nine times out of 10, the problem is that calculation [...]
There is an option under Tools > Options called Precision As Displayed. Choosing this option changes the values in your cells to match the formatting of the cell.
For instance, if you have 41.234 in a cell and the cell is formatted to two decimal places (so it shows 41.23), this option will actually change [...]
