COLUMN Function

How to Record Time of Data Entry in Excel (2 Effective Ways)

Excel provides us with a wide range of facilities to handle a large amount of data and work with them. When entering data into an Excel sheet, we ...

How to Create Table from Another Table with Criteria in Excel

When working with Excel tables, sometimes we need to create another table from the existing tables based on criteria. In this article, I will show ...

How to Select Every Other Column in Excel (3 Methods)

Microsoft Excel is one of the most widely used applications in today's world. It is very popular with individuals and small & medium business ...

How to Find Column Index Number in Excel VLOOKUP (2 Ways)

We all know that the VLOOKUP function in Excel has 4 arguments. One of them is the col_index_num. i.e. column index number. Finding the column index ...

How to Insert Date in Excel That Updates (5 Easy Methods)

Often while working in Excel, we may need to insert a date that can be updated automatically or that inserts automatically while inserting new data. ...

How to Copy Cell Address in Excel (5 Simple Ways)

Whenever working with Excel you might face a situation where you will need to copy a cell address. If you are looking for a way to copy cell address ...

How to Add Time in Excel Automatically (5 Easy Ways)

Looking for ways to know how to add time in Excel automatically? Sometimes, we want to add the time when the file was last edited, or any value was ...

How to Move Every Other Row to Column in Excel (6 Ways)

Sometimes we need to move every odd or even row to other cells in the worksheets. Obviously, it can be done manually. But if the worksheet size is ...

How to Skip Every Other Column Using Excel Formula (3 Methods)

Sometimes you need to skip every other column in Excel. Using Excel Formulas, you can do such a job in a few moments. In this article, we will show ...

How to Reverse Order of Columns Vertically in Excel (3 Ways)

You may sometime need to flip or reverse the order of columns vertically or horizontally while working with datasets in Excel. This can be necessary ...

How to Convert Column Letter to Number Chart in Excel (4 Ways)

While working on a large dataset or a series of datasets where those takes up so many rows in a spreadsheet, it is a very common situation where we ...

How to Highlight with Cursor in Excel (3 Suitable Ways)

If you are looking to highlight the cursor position before entering data into the cell or working with a lot of data are at risk of losing track of ...

How to Insert Excel Date Stamp When Cells in Row Are Modified

This tutorial will demonstrate how to insert an Excel date stamp when cells in a row are modified. Sometimes we need to track the activities of a ...

How to Drag Formula Horizontally with Vertical Reference in Excel

Sometimes you might need to drag the formula horizontally with the vertical reference. In other words, you have to utilize the Fill Handle Tool for ...

How to Reverse Transpose in Excel (3 Simple Methods)

We all know about transposing in Excel. What about reverse transpose? It is slightly a different concept. In this web post, we will see How to ...

ExcelDemy
Logo