Have you ever had the need to print each column header in Excel 2010 on every page in the workbook, here is how you can do this.
Various how to, help, tutorials and tip articles about all version of Excel, Word, PowerPoint, Outlook, Access and other Microsoft Office Products.
When working with a workbook or spreadsheets you might want to print first row on every page in Excel 2010. Here is how to do this.
We have shown you how to get the Column number from Excel 2007 using the Column Function. But what if you need the actually letter for a macro in your VBA code? Here is how you do it. Here is the Code, don’t worry I’ll explain in a second: Sub Convert_Column_Letter() Dim MyColumn As String, […]
Excel Column Function lets you return the number associated with a Column. For example Column(B2) would return 2 since B is the 2nd column.
We all know that Microsoft Word 2007 will automatically check if a word is spelled right or has proper grammar. What if you intentionally spell something wrong, or it isn’t added to your custom dictionary, you have to look at those horrible red and green squiggle lines. The horror! Here is how to remove them. […]
In Word you can have a hanging indent. A hanging indent is where the first line sticks out while the rest of the paragraph is indented.
Have you ever wanted to just pull the month from a date in your Microsoft Access tables and use them for other calculations. You could spend countless hours trying to write macros and what not when you can just use the month function. With the help of the month function, you can easily pull out […]
We have shown you How to Require a Password to Open an Excel 2010 or 2007 Workbook, but what happens if you have Excel 2003? You missed the upgrade and I didn’t write a way for you to stop all those peeping Toms from staring at your precious workbook? Well don’t worry about it! Here is a great and easy way to set a password to open or modify an Excel workbook from 2003-2010.
In the past, or a couple of days ago, we have shown you How to Protect and Unprotect an Excel Workbook , Excel 2007, but this doesn’t stop someone for looking at your, or yet opening your Excel file. That can be quite a bother if you don’t want them stealing your information! Here is how you can stop them from even looking at your precious Excel file by Encrypting it with a password in Excel 2010 or 2007.
If you use Outlook heavily like me, then you probably now how much of a pain it is to open Mail, then Calendar, then Task, and vice versa. Even opening your Calendar in different windows can be a hassle at time, especially for me. Here is a quick and easy way to have your inbox, contacts, and more on the desktop with Outlook On the Desktop.