|
|
Do you feel deprived? There's no built-in bullet magic for Excel cells, like there is in a Word document. Fortunately, you can add a bullet to a cell with the keyboard shortcut: Alt + 0149 However, this shortcut only works if you type the numbers on the Number keypad – not the numbers at [...]
Well, maybe it's not incredible, but after all these years of using Excel, I stumbled upon its shrinking font feature. Did you know about it? If not, keep reading to see how it works. And if you've ever had a worksheet where changing the font size had no effect, this might solve the mystery. Report [...]
Happy Canada Day! I made this Canadian flag in Excel, to help you celebrate. If you don't examine it too closely, it looks pretty good – a maple leaf is hard to draw in Excel. You can also select USA from the drop down list on the worksheet, if you're celebrating the 4th of [...]
In Excel 2007 and Excel 2010, you can use icon sets in conditional formatting. For example, use Red, Yellow and Green stoplight icons, to highlight the good, average, and poor results in your sales data.
Rob emailed me recently, to ask how to limit the conditional formatting icons to 2 colours only, instead of [...]
There's a Golf Tee Time Excel workbook on the Contextures site, that I've updated, to add a few new features. You'll list all the players, then assign groups of players to a selected tee time. The new version has data validation in column C, which limits the selection to 4 names, and you can't [...]
Thanks for your formula suggestions on Wednesday's blog post about promotional pricing. Here's another formula example, and I'm sure you'll have alternate methods for this problem too. Driver Limits In some countries, there are limits to the hours that truck drivers can work in a string of consecutive days. In this example, the limit is [...]
Do you ever open an Excel workbook, and find that tragedy has struck your comments? You spent hours inserting those comments, and making them just the right size and shape. Then, for no apparent reason, everything changes. Some comments have flattened to a thin line. Other comments are so small that you can barely [...]
Yes, it's Valentine's Day today, and if you were too busy to buy your sweetie a card yesterday, you can make one in Excel. Phew! Your boss won't mind if you spend a couple of hours working on this today, because it's an Excel project! This Excel Valentine card uses a named range, data [...]
The holidays are a great time to catch up on tasks. I've updated another popular Excel video -- Colour a Row Based on a Cell Value in Excel 2007. It now explains the steps in Excel 2010 and Excel 2007, instead of Excel 2003. To continue the conditional formatting theme, here are a few [...]
An Excel scroll bar can be used for practical (and sometimes boring) things, like testing the effect of price changes, or adjusting a chart's date range. But this is the festive season, so let's use a scroll bar for something more, well, festive! Trim the Tree In this example, instead of accounting and finance, you'll [...]

|
|