This tutorial provides an overview of Conditional Formatting in Excel and Google Sheets. Or, scroll to the bottom of the page for 70 tutorials on using Conditional Formatting. Conditional formatting is a very powerful feature that allows you to automatically apply specific formatting to cells that meet certain criteria and emphasize key attributes of a… Continue Reading
This article will demonstrate how to fix the VBA Run Time Error 57121. It’s often difficult to determine the cause of a VBA run time error 57121. The error can occur on one machine but not on another. This brings us to believe that the error is to do with the actual machine rather than… Continue Reading
This article will demonstrate how to fix the VBA Error: Compile Error in Hidden Module. The VBA Compile Error in Hidden Module occurs when you are using a VBA macro in Excel which is stored in a hidden module. This might be due to the fact that you are using an External Add-in, or you… Continue Reading
This article will demonstrate how to fix the VBA Compile Error: Can’t Find Project or Library. The VBA Compile Error – Can’t Find Project or Library occurs when your VBA code refers to an external project or library that cannot be found on the user’s PC. To fix this, make sure that the reference exists… Continue Reading
This article will demonstrate how to fix Excel VBA Error 400. Error 400 occurs while a VBA macro is running, usually causing the macro to crash and stop running. It is a very annoying error that can be quite difficult to resolve but by following the methods below you can hopefully solve your problem! Ensure… Continue Reading
This tutorial demonstrates how to delete hidden rows and columns in Excel. Delete Hidden Rows and Columns There are several ways to delete entire rows and/or columns in Excel, but sometimes the cells you want to remove are hidden. To delete hidden rows and columns in your file, use the Document Inspector. Say… Continue Reading
This tutorial demonstrates how to send a mass email from a list in Excel and Google Sheets. Collaborating between Excel and Word allows you to send bulk emails from a list in Excel automatically by using the Word mailing feature. Create Mailing List Set up mailing fields in Excel by creating a list… Continue Reading
This tutorial demonstrates how to insert a drop-down calendar with the date picker control in Excel. There are numerous ActiveX controls available to be used in Excel, but they are not obviously available, and many users are not aware that they even exist. To insert the calendar ActiveX control into Excel, enable the Developer tab… Continue Reading
This tutorial demonstrates how to compare two files for differences in Excel and Google Sheets. Compare Files Side by Side One option to compare is to look at the files on the same screen. Open two files you want to compare, then in the Ribbon, select View > Window > View Side by Side. … Continue Reading
This tutorial demonstrates how to use the Watch Window in Excel. Add Cells to Watch Window In Excel, with the Watch Window feature, you can select cells and watch for changes in their formulas. This is helpful when you are working with large data sets, because you can easily inspect cells without the need to… Continue Reading