Excel Basics

How to Lock a Cell in Excel Formula (2 Ways)

In Excel, we use formulas to perform various kinds of operations incorporating cell references, operators, and functions. Speaking about Cell ...

Percentage Formula in Excel (6 Examples)

In Microsoft Excel, we can use different methods to calculate the percentage of a numeric value with a formula. We can apply algebraic calculations ...

How to Delete Multiple Rows in Excel (3 Methods)

Maintaining a dataset is usual work in the corporate world. Deleting multiple rows is included in it and is required most frequently. This article ...

How to Delete Every Other Row In Excel (4 Methods)

You may need to delete unwanted rows from your worksheet while you are recording data or compiling data from different resources. Your unwanted rows ...

How to Calculate Difference Between Two Dates and Times in Excel

If you want to find out the difference between two dates or times in excel, you will find this article useful. Here you can find how to find out the ...

Reference Another Sheet in Excel (3 Methods)

We mostly work with data in Excel. When calculating data in Excel, we often find situations where we need to pull data from one worksheet to another ...

How to Delete a Sheet in Excel (5 Ways)

Deleting a sheet is necessary when you don’t need a sheet, or you might need to remove useless sheets. This tutorial will show you how to delete a ...

How to Auto-Update Current Time in Excel (With Formula and VBA)

While working in Excel, we often have to enter the current date and time in a cell for various purposes and auto-update them. Today I’ll show you how ...

Delete Blank Columns in Excel (3 Ways)

This article will show you how you can delete blank columns in Excel in three effective and easy ways. Download Workbook You can download the ...

Multiplication Formula in Excel (6 Quick Approaches)

Excel formulas are made for us to calculate problems easily. But there is no fixed multiplication formula in Excel. Today we are going to see some ...

How to Merge and Center Cells in Excel (3 Easy Methods)

How to Merge Cells in Excel Vertically Without Losing Data How to Merge Cells in Excel with Data (3 Ways) When an entry occupies more than one ...

Editor choice How to Merge and Center Cells in Excel (3 Easy Methods)

How to Show and Hide Formula Bar in Excel (3 Methods)

Excel formula bar is a tool that can be used to edit any cell values applying a formula. By default, the formula bar is visible in Excel directly ...

How to Copy Formatting in Excel to Another Sheet (4 Ways)

Font, Number, Date types;  Alignment; Bold, Italic Headings; Coloring; Designing; Size of cells; etc. are different kinds of formats available in ...

Editor choice How to Copy Formatting in Excel to Another Sheet (4 Ways)

Excel Current Date Formula (with 11 Easy Examples)

To get the current date in Excel, you generally have to utilize the TODAY() formula. This article will show you the various ways of how to apply the ...

Remove First Character from String in Excel (4 Ways)

Many times, you need to remove the first character from a string of your database in Excel. The article will help to know 4 different ways to remove ...

ExcelDemy
Logo