![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Pradeep Kumar has Published 1236 Articles
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
650 Views
Have you experienced a situation where you want to copy selected data from the existing sheet to another sheet? If we try to do this manually, it will be a time-consuming process as we need to create a new workbook and then copy the data. We can automate the task ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
We can easily copy and paste data into an Excel sheet or the entire worksheet in Excel. But it can be a very lengthy process if we try to copy the data from the hidden sheet. We can copy the data from a hidden sheet without unhiding the sheet by ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
2K+ Views
Sometimes in Excel, you want to only copy the values that are unique. The values that are not repeated in a list are known as "unique values." If we try to manually select only the unique values to copy, then it can be a time-consuming and inaccurate process. In this ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
4K+ Views
In Excel, you will occasionally be asked to convert a given zip code to the state name. A zip code can be used to uniquely identify a place based on a number. The zip code is mainly used for shipping the parcels. Every state has a starting and ending zip ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
5K+ Views
Sometimes in Excel, you just need to convert the zeros to dashes to represent that there is no value in the cell. We can do this task if we treat zero as a value. If we try to solve this manually, it can be good for small amounts of data, ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
109 Views
In Excel, you may need to convert zeros to blank cells at times. If we attempt to complete the task manually, it can be a time-consuming process. Read this tutorial to learn how you can convert zeros to blanks in a selected range in Excel. The blank represents the value ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
1K+ Views
In Excel, we always try to show the date and time in the format of dd-mm-yyyy hh:mm:ss, which is the standard format when we use the date and time in Excel. But when the date and time are given in another format, some users may feel uncomfortable using them because ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
18K+ Views
Sometimes in Excel, you can see that the dates in the sheet have no separators between the date, month, and year. So, we need to convert them to a valid fSometimes in Excel, you can see that the dates in the sheet have no separators between the date, month, and ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
276 Views
Sometimes in Excel, you would need to convert the given day name to a number, like one for Monday, two for Tuesday, and so on. If we try to convert the days manually, we can use it if there are fewer values; when there are more values, we can’t use ... Read More
![Pradeep Kumar](https://www.tutorialspoint.com/assets/profiles/483469/profile/60_891162-1657084658.jpg)
Pradeep Kumar
33K+ Views
Have you ever wondered if there is any feature in Excel from which we can find the start and end dates of a week in any year without using the calendar? There is no direct way, but we can solve this task in Excel using the formulas supported by the ... Read More