ExcelHow

Category: Excel Examples

How to Find and Replace Multiple Values

Excel Examples, Excel VBA

January 9, 2024
How to Display User-Defined Text in All Blank Cells in Excel

Excel Examples

January 8, 2024
Comparing Columns Using Conditional Formatting Icon Sets

Excel Examples

January 7, 2024
Adding Data Points to an Existing Line Chart

Excel Charts, Excel Examples

January 7, 2024
How to Sum if Contains an Asterisk

Excel Examples

January 7, 2024
How to Sum Every Nth Row or Column

Excel Examples

January 7, 2024
How to remove first and last characters from text string

Excel Examples

January 7, 2024
How to Lock Hidden Columns in Excel

Excel Examples

January 7, 2024
How to get the position of Last Occurrence of a character or string in a cell

Excel Examples

January 4, 2024
How to Find Most Common Value in a Range in Excel

Excel Examples, Excel VBA

January 4, 2024
How to Count Cells that Contain negative Numbers in Excel

Excel Examples

January 3, 2024
How to Convert date to month and year only in excel

Excel Examples, Excel Text Functions

January 2, 2024
How to Calculate Grades With VLookup in Excel

Excel Examples

December 28, 2023
How to Break Chart Y Axis

Excel Charts, Excel Examples

December 27, 2023
How to VLOOKUP Return Multiple Values Horizontally

Excel Examples

December 24, 2023
How to Split Data into Multiple Worksheets with Set Number of Rows in Excel

Excel Examples, Excel VBA

December 24, 2023
How to Reverse First Name and Last Name

Excel Examples

December 24, 2023
How to Copy Formula without Changing Cell References

Excel Examples

December 24, 2023
How To Sum the Largest N Values in Excel

Excel Examples

December 17, 2023
How to Count Cells that are Case Sensitive

Excel Examples

December 17, 2023