ExcelHow

Author: scott

How to Limit the Number of Decimal Places in Excel

Excel Examples

February 18, 2019
How to Convert xlsx files to .xls Formats and vice versa in Excel

Excel Examples

February 16, 2019
How to Add or Subtract Weeks From a Date in Excel

Excel Examples

February 12, 2019
How to Select Blank Cells or Nonblank Cells in Excel

Excel Examples

February 1, 2019
How to Change the Orientation of Worksheet in Excel

Uncategorized

February 1, 2019
How to Extract Text between Two Text Strings in Excel

Excel Examples

January 31, 2019
How to Insert or Delete a Header or Footer in Excel

Excel Examples

January 31, 2019
How to Create a Button to Go to a Certain Worksheet in Excel

Excel Examples, Excel VBA

January 30, 2019
How to Filter for Multiple Criteria in Excel

Excel Examples

January 30, 2019
How to Average by Day/Month/Quarter/Year with Pivot Table in Excel

Excel Examples

January 29, 2019
How to Delete Numbers after Decimal Point in Excel

Excel Examples

January 28, 2019
How to Convert Date to YYYY-MM-DD format in Excel

Excel Examples

January 28, 2019
How to Add a Plus Sign before Positive Numbers in Excel

Excel Examples

January 28, 2019
How to Hide/show Page Breaks in Excel

Excel Examples

January 28, 2019
How to Transpose Rows and Columns in Excel

Excel Examples, Excel VBA

January 26, 2019
How to Reverse the Order of Rows in Excel

Excel Examples, Excel VBA

January 22, 2019
How to Calculate Percentage Change between Two Numbers in Excel

Excel Examples

January 22, 2019
How to Extract Unique Values in a Selected Range in Excel

Excel Examples

January 21, 2019
How to Highlight Dates Older Than 30 Days in Excel

Excel Examples

January 21, 2019
How to Change Column Width and Row Height in Excel

Excel Examples, Excel VBA

January 16, 2019