ExcelHow

Category: Excel Examples

How to Convert Absolute Reference to Relative Reference

Excel Basics, Excel Examples

December 17, 2023
How to Add Times Over 24 Hours in Excel

Excel Examples

December 17, 2023
How to Resize All Selected Pictures to Fit Cells in Excel

Excel Examples, Excel VBA

December 17, 2023
How to Rename Multiple Files with VBA Macro in Excel

Excel Examples, Excel VBA

December 10, 2023
How to Rank Data with Multiple Criteria

Excel Examples

December 10, 2023
Find the Largest Value Based on Multiple Criteria

Excel Examples

December 10, 2023
How to Filter Even or Odd Rows in Excel

Excel Examples

December 10, 2023
How to Count Occurrences in Entire Workbook in Excel

Excel Examples

December 10, 2023
How to Replace Last Comma in String with “and” word

Excel Examples

December 10, 2023
How to Print Long Column on One Page in Excel

Excel Examples

December 7, 2023
How to Limit Scroll Area in Excel

Excel Examples, Excel VBA

December 4, 2023
How to Highlight All Non-Blank Cells in Excel

Excel Examples, Excel VBA

December 3, 2023
How to Find and Replace Wildcards like Asterisk/Question Mark/Tilde in Excel

Excel Examples

December 3, 2023
How to Fill a Sequence Number and Repeat Them in Excel

Excel Examples

December 3, 2023
How to Extract multiple match Values into different Columns or Rows

Excel Examples

December 2, 2023
Check If a Value Exists in a Range

Excel Examples

December 2, 2023
How to Count Matches between Two Columns in Excel

Excel Examples

November 30, 2023
How to Return a Value If a Cell Contains a Specific Text in Excel

Excel Examples

November 26, 2023
How to Filter and Select Cells by Color

Excel Examples

November 26, 2023
How to extract word that containing a specific character

Excel Examples

November 26, 2023