Display symbols in excel chart axis
Here is a quick excel tip to make your charts look professional by showing symbols in the axis labels instead of text. Just follow these 4 simple steps: First identify the symbols you want to show on the axis or as data label from symbol fonts like webdings, wingdings or a custom dingbat font like […]
Switch between firefox tabs using mouse scroll wheel
Firefox 3 has a ton of extremely useful productivity features and as I keep using it, I discover more and more of them. Here is one I found extremely useful and simple: When you have lots of tabs open, in order to switch between the tabs, place mouse pointer on any of the tab titles […]
Conditionally play sounds when a cell value changes
Blog reader Richard asks through email: I’m a non-programing user of Excel. I import stock prices, using what is called ( I believe) a dde link, into my spreadsheets,from a trading program. I would like to add a feature to my spreadsheets that, like conditional formatting, alerts me to a price change in a cell, […]
Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds
Who said Excel takes lot of time / steps do something? Here is a list of 15 incredibly fun things you can do to your spreadsheets and each takes no more than 5 seconds to do. Happy Friday 🙂 1. Change the shape / color of cell comments Just select the cell comment, go to […]
Mute conversations in Gmail to not follow a specific thread of mails
Do you know that you can mute conversations in gmail if you are do not want to see that lengthy thread on single subjected that people wont give up. Just select the mail / conversation you want to mute Click on “More actions” and select “mute” Enjoy the bliss If you want search for muted […]
Extract URLs from an excel spreadsheet cell using UDFs
Often my work involves processing web page data in excel sheets. This includes extracting the hyperlinks from cell contents. There is no formula for extracting hyperlinks though, you can right click on cell and choose “edit hyperlink” to see which address the cell is linking to. But that is a tedious process especially if you […]
Changing Sort Orientation in Excel – Sorting across columns instead of rows
change-sort-orientation-excel-columns You can sort data across columns instead of rows by changing sort options. If you ever had to sort across columns now you know a simple way to do this 🙂 Follow these steps for changing sort orientation: Select the table you want to sort (just the data, not the headers as when you […]