Finding yourself … in MS Word
August 22, 2005
To return to the location of your last edit, press Shift + F5. Lost no longer!
Who hid my slides?
August 22, 2005
Have you ever finished creating a lengthy presentation, and then discovered that only certain slides need to be viewed for a shorter presentation? You have that gut feeling the entire presentation will be needed one day, so you don’t want to delete the unwanted slides. What can you do quickly and accurately? You can hide slides.
Open the presentation, switch to Slide Sorter View. Select the slides you want to hide. (Reminder: click once on one slide, hold down the Shift key and click on other slides you want to select.) Right-click on one of the selected slides, choose Hide Slide. If you’re a button-on-the-toolbar type, click the Hide Slide button; menu folks, choose Slide Show, Hide Slide. Do the reverse to unhide a slide!
If you do the above and hide slides, can you print the entire presentation without unhiding the slides? Yes, in the File, Print dialog box there is an option to Print Hidden Slides.
Alpha, numeric, my way, your way … Custom Lists in Excel
August 22, 2005
Custom lists can be created in Excel, to allow custom sorting.
For example, you want to sort in this order – Red, Green, Yellow, Blue. That’s not alphabetical, is it? Create a Custom List and have it your way.
To create the Custom List, go to Tools, Options, click the Custom Lists tab. Click in the List entries input field. Type the list as you want it to sort, pressing Enter after each entry. Click Add when done. The list is added to the Custom lists field. Click OK. Now when you use Data, Sort in a list, you can click the Options button and choose your custom list for sorting.
Whither goest Excel’s Enter?
August 22, 2005
Excel users can control where cell selection goes after you press the Enter key. Some of us prefer the selection to move down, others want it to move to the left, right, or up. From the menu, choose Tools, Options, click the Edit tab. In the section named Move selection after Enter, choose the desired direction from the Direction drop-down list. Click OK. Happy now?
Sharing and Google
August 22, 2005
Be picky – select what YOU want – MS Word
August 22, 2005
Selecting large chunks of a Word document is easier when you use keyboard shortcuts instead of scrolling (ever get seasick trying to scroll down … too much, too fast … scroll up … woops!).
- Use the F8 “Extend” key. Click where you want the selection to start. Press F8 key on your keyboard. Notice EXT appears in the Word status bar (bottom center of Word window). Use keyboard to extend the selection – you can use the Page Up or Page Down key, or arrow keys, to make a selection. To turn Extend off, pres the Esc key (Escape) on your keyboard.
- Use Shift in combination with the desired navigation keys. For example, Shift + PgDn selects from the insertion point to the bottom of the page. Another example – Shift + Ctrl + End selects from the insertion point to the end of the document.