You can create a user form in Excel, to control how users are able to enter data.
These 3 short Excel video tutorials show you the steps.
For detailed instructions please visit the web page Create an Excel UserForm.
_________________
When you open a file in Excel, you might see an "Enable or Disable a Macro” message, but you know that there are no macros in the file. Follow the steps in this video, to prevent this message from appearing. For written instructions see: Remove Excel macro warning ______________
Highlight all the cells in a row, if one cell is above or below a specific value. To do this, use Excel conditional formatting, as described in this short Excel video tutorial. For detailed instructions, please visit the page Excel Conditional Formatting Based on another cell ____________________
In Excel, there’s no built-in Panel Chart type, but you can create line panel charts, like the one shown below. Watch a video, to see the steps, and there’s a transcript too, and a link where you can download the sample Excel file.
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.
Do you ever use check boxes on your Excel worksheets? They’re handy for choosing options, or marking completed items in a To Do list.
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter. To remove the duplicates, follow the steps in this short Excel video tutorial. ______________