How to Insert Date in Excel Formula (8 Ways)

Excel can store date values as a different category of its own. Dates starting from 1st January 1990 follow this pattern. You can write dates ...

How to Insert Drop Down Calendar in Excel (With Quick Steps)

This drop-down calendar is only available in Microsoft Excel 2007 and 32-bit versions of Excel 2010, 2013, and 2016. Use a third-party add-in for ...

Excel VBA to Filter in Same Column by Multiple Criteria: 6 Methods

Method 1 - Remove Specific Values with VBA to Filter in the Same Column by Multiple Criteria in Excel STEPS: Right-click on the worksheet tab ...

How to Extract Text After First Space in Excel (3 Suitable Ways)

This guide will use the sample dataset pictured below. Method 1 – Merging MID Function With FIND Function to Extract Text After the First ...

How to Auto Sort in Excel Without Macros: 3 Methods

Method 1 - Use of SORT Function to Auto Sort in Excel Introduction to the SORT Function The SORT function in Excel returns a sorted range of ...

How to Sort Dates in Excel by Month and Year (4 Methods)

Method 1 - Applying the TEXT Function to Sort Dates by Month and Year Steps: Make columns for Months and Dates. Enter the following ...

How to Insert Day and Date in Excel – 3 Methods

This is the sample dataset. Method 1 - Using the TEXT Function to Insert Day and Date Steps Select Cell C5 and enter the following ...

How to Move Columns in Excel without Overwriting (3 Methods)

While working in Excel, sometimes we need to move columns for many reasons like if we do a mistake to arrange columns or maintaining the chronology. ...

VBA to AutoFilter with Multiple Criteria on Same Field in Excel: 4 Methods

Method 1 - Embed VBA to AutoFilter with Multiple Numeric Criteria on the Same Column Steps: Press Alt + F11 on your keyboard or go to the tab ...

How to Insert Date in Footer in Excel (3 Ways)

Footer is often used in our professional life. Some people use their organization's name as a signature mark while some use their own name. Sometimes ...

How to Hyperlink to Cell in Same Sheet in Excel (5 Methods)

To demonstrate our methods, we’ll use the following dataset. Method 1 - Using Insert Link Feature Steps: Select cell B12. From the ...

How to Print Horizontally in Excel (4 Methods)

When users have a larger dataset it’s convenient to print horizontally in Excel. Though Excel by default prints worksheets in Portrait Page ...

How to Insert a Column to the Left in Excel (6 Methods) 

We'll use a simple dataset where the Number of Visits for each website is provided along with the Names and Categories of the Sites. We want to add a ...

Extract Filtered Data in Excel to Another Sheet: 4 Methods

Method 1 - Extract Filtered Data to Another Sheet Using Copy-Paste Method in Excel If you don’t need to perform additional table transformations ...

How to Space Down in Excel: 3 Methods

Method 1 - Using Shortcut to Space Down in Excel Steps: Double-click on Cell C5 and click before the text 1994 as we want to space it down, and ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo