ExcelHow

Author: scott

Color Coded Drop-Down List

Excel Examples

August 16, 2018
Limit Characters Length in a Cell

Excel Examples

August 16, 2018
Extract Part of Text String

Excel Examples

August 15, 2018
Quickly Delete All Picture Objects

Excel Examples, Excel VBA

August 14, 2018
Generate Random Character Strings

Excel Examples

August 14, 2018
Convert Weekday Name to Number

Excel Examples

August 14, 2018
Avoiding Rounding Errors in Floating Point Arithmetic

Excel Examples

August 14, 2018
Add Data Labels in a Chart

Excel Charts, Excel Examples

August 13, 2018
Copy Image from Worksheet to Userform

Excel Examples

August 13, 2018
Sum if Cells Begin with Specific Text or Number in Another Cells

Excel Examples

August 13, 2018
Calculating Future Date

Excel Examples

August 11, 2018
Setting the Starting Page Number

Excel Examples

August 11, 2018
Set Cell Color based on Another Cell Color

Excel Examples, Excel VBA

August 10, 2018
Selecting Diagonal Range

Excel Examples, Excel VBA

August 10, 2018
Move Chart with Arrow Keys

Excel Examples

August 10, 2018
Remove Grand Total in a PivotTable

Excel Examples, Excel Pivot Table

August 9, 2018
Copying Chart with Text Boxes

Excel Charts, Excel Examples

August 9, 2018
Create a Step Chart

Excel Charts, Excel Examples

August 8, 2018
Rank values in a column based a specific value in another column

Excel Examples

August 8, 2018
Break Links to Source Data in Chart

Excel Examples, Excel VBA

August 8, 2018