MS-Excel - General Formatting Tutorials

Keep prying eyes from viewing a worksheet, unless they have the password.

One of the most commonly used functions in Excel, sorting is usually performed on a list, table, or range of cells, but you can take things a step further and sort your worksheets as well.

It's quite common for Excel users to want to save an Excel file with a filename that corresponds to the text in a worksheet cell. This can be done with the help of a small amount of code inserted into a module.

Enhance Excel's Find feature to search for the first occurrence of a number that falls between two specified numbers.

Use a bit of Excel VBA macro code to create a list of hyperlinked Excel workbook names on any Excel worksheet.

Enter a static date, or date and time, into a corresponding cell after data is entered into other cells.

Although you can distribute a macro along with a workbook, if you want to distribute only the macro's functionality, an Excel add-in is the way to go.

Excel macros are a great way to save time and eliminate errors. However, sooner or later you might try to run your favorite Excel macro on a worksheet that has been protected, with or without a password, resulting in a runtime error. Avoid that problem wi

You can use VBA to tutorial conditional formatting to use more than three criteria on your data. In fact, you can use the code to apply virtually an unlimited number of criteria.

Every now and then you might want a cell to return the name of a workbook, or even the workbook's filename and path. With this tutorial, it's easy to retrieve a workbook's name and path.