Excel is easy for learn, This have many tips for daily work
Today I'll show you 5 best tips base on my experiences
Please take a look and leave a comment if you know another tips, Thanks so much ^^
Explore My Other Channel for More Cool and Valuable Insights
👉 Youtube Learn Tech Tips👉 Tiktok
👉 Facebook:My five tips is
How to group/ungroup row and column in excel
How to make number auto increment
How to using Data Validate with List Control
How to using Data Validate with error message
How to using Auto Fill with List settings
1. How to group/ungroup row and column in excel?
PurposeLet you easy control and view data , we can use function group, ungroup in excel
How to work
Menu Data -> Group / Ungroup
2. How to make number auto increment?
Purpose:Auto increment is support user easy control row of data
How to work:
Using Formulas in Excel type = A2 + 1 same and then drag mouse from bottom plus for number auto increment
3. How to using Data Validate with List Control?
Purpose:Data Validate is great for validate data. Input your list items which you want to people choice on the sheet,
How to work:
Using Menu Data -> Data Validation -> Choose "List" from group Allow same the picture and choose the area contains some data
4. How to using Data Validate with error message?
Purpose:Sometime your data which you want to force somebody input number only and don't want to input string, character, .... you can easy do it with data validate (error message)
How to work:
Using Menu Data -> Data Validation -> see picture
5. How to using Auto Fill with List settings
Purpose:Auto Fill will be help you auto fill data on sheet
How to work :
Choose Menu File -> Options -> Advanced -> Edit Custom lists
Thank you for reading this post. I hope you found it helpful and easy to follow. If you have any feedback or questions about
Five Best tips in Excel - How to group/ungroup row and column in excel - How to make number auto increment - How to using Data Validate with List Control - How to using Data Validate with error message - How to using Auto Fill with List settings ,
please share them in the comments below. I would love to hear from you and discuss this topic further
✋✋✋✋
Webzone Tech Tips Zidane, all things tech tips web development
- I am Zidane, See you next time soon ✋✋✋✋