An Excel worksheet might have headings in column A, and subheadings in column B, with blank cells under each heading. If you want to sort or filter that data, you’ll need to fill in the blank cells. This short video shows you a quick way to clean up the data.
For written instructions please read the article Fill Blank Cells in Excel to Complete a Table
________________
On TikTok, I follow Bryan Nothling aka thebnoth, because he’s funny, and he’s Canadian! His “working from home” videos have brightened my days, and he has over 200K followers, so I’m not the only person who enjoys them.
To highlight cells with a value that is too high or too low, you can use Excel Conditional Formatting. This short video shows you the steps. For detailed instructions see Excel Conditional Formatting Basics. ________________
Did you ever set up your Excel workbook exactly the way you want it, with headings in a freeze pane at the top, and hidden gridlines, and other settings? And then one day, all of those settings disappeared? Why did that happen, and how can you prevent that from happening again?
You can quickly change values in Excel, without using formulas. Follow the steps in this short video to add, subtract, multiply or divide, by a specific amount or percentage. For detailed instructions, please visit Excel data entry tips. ______________
It’s easy to name a group of cells in Excel, then use that name for navigation. This Excel video tutorial shows you the steps. For a written Excel tutorial on naming ranges, see naming ranges in Excel. ______________
When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables. ________________