Excel tips and tutorials
Do you sometimes get an Excel error that says “Cannot shift objects off sheet” or “Can’t push objects off the sheet”? Why is Excel complaining, and how can you stop it? I was able to fix the problem with a keyboard shortcut: Ctrl + 6. Maybe that will work for you too.
Continue reading “Excel Error Cannot Shift Objects Can’t Push Objects”
To show text on separate lines in an Excel worksheet cell, use a shortcut, Alt+Enter, to add a line break. If you want to remove them later, use Ctrl+J in Find and Replace. This short video shows the steps.
Continue reading “Quick Tip: Find and Replace Line Breaks in Cells”
Here’s a quick Excel tip, to get you off to an easy start in 2021! This short video shows how you can quickly divide a set of numbers, by using the Paste Special command. No formulas required!
Continue reading “Quick Tip: Divide Excel Numbers Without Formulas”
Happy New Year! To wrap up the old year (goodbye 2020!), here’s a roundup of Excel articles and links. I hope you find a few interesting things to read, and new Excel features to try.
Happy Spreadsheet Day 2020! We’re celebrating on a Saturday this year, so you have the whole day to relax, and play with spreadsheets. (Just like we do every day, right?)
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.
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!
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.
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.
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.
