Display table headings at the top of every page in MS Word

When you create a lengthy table, Word doesn’t display the table’s headings (i.e., the table’s first row) at the top of each page that contains a portion of the table. This can make multi-page tables hard to read. However, you can easily configure Word to repeat a table’s heading row wherever the table breaks across…

Details

Several ways to quickly select a Word table

When working with tables, you often have to select the whole table to perform actions such as applying formatting or deleting the table. Actually, there are several methods you can use to select the entire table. Here’s a collection of your choices. To select a Word table, do one of the following: Place the insertion…

Details

Several ways to quickly select a Word table

When working with tables, you often have to select the whole table to perform actions such as applying formatting or deleting the table. Actually, there are several methods you can use to select the entire table. Here’s a collection of your choices. To select a Word table, do one of the following: Place the insertion…

Details

Display table headings at the top of every page in MS Word

When you create a lengthy table, Word doesn’t display the table’s headings (i.e., the table’s first row) at the top of each page that contains a portion of the table. This can make multi-page tables hard to read. However, you can easily configure Word to repeat a table’s heading row wherever the table breaks across…

Details

Give your slicers a face lift (2010)

Excel 2010’s new PivotTable filters, slicers, can give your worksheet a dashboard-like feel. While your slicers have their own tab on the Ribbon that lets you control a great deal about how they look and operate, you might have noticed something missing. There’s no group for adjusting a slicer’s font settings. Fortunately, you can change…

Details

Tired of that color scheme? Give Excel a new color scheme

Excel 2007 and 2010 give you a lot of new visual options when it comes to building a spreadsheet. You can apply themes to your data and use new shape effects and conditional formatting looks. But what about your Excel application itself? Believe it or not, you don’t need to stick with Microsoft’s traditional blue…

Details

Eight time-saving Excel shortcuts

Excel has lots of useful shortcut keys that perform various actions. The more you know, the more time you can save. Here are seven shortcuts we hope you find useful: To enter the current date into the active cell, press [Ctrl];. To enter the current time, press [Ctrl][Shift];. To enter or edit a cell comment…

Details

Recover unsaved workbooks (Excel 2010)

We’ve all done it before—either you forget to save a workbook, you accidentally save it when you should have saved it as a different name, or maybe you lose work because of that rare power outage. Whatever the cause, there’s no need to panic when you think you’ve lost your work in Excel 2010. You…

Details

Click away with Excel 2010’s new Screenshot feature

Software has become pretty user friendly, but there are times when you wish you could just click-and drag between software programs. For instance, maybe you want to capture a news headline for the date of your stock portfolio spreadsheet. The Internet changes so quickly that you might not know or remember what the news headlines…

Details

Edit Excel 2010 charts in record time

Editing an Excel chart was never an easy process prior to Excel 2010. For instance, if you wanted to edit a data series, you had to click on it to select it, right-click on it, and then choose Format Data Series from the shortcut menu in order to finally get to the Format Data Series…

Details

Combat bounced email with these troubleshooting tips (MS Outlook)

Although your company higher-ups can read your email and block it, most likely, you’ve run into a different problem. While we strongly caution against sending personal email from your work account, the bottom line is that your email system isn’t working as it should. We’ll go through the most common culprits behind returned, or bounced,…

Details