Insert Dates in Excel

result month auto

This tutorial covers how to insert dates in Excel. The Date Format Like numbers, currency, time and others, the date is a quintessential number format in Excel. Though Excel tries its best to auto-recognize data types, it doesn’t always succeed. To manually apply the date format to a cell or group of cells, select the…

Read More

Cell References

mixed ref

In order to make accurate calculations it’s essential to understand how the different types of cell references work. A1 vs. R1C1 References Excel worksheets contain many cells and (by default) each cell is identified by its column letter followed by its row number. This is known as A1-style referencing. Examples: A1, B4, C6 Optionally, you…

Read More

Working with Page Breaks in Excel & VBA

remove column page breaks excel vba

If you don’t manually set Page Breaks, Excel will do it’s best to set appropriate Page Breaks. However, if you’ve ever tried to print an Excel spreadsheet, you know it generally does not do a good job. Any time you print a spreadsheet you should review and edit the Page Breaks before printing. Page Break…

Read More

How to Spell Check in Excel & VBA

how to spellcheck in excel vba

This tutorial will demonstrate how to use spell check in Excel and in VBA. Spell Check in Excel Microsoft Excel offers a basic spelling function that can help you check your spelling on any spreadsheet that you produce. This function is very limited, in relation to the spell check function in Microsoft Word or Microsoft…

Read More

Print Comments in Excel

Excel allows you to display comments on the screen, but by default the comments will not print with your spreadsheets. This tutorial will teach you several different methods to print comments in your spreadsheets. Print Comments – Review Ribbon Method: 1. If you have more than one worksheet, select the one that contains the comments…

Read More