|
|
When you insert a comment in Excel, a rather boring yellow rectangle appears, where you can add your text.
That's all very proper and dignified, but sometimes you want something a bit more attention-getting.
In the good old days of Excel 2003, it was easy to change the comment shape, with a [...]
I'm just getting back from a vacation in South Carolina, where I didn't use Excel too often, except to add up all my Christmas shopping expenses. If you're on my shopping list, you might be getting a basket from the Charleston market.
Or maybe you'd like some of the local barbeque sauce or [...]
How can you quickly move around an Excel worksheet? That's what Andrea asked in a recent comment:
How do I "go to" a specific page of my worksheet. I have 23 pages and do not want to keep scrolling. I cannot find how to do this as on Word.
Of course, Andrea is correct, and [...]
Do you sometimes need to fix data that has numbers, with trailing minus signs? I don't run into this problem too often, but I usually fix them with the Text to Columns feature. Select the column that contains the trailing minus signs On the Excel Ribbon's Data tab, click Text to Columns. Click the [...]
Are you ready for Spreadsheet Day on Monday (October 17th)? I'm just back from a week of vacation, and will be working on my "Help a Student" template this weekend. Yes, I crossed the border this week, and spent time shopping and relaxing in Rochester NY. I toured the home of George Eastman, founder of [...]
It's hard to believe that a year has passed already, and it's only a week until Spreadsheet Day -- Monday, October 17th. Don't panic though, there's still time to organize an office party, and order a spreadsheet cake. If you have thousands of dollars in your celebration budget, you could buy a special bottle of [...]
Last week someone sent me an Excel file that was having problems – it wouldn't save properly, and there were a few other strange behaviours. The file had been working well for a few years, but recently started acting up. The file was used in a factory, where the technicians filled in data, and printed [...]
This might be more of an Outlook tip, but I get a lot of Excel attachments in my Outlook email messages. Most of those files have to be saved, and it seems to take forever for the Save As window to open. Okay, my stopwatch says it's about 9 seconds – but it seems like [...]
Recently, I saw this tweet, from someone stuck on an Excel problem: An Excel problem I have never solved – easily copying a formula down tens of thousands of rows where the row next to it may be blank. Yes, it's easy to copy a formula down a column, if the adjacent column is filled. [...]
We took a look at Excel Custom Views last week, and used them to filter data, and hide or show columns. The Custom Views make it easier to print weekly reports, with different layouts for each version – all in a single file, with no macros. When you create a Custom View, it stores [...]

|
|