Posts Tagged ‘Ctrl’

« Older Entries
Newer Entries »

Replace Long Blocks of Text in MS Word Using Search & Replace

Wednesday, January 25th, 2012

MS Word has robut Search and Replace function and you should use it to its fullest capability. You all know I just LOVE to save time and keystrokes so why not put this function into use to do just that?

Sometimes you  need to replace a short block of text, with a longer, more detailed block of text throughout your document (i.e., a contract, Last Will & Testament, Thesis, Interrogatories, etc.)  Or there could be instances where you need to replace some text with a graphic (i.e., technical manual).

Follow the steps to learn how:

  1. Copy what you would like to use as a replacement to the Clipboard.
  2. Click Ctrl + H to display the Replace tab of the Find and Replace dialog box.
  3. In the Find What box, enter the text you want replaced.
  4. In the Replace With area, enter ^c, which will instruct Word to use the contents of the Clipboard as the replacement.
  5. Click on Find Next.
  6. Make replacements as you wish.

This comes in very handy if you have a particularly long replacement as the contents of the Replace With box is less than 255 characters.

 

Tags: , , , , , ,
Posted in Microsoft Office Publisher, Microsoft Office Word, Word 2010 | No Comments »

Printing Different Pages in MS Excel

Wednesday, February 9th, 2011

Have you ever wondered how to print specific pages of your worksheet like you can do in MS Word? Well if you have, read on.

If each of your worksheets fit on one page (single sheet) then the answer to your question is fairly simple.  All you really need to do is select the worksheets that you would like to print, using your CTRL key to select each worksheet tab. Then when you print, only those worksheets will be printed.

However, if you would like to print specific pages from a worksheet that normally flows to multiple pages, then the answer is a bit more vexing.

One method is to temporarily hide the unwanted portions of your worksheet and then print the unhidden area. There is, however,  a much simpler resolution.

Follow the steps below to learn how:

  1. Click on View | Page Break Preview.
  2. MS Excel will display your worksheet, showing the various page breaks. In version 2007, this view is available to you by displaying the View tab of your Ribbon and clicking the Page Break Preview tool in the Workbook Views group.
  3. Select all cells in the first page you want printed.
  4. Hold down your CTRL key and select all the cells in your second page you want printed.
  5. Repeat steps 3 and 4 above,  for each page you would like to print.
  6. Click on File | Print to display the Print dialog box.  In version 2007, click Office button | Print.
  7. In the Print What area, select Selection.
  8. Click OK.
  9. MS Excel will print the pages you previously selected.
  10. Close the Page Break Preview display.

Versions 97, 2000, 2002, 2003, 2007

Tags: , , , , , , , , ,
Posted in Excel 2003, Excel 2007, Microsoft Office | No Comments »

Shortcut for Accented Letters in MS Word

Wednesday, January 13th, 2010

Most folks do not use accented letters in their documents in MS Word documents on a daily basis. However, you find that you will have the need to use certain words that require an accented letter at some point, (i.e., café, résumé, fiancé).

I am sure that most of you are aware that you can insert an accented letter in your document the long way:

  1. In versions 2007 and 2010 Insert tab in versions 2007 or 2010 or the Insert menu in version 2003.
  2. Click on Symbol.
  3. Locate the needed accented letter.
  4. Click it.
  5. Click Insert.
  6. Close the Symbol dialog box.

There is another method you could employ, which is a keyboard shortcut for that symbol, which is easy enough to create —

  1. Navigate to the Symbol menu.
  2. Click on the symbol you need.
  3. Click Shortcut Key.
  4. Press the key combo you would like to use.
  5. Make sure your key combination is not currently assigned to another shortcut.
  6. Click Assign.

 — but not always easy to remember if you do not use it on a daily basis!

Either of the above methods would work just fine for you, but as you know, I am a huge proponent of less time and less keystrokes. There is another shortcut that will insert your accented letter for you much more quickly and easily:

Depress Ctrl + ` + the letter of your choosing. For instance, if you want to type the word fiancé, you simply press Ctrl+’, release those keys and type the letter e.

The other option is to depress simultaneously (Ctrl + ` + e). Both options will give you the same result.

If you need a letter with a tildè (~) above it, use Ctrl + Shift +`. Using the Shift key gives you the tildè. Release and click the letter of your choosing and a tilde will now appear above it.

Depressing all keys simultaneously will not give you the same result for the tildè; instead it will give you an upper case letter.

Tags: , , , , , , , , ,
Posted in Microsoft Office, Office Productivity, Word 2003, Word 2007, Word 2010 | No Comments »

« Older Entries
Newer Entries »