Excel Basics

How to Auto Update Current Time in Excel (3 Easy Ways)

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

How to Delete Blank Columns in Excel (4 Quick Ways)

In this article, we will learn about how you can delete blank columns in Excel. Blank columns can create problems while formula calculation or ...

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

This tutorial will demonstrate how to merge and center cells in Excel. When we are dealing with many columns or rows, we have to merge the values to ...

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

To show and hide the Formula Bar in Excel: Go to the View tab > Show group. Mark the Formula Bar checkbox to show it. Unmark the ...

How to Copy Formatting in Excel to Another Sheet (3 Easy Ways)

In this article, we’ll show you how to copy formatting to another sheet of the same workbook in Excel. Font, Number, Date types; Alignment; Bold, ...

How to Copy Multiple Sheets to New Workbook in Excel (4 Ways)

Excel plays a great role for professionals. Excel provides lots of functions and formulas for different problems. But for some problems, there are no ...

How to Remove Space in Excel Before Numbers (3 Easy Ways)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

How to Use SUM Formula Shortcut in Excel (2 Simple Ways)

The SUM function is one of the basic and most frequent functions available in Excel. We use this function to add up values within any range of cells. ...

How to Multiply a Column by a Number in Excel (3 Easy Methods)

We often use multiplication in Excel. There are several ways for performing this task. In this article, I’ll show 3 easy methods to multiply a column ...

How to Use Sheet Name in Dynamic Formula in Excel

Sometimes depending on the scenario, you may need to use worksheet names in the formula, providing the sheet name manually is a tedious task. To ...

How to Use Format Painter for Multiple Cells in Excel (7 Methods)

Format Painter is one of the most versatile tools of Excel. By using the Format Painter, we can format a countless number of cells just with one ...

How to Copy Excel Sheet to Another Sheet with Same Format

In Microsoft Excel, there are several methods to copy an Excel sheet to another sheet with the same format. In this article, I’ll show 4 quick ...

How to Merge Two Rows in Excel (4 Easy Ways)

In this article, I am going to discuss the available methods offered by Excel to merge two consecutive rows into one single row. Suppose, I have a ...

Editor choice How to Merge Two Rows in Excel (4 Easy Ways)

How to Copy Rows in Excel (7 Easy Ways)

Copying and pasting are two of the most frequent tasks that we do while working with a dataset in Excel. To better deal with the dataset and access ...

How to Merge Cells Vertically Without Losing Data in Excel

Sometimes, you need to merge cells in Excel vertically without losing the data. It is one of the most important and widely used tasks. There are ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo