Background
Break News
How to add local font to Tailwind Css and NextJS? - Tutorial Design Pattern? - Blockchain Technology, How to create own Bitcoin virtual currency - Zustand mordern management state - Design Pattern - Flyweight Pattern? - Docker Full training Topic

[Tips] Five Best tips in Excel

Excel
Office
Tips
Wednesday, 14 October 2015
|
Read: Completed in minutes
Webzone - Zidane

[Tips] Five Best tips in Excel

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 ^^




group/ungroup row and column in excel



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?

Purpose
Let you easy control and view data , we can use function group, ungroup in excel

How to work
Menu Data ->  Group / Ungroup

How to group/ungroup row and column in excel

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

How to make number auto increment excel


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

How to using Data Validate with List ControlHow to using Data Validate with List Control







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

How to using Data Validate with error message

How to using Data Validate with error message

How to using Data Validate with error message

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

How to using Auto Fill with List settings


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 ✋✋✋✋
Posted by at
Labels: , ,
🙇🏼🙇🏼 We Appreciate Your Comments and Suggestions - Webzone, all things Tech Tips web development

Related Posts

Popular Webzone Tech Tips topic maybe you will be like it - by Webzone Tech Tips - Zidane

PHP How to use Array Object Class in easy way

PHP is a popular and powerful programming language that allows you to create dynamic and interactive web applications. PHP supports variou...

[Solved] Fix Camtasia Studio Bug "It is either an unsupported media type or required codecs are not found"

Hello everybody, welcome to Learn Tech Tips Blog, Today I will share with you how to fix Camtasia Studio Techsmith Bug. -  "It is eithe...

[Tips] How to read Excel file in C#

If you want to read an Excel file in C#, you have several options to choose from. One of them is to use a third-party library, such as Lin...

[Solved] How to fix "The remote session was disconnected because license store creation failed with access denied. Please run remote desktop client with elevated privileges"

Topic today I will share with you how to fix one issue many people got it when using Remote Desktop . That issue is: The remote session was ...

[Tutorial] How to Handle TextBox, Label, ComboBox and CheckBox Events in C++

Learn C++ controls is very easy for newbie, This tutorial will be help you working with TextBox, Label, ComboBox, CheckBox Control. ...

[Solved] Bootstrap Datetimepicker OnChange event (WORKING)

Hello everyone, welcome back to Learn Tech Tips blogspot Today topic is show you how to fix bug OnChange event not working with Bootstrap 4D...

[Tips] How to "read and write struct file with C# programming language"

In this article, I will teach you how to write a structure file in CSharp. A structure file is a type of binary file that stores data in a p...

[Tips] How to read write Ini File in C#

How to Read and Write INI Files in C# INI files are a simple and widely used format for storing configuration settings. They consist of s...

How to "setup SQL Server Driver" php (XAMP/MAMP) on Window "MacOS"

✋✋✋✋Hello Everybody, welcome to Learn Tech Tips blogspot , nice to see you again, I am Zidane (my chinese nick name is 雞蛋 🥚🥚🥚🥚🥚🥚🥚🥚) ...

[Tips] Add custom header in HttpWebRequest

When you call request from client to server, sometimes, you need to add custom header in HttpWebRequest , you can add it by add headers as b...
As a student, I found Blogspot very useful when I joined in 2014. I have been a developer for years . To give back and share what I learned, I started Webzone, a blog with tech tips. You can also search for tech tips zidane on Google and find my helpful posts. Love you all,
I am glad you visited my blog. I hope you find it useful for learning tech tips and webzone tricks. If you have any technical issues, feel free to browse my posts and see if they can help you solve them. You can also leave a comment or contact me if you need more assistance. Here is my blog address: https://learn-tech-tips.blogspot.com.
My blog where I share my passion for web development, webzone design, and tech tips. You will find tutorials on how to build websites from scratch, using hot trends frameworks like nestjs, nextjs, cakephp, devops, docker, and more. You will also learn how to fix common bugs on development, like a mini stackoverflow. Plus, you will discover how to easily learn programming languages such as PHP (CAKEPHP, LARAVEL), C#, C++, Web(HTML, CSS, javascript), and other useful things like Office (Excel, Photoshop). I hope you enjoy my blog and find it helpful for your projects. :)
Thanks and Best Regards!
Follow me on Tiktok @learntechtips and send me a direct message. I will be happy to chat with you.
Webzone - Zidane (huuvi168@gmail.com)
WebDevZone
I'm developer, I like code, I like to learn new technology and want to be friend with people for learn each other
I'm a developer who loves coding, learning new technologies, and making friends with people who share the same passion. I have been a full stack developer since 2015, with more than years of experience in web development.
Copyright @2022(November) Version 1.0.0 - By Webzone, all things Tech Tips for Web Development Zidane
https://learn-tech-tips.blogspot.com