ExcelHow

Author: scott

Finding the Max and Min value in an Alphanumeric Data

Excel Examples

July 11, 2018
Using Data Validation to Limit Calculated Cell

Excel Examples

July 10, 2018
Creating Win/Loss Sparkline Chart

Excel Charts

July 9, 2018
Highlight Cells That End with Specfic Characters

Excel Examples

July 6, 2018
Click or Double Click Cell to Show userform

Excel Examples

July 5, 2018
Get Cell Value Based on Row and Column Numbers

Excel Examples

July 5, 2018
Highlight Multiples of Specific Value

Excel Examples

July 3, 2018
Format Cells using Shortcuts

Excel Examples

July 2, 2018
Open Worksheet by Double Click on a Cell

Excel Examples

July 2, 2018
Add a Moving Average Line to a Chart

Excel Examples

July 2, 2018
Count Cells That Contains Text or Specific Text

Excel Examples

June 29, 2018
Quickly Get Sheet Name

Excel Examples

June 28, 2018
Split Text and Numbers

Excel Examples

June 28, 2018
Lock Formulas

Excel Examples

June 27, 2018
Show or Hide Formula Bar

Excel Examples

June 26, 2018
Adding a horizontal Average Line to a Chart or Graph

Excel Examples

June 26, 2018
Save Selection or Entire Workbook as PDF

Excel Examples

June 22, 2018
Find Links or External References

Excel Examples

June 20, 2018
VLOOKUP Values from Multiple Worksheets

Excel Examples

June 20, 2018
Convert Data to Weekday name or Month Name

Excel Examples

June 12, 2018