This coming Saturday, October 17th is Spreadsheet Day. I’m sure you’ve got a full day of celebrations planned, starting with waffles at breakfast, and a “sheet” cake with your evening meal. And to help you get in the Spreadsheet Day spirit ahead of time, you can join a special online event tomorrow, October 14th.
Category: Excel tips
Excel Looks Strange on Second Monitor
Lately, I’ve noticed that some things in Excel look strange, when I have them on my second monitor. For example, an Excel UserForm listbox doesn’t show its scroll bar. But, if I drag that UserForm to my other monitor, the scroll bar magically reappears. Finally, I tried a quick fix, and it seems to be working!
Continue reading “Excel Looks Strange on Second Monitor”
Excel Check Box Fills in Billing Address
There’s an Excel Order Form tutorial on my Contextures site, with written steps and a video that show how to set it up from scratch. I’ve just added a new section, with a check box that fills in the billing address. Add a check mark, and a macro copies the shipping address for you.
Show Pivot Table Values with Slicer
Instead of adding and removing pivot table values one at a time, click a Slicer, to quickly add and remove them, in groups. Most pivot tables won’t need this, but for source data with lots of numeric fields, this slicer technique can make things easier.
Happy Excel Day 44000
Since you love Excel, you probably already noticed that today (June 15, 2020), is Excel day 44000. You’ll see that if you type today’s date in a worksheet cell, and then change the number format to General, because Excel stores dates as numbers.
Excel Roundup 20200319
It’s been a long time since the last Excel roundup, so here’s a new one! Check out these Excel links and articles, and I’m sure you’ll find a few interesting things to read.
How to Fix Excel Copy and Paste Problems
Copying and pasting can save you lots of time in Excel. Occasionally though, you might run into problems. See how to fix Excel copy and paste problems when you’re working with multiple selections. One problem is sneaky, and you might not even know it’s happening!
Keep Notes on Excel Formulas and Macros
Do you keep notes about the Excel formulas and macros that you create? What’s your documentation system, if you have one? Is it fancy or simple, and is it electronic or paper-based? Or is it all stored in your head?
Excel Printing Tips Videos
Someone asked me for help with an Excel printing question recently – how to make the columns all fit on one printed page. Most of us don’t print our Excel sheets too often, so it’s easy to forget those Excel printing tips! Videos and tips below show a few things you can do to make Excel printing easier.
Happy Spreadsheet Day 2019
Happy Spreadsheet Day 2019! What will you be doing to celebrate today? There’s a special Microsoft event at 12 noon Eastern Time, so catch that if you can (details below).