Excel ROWS - Free Excel Tutorial

How to Convert Horizontal List of Data into Vertical in Excel

June 21, 2019

This post will guide you how to transpose horizontal list to vertical list in your current worksheet in Excel. How do I convert horizontal rows to vertical columns with a formula in Excel 2013/2016. Convert Horizontal List to Vertical with a Formula Convert Horizontal List to Vertical using Paste Special Feature Assuming that you have… read more »

Copy and Paste Only Non-blank Cells

September 5, 2018

This post will guide you how to copy and paste only non-blank cells in Excel 2013/2016. How do I copy only non blank cells with VBA code in Excel. Or how to get non-blank cells from a range of cells with a formula in Excel. This post will introduce four methods to copy and paste… read more »

Split Data in One Column to Multiple Columns

August 30, 2018

This post will guide you how to split data in a single column into multiple columns with a formula in Excel. How do I transpose data from one column to multiple columns in Excel. How can I make one long column into multiple columns in Excel. Split Data in One Column to Multiple Columns Assuming… read more »

List all Worksheet Names

August 20, 2018

This post will guide you how to get a list of all worksheet names in an excel workbook. How do I List the Sheet names with Formula in Excel. How to generate a list of all sheet tab names using Excel VBA Code. Assuming that you have a workbook that has hundreds of worksheets and… read more »

Randomly Select Cells

January 21, 2019

This post will guide you how to randomly select cells from a list or table in Excel. How to get random value form a range of cells in an Excel Spreadsheet. Assuming that you have a list of data (B1:B7) in a worksheet, and you want to get 3 random cells or values from those… read more »

Flip a Column of Data Vertically

June 19, 2018

This post will guide you how to flip a column of data vertically preserving the original formatting and formulas in Excel. How do I reverse a column of data order in a column arranged alphabetically or from largest to smallest. How to use the Excel Sort feature to reverse the data order? Or how to… read more »

How to Reverse a List or Range

December 8, 2017

This post will guide you how to reverse a list of values or a range of values in excel. How to reverse the order of a column data or a list of items using excel formula. How to reverse a range with sort command. How to reverse a list or column value with VBA. Reverse… read more »

How to Extract multiple match Values into different Columns or Rows

December 8, 2017

This post explains that how to extract multiple match values from a range, then put the values into the different columns in excel. And how to extract multiple matches into the different rows. In the previous post, we talked that how to get the position of the nth occurrence of a value in a column,… read more »

Three Ways to Get the Last Row Number in a Range

December 11, 2017

This post explains that how to get the last row number in a range or a table in excel. Sometimes, you want to know the last row number for a excel range. The below will guide you how to get the last row number in range using excel formula through the following three ways: Get… read more »

Excel Rows Function

September 5, 2018

This post will guide you how to use Excel ROWS function with syntax and examples in Microsoft excel. Description The Excel ROWS function returns the number of rows in a cell reference. The ROWS function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The ROWS function is available… read more »