Clickety-Quick’s Top 5 Helpful Hints
In most of the classes we offer, it seems there are a few questions that present themselves over and over again. Today, we’d like to share our Top 5 Questions and Answers.
- What is – or how do I make – a “soft return”?
A soft return, Shift+Enter, is used when you want to force a line break without creating a whole new paragraph. They are used for text wrapping when don't want the first word of the next line to be capitalized; or, if you need the text on the following line to be aligned in the same manner as the existing paragraph.
- What is a simple way to select a large volume of text?
To select text that spans more than one page, I suggest using Click, then Shift+Click. If you've tried to select text using the traditional "hold down your mouse button and drag" method, you’ll have noticed that the pages slip by so quickly it's near impossible to control. However, you can avoid these runaway pages if you Click one end (doesn't matter which end), scroll up/down using the scroll bar, then Shift+Click at the other end. Voila! The text is selected.
- Can I format more than one sheet at a time in Excel?
Absolutely. When you want the layout of multiple sheets to be exactly the same; use Control+Click for non-adjacent sheets, or Click/Shift+Click to select adjacent sheets (using the sheet tabs) in your Excel workbook. Once you've selected the sheets, enter your labels, formulas and add formatting to the active sheet and you'll discover that each of the selected sheets are exact duplicates. To deselect, simply Click any sheet tab.
- Is there a simple way to copy/insert text or item I use over and over again?
Do you always use the same header and footer; add the filename, author or page numbering style? Then try using “Quick Parts” to make your life easier (Microsoft Office 2007/2010 only). Open an existing document, select the item that you like to use repeatedly, choose “Quick Parts” from the Insert ribbon and "Save Selection to Quick Part Gallery..." You can even choose a category such as Headers, Footers, Table of Contents, Tables, etc.
- How can I show someone else what my display looks like?
This is where “screenshots” come in handy. When you're faced with a challenge and need some help, it's really helpful to provide a screenshot of the error message or the state of the system at that point in time – though this isn't always possible if your system hangs! To take a screenshot, simply press the button on your keyboard that says Print Screen or PrtScn (or some variation on the words “print” and “screen”), then paste (Ctrl+V) to an email or a document. If you're only interested in an image of a specific window, make sure it's the active window and use Alt+PrintScreen, then paste.