Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to clear specified cell contents if value of another cell changes in Excel?
In this article we will learn how to remove the values of specific cells if value of any linked cell gets removed or modified. This can be done using a VBA code. For example you want to clear a range of cell values if the value of a specified cell is removed or changed, then follow the below steps for the same. Clear specified cell contents by changing the value of another cell Step 1: Following is the sample data where on changing the value of A2 cell, the values of C1:C3 will get cleared. Step ...
Read MoreHow to Clear Print Area through Multiple Sheets At Once in Excel?
In an excel workbook, we have the provision to set the print area (which we want to print instead of the complete workbook) from a sheet. In this article we will learn how to remove the print area if there are multiple sheets and all have predefined print area. This can be done automatically by using the Visual Basics Applications for Excel. Follow the below steps for the same. Removing Print Area of a complete Workbook using the VBA Code Step 1: Below is the sample data with two different sheets having predefined Print Areas. ...
Read MoreDifference between “blank” and “_blank” target attributes in HTML
Sometimes, we may have noticed links on webpages that leads us to a different webpage. In some websites, if we click on that certain links, they will open in a new browser tab or on a new window and some websites reuse one new browser tab for subsequent clicks on the link. Additionally, some websites use the same original page for the links. These behaviors are achieved by utilizing the HTML target attribute. In this article, we will explore how to use the target="blank" and target="_blank" attributes to open hyperlinks in new tabs. The Target Attribute The target is an ...
Read MoreHow to quickly combine the first and last names into one cell in Excel?
While dealing with large datasets, sometimes users find that the first and last names of persons are stored in different columns. But, to process the information combine name or full name is required. For this type of case, the user needs to add the data from both columns to a single column. This article briefs three common examples to perform this same task. The first example allows users to use concat() function to achieve the same task. The second example allows the user to use the flash fill feature, to fill out the remaining name. It is very important ...
Read MoreHow to quickly combine text and date into the same cell in Excel?
Sometimes, when the user is working with large datasets, involves the use of both text and dates. Another important task is to combine the two elements into a single cell. Excel provides simple and efficient methods to merge text and date values effortlessly. In this article, users need to explore different techniques and formulas that will allow users to merge text and date values quickly and seamlessly in Excel. The first example uses the user-defined formula, to combine data and text value. While the second example, allows the user to use the kutools. Example 1: To combine the text ...
Read MoreHow to quickly color ranking in Excel?
In this article, the user will learn the process of coloring the cells in Excel based on the rank values. To do so, firstly user needs to evaluate the rank by using the provided rank formula, and after that obtained cells will be highlighted according to the user’s requirement. Another major benefit of learning this task is that analyzing data with the help of color is easier. For example, consider that all the students who scored above 90 % marks will be displayed with green color. Then analyzing them from a large data set becomes an easy task. All ...
Read MoreHow to quickly close all workbooks except active one?
In this article, users will learn how to quickly close all workbooks except active ones. Whether users are dealing with a complex project or collaborating with others, mastering VBA code will enhance productivity and simplify the user’s Excel experience. This time-saving method eliminates the need for individually closing each workbook, allowing users to declutter the workspace and minimize distractions This article contains an example that guides users through the process of closing all the workbooks except the active ones. Example 1: To close all the workbooks except the active one, by using the VBA code in excel. Step 1 ...
Read MoreHow to quickly check if a sheet is empty in Excel?
In Excel, the most common ensuring fact is the accuracy and completeness of data. It is essential for effective data analysis and decision-making. One common task is to check whether a sheet is empty or contains any data before proceeding with further operations. By quickly determining if a sheet is empty, the user can save time and avoid errors when working with large datasets or collaborating on Excel workbooks. This article will provide the user with simple yet powerful techniques to swiftly check if a sheet is empty in Excel, allowing the user to confidently proceed with user data ...
Read MoreHow to quickly change order of tabs to your need in Excel?
In Excel, organizing and rearranging tabs can greatly enhance the workflow and improve the efficiency of user data. While working with a large spreadsheet that contains multiple tabs. It is essential to know that changing the order of tabs quickly changes the order of tabs to suit user-specific needs. Whether users want to prioritize certain sheets, group related tabs together, or simply reorganize the workbook for easier navigation, mastering the art of tab reordering is a valuable skill. In this article, the user will explore different methods and techniques to swiftly rearrange tabs in Excel, empowering the user to customize ...
Read MoreHow to quickly change font size based on Cell value in Excel?
In this article, users will be able to understand the process of changing the font size based on the provided values. This article briefs two common examples to demonstrate the required task. Benefits of learning this task − It increases the readability of data by adjusting the font size. This ensures that the text becomes easy to read. Increasing the font size can be helpful for individuals with visual issues or when user wants to display the content on large screens or projectors. The font size allows the user to create a visual emphasis and establish a hierarchy of ...
Read More