We have shown you how to print the first row on every page in Excel, but what if you wanted a column instead? Let say you have a table and you have a header column, instead of a row, that you want to print out on each page. Don’t worry we will show you how [...]
Archive | Microsoft Office RSS feed for this section
How to Print First Row or Header Row on Every Page in Excel
Sometimes when you use Excel you might have data on multiple pages and you have a header row you want on the top of the first page. So you do the typical and froze the pans so you can always see the header. The only problem is when you print it out, you will only [...]
How to Get the Column Letter in VBA for Excel
We have shown you how to get the Column number from Excel 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, [...]
How to Use Microsoft Excel Column Function
In Microsoft Excel, if you want to get the Column number you would use the Column Function. Here is the syntax for it: Column ( reference ) Reference is optional, if it isn’t specified, the Column Function will reference the cell it is in. Here are some example: If you entered in a Reference, like [...]
How to Remove Spelling and Grammar Squiggle Lines from Word 2007
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. [...]
How to Make a Hanging Indent in a Word 2007 Paragraph
Word 2007 can hang the indentation of every paragraph you type. A hanging indent is an indentation where the first line sticks out to the left and the rest of the paragraph is indented. To do this we just need to enable a few simple steps. First go the the beginning of a paragraph you [...]
How to Get the Month from a Date Column In Microsoft Access
Have you ever wanted to just pull the month from a date in your Microsoft Access tables? Here is a quick and easy way to do this using the Month function built into access. Below is the table we are going to be using: We will convert the DATE column into a Month column and [...]
Set a Password to Open or Modify a Workbook in Excel 2003, 2007 or 2010
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.
Require a Password to open an Excel 2010 or 2007 Workbook
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.
Quickly and Easily View Outlook 2010 Inbox, Contacts, Calendar, Notes, and Tasks On the Desktop
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.
How to Protect and Unprotect an Excel 2007 Workbook
In Excel 2007 you have the ability to protect your workbook so others can’t make changes on the layout of the worksheets in the workbook. When protecting you can even assign a password so only those who have it can edit the workbook. So lets protect a workbook in Excel 2007. Protecting a workbook First [...]
Windows 7
Windows Vista
Windows XP
Linux
Microsoft Office
Mobile
Web
Wallpaper
