Excel tips and tutorials
Some worksheets have blank cells in a column, instead of repeating the headings in every row. That white space makes it easier to read the report, but will cause problems if you need to sort or filter the data.
Here’s how you can fill in those blank cells, to avoid messing up your data. Then, use an easy conditional formatting trick, to hide the duplicate headings. Continue reading “How to Fill Blank Cells in Excel With Value from Above”
It’s been a long week, so here’s a quick Excel data entry tip for you. You’ll see how to move through a set of data entry cells that are in different rows and columns, quickly and easily.
Continue reading “Excel Data Entry Tips Jump to Next Cell or Previous Cell”
Are you ready? Spreadsheet Day 2021 is almost here – Sunday, October 17, 2021. What plans do you have for this year’s celebrations? Continue reading “Get Ready for Spreadsheet Day 2021 on Oct 17th”
Did you already notice that today (September 5, 2021), is Excel day 44444? To see that number, type today’s date in a worksheet cell. Then, change that cell’s number format to General. Are you ready FOUR an Excel Day celebration?
Happy Summer! Or, if you’re south of the equator, Happy Winter! To help you get the new season off to a good start, 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.
NOTE: To get Excel links and articles every other week, sign up for my bi-weekly Excel newsletter.
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?)
