Steve Scott Articles

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 »

Switch First and Last Name with Comma in Excel (Reverse Names)

Click here to Read More »

How to Move Pivot Table in Excel?

Click here to Read More »

How to Remove Year from Date in Excel?

Click here to Read More »

How to Remove Blank Columns in Excel? (Formula + VBA)

Click here to Read More »

How to Rename a Table in Excel?

Click here to Read More »

How to Sort by Length in Excel? (Formula)

Click here to Read More »

How to Remove Borders in Excel?

Click here to Read More »