Steve Scott Articles

How to Freeze the Top Row and First Column in Excel?

Click here to Read More »

How to Round Time to the Nearest Quarter Hour in Excel?

Click here to Read More »

How to Remove First Character in Excel?

Click here to Read More »

How to Translate in Excel? (Text/Formulas)

Click here to Read More »

Subscript Out of Range Error in VBA – How to Fix!

Click here to Read More »

How to Copy Column Widths in Excel?

Click here to Read More »

Pivot Table Field Name is Not Valid – How to Fix?

Click here to Read More »

Row vs Column in Excel – What’s the Difference?

Click here to Read More »

How to Delete Defined Name in Excel? (Name Manager + VBA)

Click here to Read More »

How to Remove the Last Digit in Excel?

Click here to Read More »

How to Fix #NUM! Error in Excel?

Click here to Read More »

How to Convert Date to Serial Number in Excel?

Click here to Read More »