What does Clicking and Dragging the Fill Handle in Excel do?
The fill handle copies the same values, formulas, or fills a series of dates, texts, numbers, and other data to a desired number of cells.
Raj Kumar
How to Find Circular References in Excel
This article demonstrates how circular references work in Excel, how you can find and fix them, and how you can use them if you desire.
How to Delete Empty Rows in Excel
In this tutorial, we will show you some simple ways you can use to delete empty rows in Excel spreadsheets in one go.
How to Alphabetize in Excel
This guide will show you how to alphabetize in Excel using the Sort and Filter feature, and formulas to arrange and format the data in order.
How to Unprotect an Excel Sheet or Workbook With or Without Password
You can unprotect an Excel Sheet or Workbook with or without a password by using a VBA code, ZIP file format trick, or Google Sheets.
How to Separate Names in Excel
In Excel, it is very easy to split first, middle, and last names that appear in the same column into separate columns by using different ways.
How to Use Goal Seek in Excel
Goal Seek is one of Excel's built-in What-If Analysis tool that helps you find the input value in a formula to get a desired result.
How to Convert Json to Excel
If you have data stored in a JSON file that you would like to convert into an Excel file, you can import it into Excel using Power Query.
How to Make a Bar Graph in Excel
This article explains how to make and format a Bar Graph in Excel, where horizontal bars are used to compare different categories of data.
How to Group Worksheets in Excel
You can easily group worksheets in Excel, so you do not have to waste your time and work on them individually.
How to Make a Line Graph in Excel
This article explains how to make and format a line graph in Excel to show trends or track data across multiple time periods.
How to Strikethrough in Excel
The font strikethrough option isn’t readily available on the ribbon, but there are various ways to access the strikethrough effect in Excel.
How to Highlight Duplicates in Excel
This article teaches you how to highlight duplicates values using the conditional formatting feature in Excel.
How to Search in All Sheets in Google Sheets
This tutorial demonstrates how to search for specific words and phrases across all sheets in Google Sheets using Find and Replace tool.
How to Copy a Formula in Excel
Learn how to copy formula to multiple cells, down a column, to non-adjacent cells, copy formulas with absolute or mixed cell references, and more.
How to Convert Time to Decimal in Excel
Convert time to decimal in Excel - by using arithmetic calculations or CONVERT function or Excel Time functions (HOUR, MINUTE, and SECOND).
How to Convert Text to Date in Excel
There are many ways to convert dates formatted as text into actual dates in Excel and this tutorial aims to explore them all.
How to Convert Text to Number in Excel
There are five different ways you can convert numbers that are formatted as text into actual numbers in Excel.
How to Create Gauge Chart in Excel
Since Excel doesn’t offer built-in support for Gauge Chart/Speedometer, you need to create one by combining a doughnut chart and a pie chart.
How to Use COUNTIF in Excel
Excel COUNTIF function allows you to count the number of cells that meet specific criteria or conditions in the given range.
How to Get Today's Date in Excel
Use TODAY and NOW function to get dynamic current date and time, and use keyboard shortcuts to get static date and time.
How to Use 'Not Equal To' in Excel
In Excel, the ‘not equal to’ operator checks if two values are not equal to each other. It can also be combined with conditional functions to automate data calculations.
How to Create a CAGR Formula in Excel
Learn how you can calculate Compound Annual Growth Rate (CAGR) in Excel using operators or different Excel functions.
How to Extract Substring in Excel
Using the Excel TEXT functions LEFT, RIGHT, and MID, you can extract a substring from the left, right, or middle of a text string.