 
|
If you're looking for love, move along -- the "Canadian Singles" in the article title refers to hit songs, not eligible bachelors. Last week, a new book was published with a list of top 100 Canadian singles, based on a poll of music professionals and fans. In his J-Walk blog, John Walkenbach posted a [...] If you're entering dates on an Excel worksheet, and there's data in the adjacent column, you can use the Fill handle to make the job quick and easy. Enter the first date in the date column, then point to the Fill handle, and double-click.
That fills the dates down to the first blank cell [...] How long is your attention span? It's a short work week, so let's start it off with a couple of quick Excel tips. And when I say "Quick," I mean, "Don't blink, or you'll miss them." I recorded a few quick Excel tips, and posted them in the Excel Quick Tips playlist on my Contextures [...] Last week I was testing a client's workbook, and had filled in all the data entry cells, to make sure everything was working correctly. Before sending the workbook back to my client, I wanted to clear all the data entry cells. Instead of selecting each cell individually, and clearing it, it would be easier to [...] While trying to type a hyphen in Excel 2007, I stumbled onto a handy keyboard shortcut. I had a bit of an overreach on the hyphen, and hit the F10 key instead. To my amazement, the Ribbon filled with little tags.
Maybe I've been living under a rock, but I don't remember [...] A couple of weeks ago I described how you could select a cell in a table, and automatically filter the list based on that cell's value. The same feature is available in Excel 2007, using a different technique. Using the same example as in the previous post, the East region is selected in the table [...] When you're troubleshooting an Excel worksheet, it may help to see the formulas temporarily, instead of the results. With the formulas visible, you can quickly check that the cell references are correct and the formulas are consistent. Tip: The keyboard shortcut to show or hide the formulas is Ctrl + ' (accent grave, may [...] If you're working on a big worksheet, you might want to see as many rows as possible. The Excel 2007 Ribbon uses about an inch of space at the top of the worksheet, and if you're just entering or editing data, you probably don't need to use the Ribbon commands. You can temporarily minimize the [...] While working at a client's office, I sometimes create an Excel workbook that a user will enter data in every day. To make it easy to open the workbook, I add a shortcut to the user's desktop (with their permission, of course). This makes it easy for the user to open the file, without trying [...] Do you ever accidentally close a tab in Firefox, then want to get back to a website that you were exploring in that tab? It happens to me a couple of times every day – I click on a link, and when I'm finished reading that page, I close the tab. Oops! That link [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
