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
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
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
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
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
The ruler is a great way to ensure that your reports print accurately or your form controls are right where you want them. However, you may not know exactly what measurement units Access’ ruler indicates. If you’re more comfortable with the metric system (centimeters instead of inches), you can adjust your ruler permanently. Or, if…
Details
To change the alignment of a paragraph, you can click the Align Left , Center , Align Right , or Justify buttons on the Formatting toolbar (the Home tab’s Paragraph group in Word 2007 and 2010). You can also select Format | Paragraph, click on the Indents And Spacing tab, and choose the desired setting…
Details
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
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
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
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
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
If you’re editing a large document that also includes a number of images, you may find that scrolling is quite slow. This happens because Word has to load each image as you scroll, which can make your productivity drag. Fortunately, if you display picture placeholders rather than your actual images, you won’t have to worry…
Details
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
The Go To dialog box allows you to immediately move to any page, section, line, bookmark, comment, footnote, endnote, field_, table, graphic, equation, object, or heading in your document. You can use any of the following four methods to access_this dialog box: Menu bar. Select Edit | Go To from the menu bar. (In Word…
Details