|
|
If you've added comments to an Excel worksheet, you have a couple of built-in options for printing the comments.
Show the comments on the worksheet, and print them as displayed.
Print the list of comments at the end of the worksheet, on a separate printed page.
Printing the comments on the worksheet is okay if [...]
It's easy to protect a worksheet in Excel, but it's not so obvious how you leave some of the cells unprotected, so users can make changes to those cells. You can follow this tutorial to learn how to do that, and maybe you'll even see the weird dialog box heading that I show below.
For [...]
Are there files that Excel opens automatically, every time you start Excel? Something changed in your computer, and Excel files are opening automatically, and you want to get rid of them. Keep reading, to see where those files might be located, and how to stop them from opening.
Also, remember to enter the Excel Giveaway [...]
Someone emailed me last week about problems with a range named Database. For reasons known only to the hamsters that operate my brain wheels, that reminded me of Excel's Data Form. It's a built-in data entry tool, that lists all the fields in a table, with entry boxes for some fields, and the formula results [...]
In Excel 2003, you could create a custom toolbar, and attach it to a specific workbook. I didn't use that feature, but occasionally I receive a workbook where someone has attached a toolbar.
Custom Toolbars in Excel 2007
The Ribbon was introduced in Excel 2007, to replace the Excel toolbars. It has an Add-Ins tab, where [...]
Mike Alexander, Microsoft Excel MVP, and madcap owner of DataPig Technologies, is interviewing Excel people this summer, and posting the interviews on his Bacon Bits blog. Lots of fun!
Here's the only picture that I have of Mike, and apparently John Walkenbach has a photo of me.
It's funny, that picture reminds me of something, but [...]
If you're doing Excel training, or writing blog posts, or creating sample files, you might need to find some public data to use in your Excel file. You don't want to publish confidential client data, even if it's a bit disguised, or reveal your household finances to the world.
Instead of creating sample data on your [...]
Automatic or manual makes me think of cars, and choosing a transmission type, but an Excel workbook can also be on Automatic or Manual calculation. And just like a car, it's safest if you know what type of Excel calculation mode you're driving, before you head for the information highway.
In a car, you can tell [...]
A while ago, I suggested that we pick a day to celebrate as Spreadsheet Day. There was a poll to pick a date, and October 17th, the release date of VisiCalc, got the most votes.
So, we still have lots of time to plan events for this year's Spreadsheet Day. Do you have any ideas?
Spreadsheet Day
In [...]
If you've used Excel for a while, you have lots of skills that you might assume everyone else shares. However, based on the Excel questions that I see online, those assumptions are very optimistic! For example, I recently saw this plea on Twitter:
Can anyone help pls? can't work out how to add a LOT of [...]
|
|
Recent Comments