Excel Examples

How to Select Entire Column except Header Row in Excel

This post will guide you how to select entire column except header or first row in Excel 2013/2016. How do I select whole column except first header cell with VBA Macro in Excel. How to use shortcut keys to select entire column in Excel. Select Entire Column except Header Row with Shortcut Select Entire Column… read more »

How to List Only Whole Numbers From Decimal Numbers in Excel

This post will guide you how to filter only whole numbers from decimal numbers in a list in Excel. How do I filter cells with whole numbers or non-whole numbers in Excel. List Only Whole Numbers Assuming that you have a list of data in range A1:A6, which contain decimal numbers and whole numbers. And… read more »

How to Transpose Cross Tab to Flat Table in Excel

This post will guide you how to convert cross table to list in Excel 2013/2016. How do I transpose cross table to flat table with VBA Macro in Excel. CrossTab (cross table) is a two-dimensional table with a horizontal header row and a vertical header row. Assuming that you have a list of data in… read more »

How to Lookup Values from Right to Left in Excel

This post will guide you how to vlookup values from right to left in your worksheet in excel. How do I look up values to left column with a column in Excel 2013/2016. How to use Vlookup function to extract the corresponding value of the left column in your worksheet in Excel. Lookup Values to… read more »

How to Fill Blank Cells with Linear Values in Excel

This post will guide you how to fill blank cells in a range with linear values in Excel. How do I fill up empty cells by linear interpolation in Excel 2013/2016. Fill Blank Cells with Linear Values Assuming that you have a blank cells in a range (B1:G1), and you want to fill blank cells… read more »

How to Round Time to Nearest Hour or Minute or Second in Excel

This post will guide you how to round time to nearest hour with a formula in Excel. How do I round off time values using the MROUND function in Excel. How to round time to the nearest minute or quarter hour in Excel. Round Time Values to Nearest 15 minutes Round Time Values to Nearest… read more »

How to Convert Military Time to Standard Time in Excel

This post will guide you how to convert military time to standard time with a formula in Excel. How do I convert from military time 17:29:30 to regular time 5:29:30PM in Excel.  How do I Convert Standard time to military time with a formula in Excel. Convert Military Time to Standard Time Convert Standard Time… read more »

How to Convert a String into a Formula in Excel

This post will guide you how to convert a string into a formula in Excel. How do I turn test strings to a formula for calculation. Convert a String into a Formula Assuming that you have a list of data in range C1:C4, which contains text string (Actually, they are all formulas, but they are… read more »

How to Copy Only Comments from Cells in Excel

This post will guide you how to copy only comments from a cell in Excel 2013/2016. How do I copy cell comments to another cell with VBA Macro in Excel. Copy Cell Comments with Paste Options Copy Cell Comments with VBA Copy Cell Comments with Paste Options To copy cell comments from a selected range… read more »

Sidebar