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 Autocomplete When Typing in an Excel Dropdown List?
When working with a drop-down list that contains many items, it will be difficult to choose just one. This problem can be solved using autocomplete. Read this tutorial to understand how you can autocomplete when typing in an Excel drop-down list. Autocomplete can be used to save a lot of time when we are working with repeated values. Autocomplete When Typing in an Excel Dropdown List Let us see a simple process to understand how we can autocomplete when typing in an Excel drop-down list. Step 1 Consider an Excel spreadsheet with a drop-down list. To create ...
Read MoreHow to Auto-Centre a Checkbox in a Cell in Excel?
If you've ever tried to insert multiple checkboxes in Excel, you may have encountered difficulty arranging them in a logical order. It will be an irritating process to arrange the checkboxes in Excel, as they are placed very randomly. But using the VBA code, we can auto-centre the checkboxes easily. This tutorial will help you understand how you can auto-centre checkboxes in cells in Excel. Auto-Centre Checkbox in a Cell in Excel Here, we will first insert a VBA module and then run it to complete our task. Let us see a simple process to understand how we ...
Read MoreHow to Auto Copy and Paste Cell in the Current Sheet or From One Sheet to Another in Excel?
Sometimes we want to use the same data that is already present in the Excel sheet. Instead of tying data again, we can copy it to other locations. When dealing with large amounts of data, or even small amounts of data, this could save us a lot of time. The copying can be done within the sheet or between the sheets that are present in the same workbook. Read this tutorial to learn how you can autocopy and paste cells in the current sheet or from one sheet to another sheet in Excel. AutoCopy and Paste Cell ...
Read MoreHow to Auto Change the Shape and Size Based on a Specified Cell Value in Excel?
When we want to change the size of a specific shape in Excel based on the value present in any cell, we can use VB code to do it. Read this tutorial to learn how you can automatically change the shape and size based on a specified cell value in Excel. Here we will have two parts: the first is to change only one shape, and the other is to change multiple shapes at once. Auto Change the Shape and Size Based on a Specified Cell Value for a Single Shape Here we will add the VBA code ...
Read MoreHow to Auto Add/Enter Current Date/Time in a Cell with Double Clicking in Excel?
When we want to add the current date or time in Excel multiple times, it can be a time-consuming process, so we can make it very simple by adding a short cut to finish the process. Read this tutorial to learn how you can use doubleclicking in Excel to automatically add or enter the current date or time in a cell. Auto Add/Enter Current Date in a Cell with DoubleClicking in Excel We'll add some VBA code to the sheet here, and the date will be displayed every time we double-click in a cell. Let us see a ...
Read MoreHow to Auto Add Date and Time to Comment in Excel?
When we added the comments to the cells in Excel, you may have noticed that the comment will only contain the name of the user, but we can also customise the comment to add the date and time to the spreadsheet. We can use the process mentioned below to automatically add date and time to comments in Excel. Read this tutorial to understand how you can automatically add date and time to comments in Excel by following a simple process. Auto Add Date and Time to Comment in Excel Here we will first insert a comment ...
Read MoreHow to Assign a Value or Category Based on a Number Range in Excel?
Assume we have a problem where we want to give students grades based on their grades, such as if they got 90 to 100 percent, give them an "O", and if they got less than 50 percent, give them "L" grades. If we try to do this manually, it could be a very time-consuming process. We can solve this problem by using the many formulas supported by Excel at a very rapid rate. Read this tutorial to understand how you can assign a value based on a number in Excel. This process can be completed using two methods: ...
Read MoreHow to Assign a Serial Number to Duplicate or Unique Values in Excel?
Let us assume we have collected the data from a public source and you want to add the ID to each result. To do that, first we need to know how many unique items are present in the sheet. This tutorial will help you understand how you can assign a serial number to duplicate or unique values in Excel. Here we will have two parts. The first part is about assigning serial numbers to unique values, and the next part is about assigning serial numbers to duplicate values. Assigning a Serial Number to Duplicate Values in Excel Here ...
Read MoreHow to Assign a Hotkey to a Specified Macro in Excel?
A macro in Excel is used to automate the process that we use repeatedly. Using macros helps save time by solving the repeated process very rapidly. This article helps you understand how we can assign a hotkey to a specified macro in Excel. Generally, we find macros under the Developer menu in the Excel ribbon. Most systems will not have it. By default, we can add the developer to the Excel ribbon by customising the ribbon. To customise the ribbon, right-click on the ribbon and select "customise ribbon." Then, in the pop-up window, select the checkbox beside "Developer" ...
Read MoreHow to Apply the Same Filter to Multiple Sheets in Excel?
Filters can be applied to a single sheet in Excel, but applying the filter to multiple sheets at once is not possible by default. But we can make it happen with the help of the VBA application. Read this tutorial to learn how you can apply the same filter to multiple sheets in Excel. Applying a filter is simply gathering data based on a single entity. Applying the Same Filter to Multiple Sheets In this case, we'll insert a VBA module and then run the code to apply filer. Let us see a simple process to understand ...
Read More