Browse by Tags
All Tags »
Office Tips »
Excel Tips (RSS)
Occasionally I have data that looks like this, sorted on the "Value" column: It's always annoyed me that Excel couldn't read my mind and figure out that I wanted to sort them in "High, Medium, Low" order. Recently I found out that it is possible to do
Read More...
While ego surfing I just ran across this handy list of cheat sheets that I wanted to share. Covers topics from HTML to networking to office apps to keyboard shortcuts to SCSI to math. Handy.
Read More...
By default, when you click on a link to an Office doc (such as on a sharepoint site), IE will open the doc in-frame. For just viewing docs this is usually OK, but it can get annoying as not all features work in this manner. So if you'd rather have IE
Read More...
We recently had a debate on the internal bloggers distribution list about how MSDN bloggers need to play nice and not hard-code their font faces, colors and sizes. I admit that I'd been guilty of this myself, so I've since resolved to stop doing that,
Read More...
This is one of those features that a lot of people love to hate, where you have to wait a few seconds or go to the little chevron on the bottom of the menu to expand it: It doesn't bug me too much - except when it hides the MRU (most recently used) list
Read More...
A few months ago I posted about [what I think is] a neat way of using Outlook's ability to save as HTML . Today when compiling a powerpoint presentation , it occurred to me that there are a lot of formats that Office applications can save into that I
Read More...
In certain Office apps that support it, such as Word & Outlook, I have “Show shortcut keys in screentips” enabled (right click on a toolbar, choose customize, and it's on the Options tab in certain of the apps). Normally, this displays
Read More...
If you have data in Excel and you want to hide rows with duplicate entries, it's super easy: 1. Select the data you want to filter 2. Data | Filter | Advanced Filter 3. Click “Unique Records Only“ Excel will then hide rows that are duplicates
Read More...
