the MOST

Sometimes, when you’re working in Excel, you need to have more than one line in a cell.  I picked up this trick several years ago when I needed the street address and apartment number to appear on separate lines in the same cell.
Wrap Text isn’t the solution, because when you use Wrap Text, the location of the line [...]

[Read more →]

We always look for good images. Pictures tell a thousand words, making them ideal additions to blog posts, class projects, presentations, emails, and other social media applications. Fortunately, Microsoft drastically improved their Clip Art galleries in the last several years, adding thousands of high quality photographs.  Using Microsoft’s Clip Art galleries while connected to the [...]

[Read more →]

When I’m working in Excel, I find that I sometimes want to view information from one worksheet while I’m working on another.  Jeff wrote a very useful post about viewing two Excel spreadsheets at once, but this limits how much you can see of each, and may not be ideal.  The other day I learned about [...]

[Read more →]

In Excel 2003 and earlier versions, when I tried to select a large block of data using my mouse, I would often overshoot, and accidentally select more rows than I meant to.  Then I would go back, and select too few.  I often had the same problem scrolling within a spreadsheet.  I would go too fast, [...]

[Read more →]

More than once I’ve talked to people who clicked the Print Preview button before printing an Excel worksheet that should fit on one or two pages, only to discover that 100+ pages were slated to print, and all but the first few were going to be blank.
In my experience, this usually happens because you have [...]

[Read more →]

If you’ve ever looked at Office 2007, then you know that things have changed significantly.  Most people I talk to are frustrated when they first switch to Office 2007, because they don’t know where to find the tools they used in earlier versions of Office.  Microsoft has put together videos, demos, and interactive guides to help [...]

[Read more →]

When you need to print a spreadhseet that has too many rows to fit on one page, the information on the second page can lose meaning without the column headers.  The same thing can happen if you have more columns than can fit on a page.  Fortunately, Excel has a feature that allows you to [...]

[Read more →]

A few months ago, a staff member ran into a problem I had never heard of before.  She was making a header in an Excel spreadsheet.  She accessed the header and typed a title that included an ampersand (&).  When she looked at the header in her spreadsheet, the ampersand did not appear.
A Google search turned [...]

[Read more →]

When you paste something in Word, Excel, PowerPoint, and some of the other Office programs, a Paste Options button will appear.  (It is usually at the bottom of the pasted material, although with something really long, I sometimes see it appear at the top right.)  If you click on this button, you see different options.  [...]

[Read more →]

Your document tells people more about you than you think.  No, I’m not talking about when people look for double meanings in your words or calculate the average number of syllables you wrote to decide how smart you are.  There can be hidden information in your documents that a savvy user could access.
Office 2007 has a built-in tool, called the Document [...]

[Read more →]