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
Microsoft Technologies Articles
Page 52 of 175
How to list all Mondays or Fridays in a month in Excel?
In this article, we will discuss how to list all dates which fall on Mondays or Fridays in the given month in Excel. Like numeric data, Excel also works well with dates. If we want to fill a series of dates in a worksheet, we can simply use Fill handle. But what if we want only those dates that fall on a Monday or Friday. This task cannot be achieved using Fill handle. We can use two ways to fill the dates in the given month that fall on Monday or Friday. The user defined function would be used in ...
Read MoreHow to list all formulas in Excel?
Excel provides various formulas and functions to analyze and examine numerical data. These formulas and functions are mostly aimed at numerical data. An Excel worksheet contains data that is either manually entered or calculated using formulae, but formulas are not visible in the worksheet. We aim to list all the formulas used in an Excel worksheet. In this article, we will describe different ways to list all the formulas present in the given worksheet in Excel. The two major examples can be used to list all the formulae in an Excel worksheet. The Show Formulas option utilize in example 1 ...
Read MoreHow to insert numbers or rows for missing sequential number in Excel?
Inserting the number for the missing sequential number in Excel means that the user wants to complete the missing number in Excel by using the available Excel feature. This article will understand two basic ways to perform this task. The first example, guide the proper way to use VBA code to complete the missing sequence numbers in Excel. This example can be a little tedious as here, users need to learn the way to code and use proper code indentation to solve the task. Another example available in the sheet describes the method to use kutools, to fill up the ...
Read MoreHow to highlight/conditional formatting unique/duplicate values in Excel?
In Excel, conditional formatting is a feature that allows users to apply formatting to cells based on specific conditions or criteria. By using conditional formatting, the user can color, highlight, or format cells dynamically, that depends upon the values, formulas, or rules the user defines. Unique values are the ones that do not have any exact matching value in the Excel sheet. While the duplicate value is the one that has the same values available in the list. This article illustrates two common examples of the same. The first example allows the user to determine the duplicate value. In this ...
Read MoreHow to highlight/conditional formatting top n values in Excel
In Excel, conditional formatting is a feature that allows users to apply formatting to cells based on specific conditions or criteria. By using conditional formatting, the user can color, highlight, or format cells dynamically, that depends upon the values, formulas, or rules the user defines. This feature is useful for some data points, patterns, or trends in the Excel worksheets, this makes the data easier to interpret and analyze the data. Instead of manually scanning through cells or applying to format individually. This feature allows the user to automate the process and apply formatting dynamically as the data changes. Benefits ...
Read MoreHow to highlight/conditional formatting dates older than 30 days in Excel?
By using conditional formatting, the user can color, highlight, or format cells dynamically, that depends upon the values, formulas, or rules the user defines. This feature is useful for some data points, patterns, or trends in the Excel worksheets, this makes the data easier to interpret and analyze the data. Instead of manually scanning through cells or applying to format individually. This feature allows the user to automate the process and apply formatting dynamically as the data changes. In this article, users will learn the process of determining the number of dates older than 30 days in Excel. The ...
Read MoreHow to Import / Copy Data From Closed Workbook into Current Workbook?
Importing or copying data from a closed workbook into the current workbook is a valuable capability in Excel that allows you to extract and work with data from various sources. When seeking to collate details from numerous workbooks or access unavailable records, having an effective instrument is invaluable. With that in mind, this article explores various tactics for importing and copying data from closed workbooks into your current Excel file seamlessly. Whether your source files are open or closed, these methods empower you to transfer information efficiently. By utilizing these techniques, you can enhance your data manipulation and analysis capabilities ...
Read MoreHow to insert image control in Excel?
In Excel, adding an image control generally refers to the process of adding an interactive image to a user form or a worksheet. The image control allows users to interact with the image, such as clicking, viewing, zooming, or performing other actions based on its presence. In this article, the user will understand the process of inserting image control in the Excel sheet. This allows the user to insert any control to an image. For example, a macro can be assigned to the inserted image. So, whenever the user clicks on this image the macro will activate itself automatically, without ...
Read MoreHow to Insert file Name or Path into cell/header or Footer in Excel?
In this article, the user will understand the process of inserting a file name or path into the cell/header or footer. This article briefs two examples. Here, the first example allows the user to insert the file name, path, and complete details with the help of the formula in a stepwise manner, while the second example, allows the user to use the header or footer option, to perform the same task. All the guided steps are detailed and thorough. Refer to both examples to understand the working of the provided examples, and to master the process of inserting file name ...
Read MoreHow to identify and return row and column number of cell in Excel?
In this article, the user will learn how to identify and return row and columns number of cells in Excel to process some important data. This article provided two examples to illustrate the way to identify the row and column numbers from the provided Excel data. In the first example, the user must complete the address of the Excel sheet and needs to calculate the separate row and column values for the cells. Examples include the use of predefined row () and column () and match () formula methods to calculate the respective row() and column() values. Example 1: ...
Read More