Reveal formatting, Fast Formulas, Viewing Conversations
Reveal Formatting
Ever try to fix formatting that refuses to change? You can start with a clean slate by removing all formatting from the selection—select the block of text and press Ctrl-Shift-N.
Alternatively, you can use Word’s Reveal Formatting task pane to modify the formatting. In Word 2007, just hit Shift-F1.
When you click on an underlined link, an options dialog will display settings that you can modify. By checking the Distinguish style source option, you can view whether formatting was applied directly or via a style.
Fast Formulas
In Excel, sometimes you need to copy a formula or data to a series of non-sequential cells. You can do this quickly without having to paste it into each cell individually. First copy the data from the source cell. Then hold down the Ctrl key as you click on each destination cell. Once all the cells are highlighted, you can paste the data by pressing Ctrl-V.
Similarly, you can type data into a series of cells. Again, while holding down the Ctrl key, click on all the cells you want to enter the text into. Next, type the text you are entering and then press Ctrl-Enter to add the text to all the selected cells.
Viewing Conversations
Outlook lets you view messages by thread, which is a convenient way to scan your inbox much faster. Just choose View | Arrange By | Conversation to see your mail arranged this way. If you have the reading pane on the right, you can get to this setting faster by clicking on Arranged by at the top of the message list. You’ll find that if each message contains the earlier messages, you can read just the latest message in the thread instead of working through each one, so you can easily clean out your inbox by deleting earlier notes and keeping only the latest one.
That’s all for now! Until next week,
The elite Program
Follow
Comments are closed.