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 add new line to email body in mailto hyperlink in Excel?
Have you ever thought that we can send an email from an Excel formula with a single mouse click? When you click on a mailto hyperlink in Excel, an email message will be generated automatically with the fields that you choose spelled out. This happens automatically. However, when you send an email from Excel using the mailto hyperlink function, there is just one line in the actual email body. In this tutorial, we will demonstrate how to insert a new line into the body of an email when using a mailto hyperlink in Excel. The goal is to include a ...
Read MoreHow to add a new sheet with a specific name in Excel?
New Worksheets are continually being added to your Workbook. It might seem incredibly tedious to have to do everything by hand at times (specifically if you have multiple sheets to add). Automating these monotonous tasks is a quick and easy way to solve the problem. Using VBA to Add New Worksheet with Specific Name I have programmed the Visual Basic for Applications (VBA) code to add a new Worksheet at the very end of the Worksheets and give it the label "specific name" Step 1 Save the file and then go to the Developer menu and pick Visual ...
Read MoreHow to add new worksheet with current date in Excel?
New Worksheets are continually being added to your Workbook. It might seem incredibly tedious to have to do everything by hand at times (specifically if you have multiple sheets to add). Automating these monotonous tasks is a quick and easy way to solve the problem. Using VBA to Add New Worksheet with Current Date I have programmed the Visual Basic for Applications (VBA) code to add a new Worksheet at the very end of the Worksheets and give it the label "current Date." Step 1 Start by saving the file and then go to the Developer menu and pick Visual ...
Read MoreHow to Add New Worksheets with Customized Names in Excel?
The data storage, organisation, and manipulation capabilities of Microsoft Excel are the primary motivations for the software's creation and development. Excel Worksheet plays an important part by providing many features to alleviate the laborious process of managing data. Read through this tutorial to find out how you can add new worksheets in Excel with customized names. Follow the steps given below. Step 1 When you first launch Microsoft Excel, you are presented with a menu that gives you the choice between a number of different worksheets, as is seen below. Step 2 You have the option of picking one ...
Read MoreHow to add number of business/working days or hours to a date in Excel?
To determine the precise time at which you will have completed the assignment while you are actively employed, you may need to add a certain number of business days or hours to the given date. In this article, we will demonstrate many different approaches to including a number of business days or working hours into a date using Excel. Assuming that the date 01-01-2022 is located in cell A2, the steps that need to be taken in order to add 22 days to it that only include working days and not weekends are as follows − The formula for calculating ...
Read MoreHow to divide a range of cells by a number in Excel?
It is possible that we will have scenarios where we need to make rapid changes to a range of cells in Excel. For example, there are multiple tables in some of the worksheets that have values that are in six digit numbers and you want to decrease them to, by dividing with some number, in these cases you have to perform the division operation taking the cell ranges rather than dividing that number to each cell separately. Let’s understand stepwise with an example. Using Paste Special You can use the Paste Special feature to divide a range of cells ...
Read MoreHow to do exponential calculation to a range of cells in Excel?
Excel's built-in formulas and tools make it possible to conduct basic arithmetic operations such as addition, subtraction, multiplication, etc., but performing calculations involving exponential functions can be more challenging. In Microsoft Excel, an exponential computation cannot be performed with the help of any of the program's built-in tools. As a result, we would be expected to rely on particular formulas. A method of calculation known as exponential numbers involves multiplying a number by itself and a certain number of times. For example, when we calculate the amount of money we will obtain with compound interest, we will use the exponential ...
Read MoreHow to find the largest negative value (less than 0) in Excel?
Sometimes the scenario may come how to find the most negative value possible in your Excel spreadsheet. Imagine that instead of positive numbers there are hundreds of thousands of lines filled with negative numbers. The formula which you will learn in this tutorial will prove useful in the circumstances like this. The formula uses a few standard functions in order to locate the cell in an Excel spreadsheet that contains the most significant negative number. The IF function and the MAX function are both incorporated into this formula. Let’s see step by step with an example. Step 1 In our ...
Read MoreHow to hide or show chart axis in Excel?
What is an Axis? An Axis on a chart in excel or google sheets is a horizontal or vertical line containing units of measure. The axes border the plot vicinity of column charts, bar graphs, line graphs, and different charts. An axis shows devices of measure and offers a body of reference for the facts displayed in the chart. Most charts, such as column and line charts, would have two axes that are used to measure and categorize data. The vertical axis: The Y or value axis. The horizonal axis: The X or category axis. Hide or ...
Read MoreHow to grey out cells based on another column or drop down list choice in excel?
Excel's Conditional Formatting is a feature that is both one of the simplest straightforward and one of the most powerful features. When you want to highlight cells in Excel that meet a certain criterion, you can utilize a feature in Excel called conditional formatting, which gives the functionality as its name. It provides you with the capability to rapidly construct a visual analysis layer on top of your data set. Using the conditional formatting feature in Excel, you can generate heat maps, display increasing or decreasing icons, and do a number of other useful things. In this tutorial, you are ...
Read More