Advanced users of Microsoft Office will want to have the Developer tab showcased on the Ribbon of Word or Excel programs at all times. However, that tab is not shown by default, which means it can be ...

How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good news ...

Last week I told you how to add a tabbed e-mail view to Microsoft Outlook. Cool, right? Of course, that probably left you salivating for tabs in other areas of Office, namely Word, Excel, and ...

When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window. When you edit the page code, the name isn't always so obvious. Although the Visual ...

Freeze Panes in Excel solves this problem completely. It locks specific rows and columns in place so they remain visible no matter where you scroll. To set it up, go to the View t ...

In many cases, you want people to enter a valid date, and no other type of information, when they're putting data into a cell in Microsoft Excel. For example, you might be asking people to record days ...