Carol's Corner Office

Tue
07
Feb
Dennis Faas's picture

Display a Photo in Hidden Comments: MS Excel

Have you ever had a list in Microsoft Excel -- (such as a "products list", for example) -- where you need to display a photo next to a record ... but the photo needed to be small enough to coincide with the list? In that case: consider using hidden ... comments to display your photos! Hidden comments work *great* for lists in Excel. Once the photo has been placed inside the hidden comment, simply move your cursor over the comment cell to see the picture! It's as easy as pie! Here is how to do it: Select a cell that contains a Comment, right-click, and from the shortcut menu, select Show Comment. ... (view more)

Sat
04
Feb
Dennis Faas's picture

Hanging Indent Shortcut: MS Word

A hanging indent is created when the first line of the paragraph starts at the start of the left margin, but the second and subsequent lines are indented. Hanging indents are a very common format used in many documents because it coordinates ... information. In MS Word, you can initiate a hanging indent by pressing CTRL+T on your keyboard. This "hangs" a paragraph to the next tab stop. If there are no previously defined tab stops in the paragraph, Word indents to the next default tab stop (typically in one-half inch intervals). Each press of the shortcut (CTRL+T) indents the paragraph one more ... (view more)

Fri
03
Feb
Dennis Faas's picture

Mixing Column and Paragraph Formats in MS Word

By default, Word's normal template is set to single-column format; thus, when you type a paragraph, you are typing in single-column format. You can mix column with paragraph formats in the same document by simply changing the column format. For ... example, you may want to have your document open with an introductory paragraph or two, while the rest of the text is formatted in three columns. To do this, follow these steps: Type the opening paragraphs. Put your cursor where you want to begin the multi-column text. Go to Format | Columns. Enter 3 for the Number Of Columns, and make any necessary ... (view more)

Thu
02
Feb
Dennis Faas's picture

Fix Stubborn Formatting in MS Word

Have you ever tried to modify a block of text in MS Word that refuses to comply to your editing? Here's a really useful tip: you can 'start with a clean slate' by removing *all* formatting from the paragraph selection; simply select the block of ... text and press Ctrl-Shift-N to start fresh. Alternatively, you can use Word's Reveal Formatting task pane to modify the formatting. In Word 2003, hit Shift-F1; in Word 2002, select Reveal Formatting from the Format menu. When you click on an underlined link, an options dialog will display settings that you can modify. By checking the Distinguish style ... (view more)

Thu
26
Jan
Dennis Faas's picture

Print Excel Key Assignments (Macros)

Infopackets Peter V. writes: " Thank you for your advice on Printing Keyboard Shortcuts in MS Word. Now I know which Macros I have assigned to which keys. This is a well-known tip, however, I am unable to find how to print my Keyboard Shortcuts ... using Microsoft Excel? Many thanks for your help in advance! " Carol's Response: Ivan F. Moala has created a free "add-in" that lists all user-defined key assignments in a worksheet. You can print this like any other worksheet: http://www.xcelfiles.com/GetShortCutKeys.html One other solution comes from Chip Pearson. He created an excel ... (view more)

Wed
25
Jan
Dennis Faas's picture

Insert a Non-breaking Space

When Microsoft Word calculates line width and wraps text to the next line, it tries to break the line at either a space or a hyphen. Sometimes, however, you may not want Word to break a line at a certain space. For instance, you may wish to make ... sure that two adjacent words appear on the same line. The answer is to use non-breaking spaces instead of regular ones. To do this, hold down the Ctrl and Shift keys as you press the Space Bar. Word then does not break the line at that point. Visit Carol's web site to learn more tips like this one! (view more)

Wed
25
Jan
Dennis Faas's picture

Picking up Where you Left Off: MS Word

If you open a document you were editing when you last used Word, you can use the Shift + F5 keyboard combination to quickly jump to where you were last working in the document. This is also a good way to get back to what you were editing after ... browsing through a document. You should remember an important caveat when trying to apply this tip: The Shift + F5 shortcut takes you back to where you made your last edit, not to where you last had the insertion point. For instance, if you are halfway through your document and you type a word or change a character that counts as an edit. Suppose that ... (view more)

Mon
23
Jan
Dennis Faas's picture

Using the Paste Special Command

When you copy text from the Web or another document into a Word file, Word will reproduce the typeface, color, and font size displayed in the original page. If you want the pasted text to match the formatting in the destination document, use Edit | ... Paste Special, and choose Unformatted Text. Visit Carol's web site to learn more tips like this one! (view more)

Sun
22
Jan
Dennis Faas's picture

Speed up typing with AutoText

Do you often find yourself typing the same phrase over and over again? For example, let's say you work for the Wonderful World of Word Workaholics in Wonkaville. Just entering that name can become quite time-consuming. But you don't have to manually ... type the entire name each time you use it in a document. Instead, you can add it to Word's list of AutoText entries, and you'll never have to type the entire name again. Follow these steps: 1. Type the name of your organization as you normally would. 2. Select the text, and press [Alt+F3]. 3. Click OK in the Create AutoText dialog box. The next ... (view more)

Sat
21
Jan
Dennis Faas's picture

Print Keyboard Shortcuts

Did you ever wish there was a "quick key," "hot key," or shortcut for an everyday function that you use in Word? Well there are and you can print them out for handy reference! 1. In Word, select Tools | Macro | Macros or press Alt + F8. 2. In the ... Macros dialog box, select Word Commands from the "Macros in" drop-down list. 3. Select ListCommands from the "Macro name" list box. 4. Click Run. 5. Select Current menu and keyboard settings in the List Commands dialog box, and click OK. Word will create a document containing a table of commands and their keyboard shortcuts. Print it for future ... (view more)

Pages

Subscribe to RSS - Carol's Corner Office