How to display pictures that appear to be partially hidden
Thursday, September 24, 2009 12:22 PM
Sometimes, an in-line text picture doesn't display completely--you can see just the bottom of the image. Find out what you can do to correct the problem.
Microsoft Word
How to display pictures that appear to be partially hidden
Duplicates aren't always a bad thing--sometimes they're valid entries. But when they're not, duplicate values return erroneous summaries and totals.
Sometimes, an in-line text picture doesn't display completely. You can see just the bottom of the picture (or clip art). You know the picture's there, but you can't see all of it, as shown below.
Usually, line spacing is the culprit. If a picture doesn't display completely, try this:
- From the Format menu, choose Paragraph.
- Check the Line Spacing. It's probably set to Exactly.
- If so, change the setting to Single, and Word will display the whole picture.
The Exactly setting is a fixed line spacing and Word won't adjust the line to accommodate a picture, or anything else for that matter.
Microsoft Powerpoint
PowerPoint 2010 isn't overburdened with new features
PowerPoint 2010 offers a few new features, but the biggest improvement I have seen is its stability. Preparing for a training class recently, I got a chance to dig into PowerPoint and work out a few slides.
Office 2007 users will notice that the Ribbon has continued into the 2010 release, and much of it is a carryover from the last version. As in other applications, Microsoft has improved the Office menu by changing to a concept called BackStage (discussed in more detail in my Word 2010 overview). This puts the menu in focus when it's selected by the user. Rather than produce a series of slide-out menus, Backstage covers the screen when opened.
PowerPoint's slide recording features for narration and timing have also been improved in the technical preview, making rehearsal of a slide show easier than before. In addition, the animations and transitions seem to get better (or at least different) with every release, which provides some new methods for changing slides.
As I mentioned, I've found the stability of PowerPoint 2010 to be a huge improvement. The application feels better and doesn't seem to dump me out and require a recovery of my files.
Corralling slides
PowerPoint 2010 brings a way to group slides together within a presentation by creating sections. When you create a section, you can hide or display multiple slides at once, reducing the maintenance needed when working on a slide deck. Sections allow slides to be grouped in the sorter view in PowerPoint to make working with and building (or arranging) your content easier.
Note: Sections do not affect the showing of a presentation unless the order of the slide deck is changed by section. If you move section two above section one, the slides will then present in that order.
Figure A shows the slide sorter view with two sections of slides.
Figure A
Sectioned slides
Conclusion
Working with PowerPoint 2010 has been better than PowerPoint 2007, but many of the features are carried over. From what I've seen so far, not much is new. Of course, that could change by the time the final product has released. The application stability is a big plus and a huge step in the right direction for Microsoft.
Microsoft Excel
Hide everything but the working area in an Excel worksheet
You usually hide a column or row to conceal or protect data and formulas. But you can also hide unused regions of a sheet to keep users from exploiting unused areas or to help keep them on task by not allowing them to wander. By hiding unused rows and columns, you present a sheet that focuses on just the work area.
To demonstrate, we'll use the sample worksheet shown in Figure A, which has a small working area and a whole lot of unnecessary rows and columns.
Figure A
To hide unused rows in Excel 2003, select the row beneath the sheet's last used row. (Select the row header to select the entire row.) Next, press Ctrl + Shift + Down Arrow to select every row between the selected row and the bottom of the sheet. Then, choose Row from the Format menu and select Hide.
Repeat this process to hide unused columns, only select the column header in the first empty column. Press Ctrl + Shift + Right Arrow and then choose Column from the Format menu instead of Row.
In Excel 2007, the selection process is the same. However, you'll need to click Format in the Cells group on the Home tab, choose Hide & Unhide, and select Hide Rows (Figure B) and Hide Columns.
Figure B
Note: Before you hide anything, make sure you don't inadvertently hide an obscure area. To find the last cell in the sheet's used range, press Ctrl + End.
Figure C shows our worksheet with the extraneous rows and columns hidden--a cleaner, less busy interface for your Excel users.
Figure C
Restoring the display
If you need to unhide the rows and columns, first select the entire sheet. Then, in Excel 2003, choose Row or Column from the Format menu and select Unhide. In Excel 2007, click Format in the Cells group on the Home tab, choose Hide & Unhide, and select Unhide Rows (or Unhide Columns).
There are currently no comments for this post.