To add Group and Outline in MS Excel 2007, follow the steps below:
To clear groups and outlines, select the same cells and select Data | Ungroup in the Outline group.
Using MS Excel’s Paste Special options can make use of your creative talents.
It is often possible to save a lot of work by combining several operations in consecutive Paste Special actions. For instance, select All Except Borders to copy formulas and cell formatting without adding underlines and table borders from the original data.
Then repeat the Paste Special option and select the Column Widths option.
This will duplicate an entire table on a new worksheet, leaving out only the borders and underlines!
Some folks use Notepad to create quick notes to themselves and then save the file on their desktop. While the process is pretty simple, there is an alternative that you may want to investigate. Creating scraps is as easy as a quick drag and drop operation and there is no need for all the steps involved in naming and saving the file.
Follow the steps below:
Once you drop the selection on your desktop, Windows XP recognizes the selection as an OLE object from WordPad and creates a scrap, complete with a special icon with a default title name of Scrap.
To make it easier to recognize, you can rename the scrap. When you want to view your note, just double-click it and WordPad will open the Scrap.
You all know by now that I love saving time and keystrokes and this is a little beauty that you will love!
Follow the steps below to learn how to enter a series of dates in MS Excel in short order:
Sometimes you would just love to have a comment that would make things clearer for the person using the worksheet in MS Excel wouldn’t you?
Well you can use this handly little trick to add a comment to a formula in MS Excel:
You can view the comment in the formula bar whenever you select the cell.
If you are working on a document that lots and lots of heavy formatting, and you want to get rid of the formatting and start from scratch, there is an easy fix for you.
Follow the steps below to learn how:
The Notepad can only work with unformatted text and so all formatting for your text selection is removed. You can now copy your text back to the Clipboard and paste it back into an MS Word document.
There may be times when you would like to share most of a document, but not all of it.
There are myriad reasons why you might like to do this, such as hiding the technology jargon in a software rollout document being sent to customers. You might like to include the technology jargon in the document that is being sent to the customer’s IT department, but you do not want to overwhelm your customer with too much technical detail.
Fortunately, you can accomplish this task in MS Word rather easily. Follow the steps below to learn how:
Please note that even though the text is hidden, it is still there and easily found should you send your document to someone electronically.
A reader recently wrote with this inquiry:
"Please, tell me how to identify the style used in a document developed by someone else. They sent me the style *.dotx and I saved it in my MicroSoft QuickStyles Folder. However, I have several similarly named styles."
My Reply:
Display the Home Ribbon if it is not already visible.
Right-click on the tiny arrow at the lower right-hand end of the Style box (or use Alt+Ctrl+Shift+S), That will drop down the Style list and the style being used will be highlighted.
Another solution is to go into the Customize dialog, select Commands Not in the Ribbon, and then select the Style item. When you hover over it, it says Commands Not in the Ribbon | Style (StyleGalleryClassic).
Addi it to the Quick Access Toolbar (QAT) and it will always show the current style, the same as the one in the toolbar in Word 2003.
If you open the Style Dialog by clicking the little arrow in the right-hand corner of the Style Group on the Home Ribbon, you will see an icon for Manage Style which lets you restrict or recommend styles.
If you use the Option button, you can control which styles are displayed in the Style dialog. You can also assign which styles you want to display in the Home group Quick Style Gallery by right-clicking on any style in the Style dialog and choosing to add or remove it from the Quick Style Gallery.
A reader recently wrote to inquire:
“Does Word 2007 provide a destination barcode for printing envelopes? If not, is it available from elsewhere?
My Reply:
You cannot simply check the barcode box in the Envelope dialog any longer, but you can still manually insert the {BARCODE} field on your envelope.
Having said that, please know that the option has been removed from Word 2007 because the POSTNET codes produced by the BARCODE field were no longer compliant with USPS regulations.
See: http://support.microsoft.com/?kbid=897290.
There are other software add-ins out there, both free and paid versions that are compatible with MS Word 2007 that will do the trick for you. As an example, there is one available at Tec-It online.
A subscriber wrote to me last week asking why there isn’t an AutoComplete feature in MS Excel.
My reply:
Well it’s not exactly AutoComplete but it will do the trick for you. Follow the steps below to learn how:
Whenever you want to repeat data that already appears in a column, simply click:
Quick as a flash you have a list of all previous entries in that column!
Use the arrow keys to select an item and click on Enter.
Pretty cool huh?
