Posts Tagged ‘Alt’

Create A Page X of Y Quick Part in MS Word 2010

Thursday, May 19th, 2011

A reader wrote to me recently telling me he was having an issue for Page X of Y in MS Word 2010. He said the choice did not show up on his Ribbon in any of the Groups.

So I told him how to create a Quick Part that would resolve his issue.

Follow the steps below to learn how:

  1. Open a new blank document
  2. Key in the word Page and click your spacebar once.
  3. Click Alt + Shift + P, which will insert a page number code for the current page and click once on your spacebar.
  4. Key in the word of and click your spacebar once again.
  5. Click Alt + I + F.
  6. When the field dialog displays, click on N as many times as necessary to more your cursor to NumPages, which is the code for the total number of pages in your document.
  7. Click OK.
  8. You should see “Page X of Y” where X represents the page number of the current pages and Y represents the total number of pages in your document.
  9. Select the text and codes and click Alt + F3. If you care to do it the long way (which I would never advocate), you can click on the Insert tab | Quick Parts | Save Selection to Quick Part Gallery, but if you do that, this method will place your new Quick Part in the BuildingBlocks.dotx template and you will not be able to use AutoComplete to expand the entry.
  10. When the Create New Building Block appears, key in an abbreviation that is intuitive for you, such as pxoy.
  11. Click OK.

Now to insert the Page X of Y entry:

  • Place your cursor where you would like the text and codes to appear, such as the footer of your document.
  • Key in your abbreviation.
  • Click F3 or if the AutoComplete prompt appears, click your Enter key.

MS WORD STYLES IDENTIFICATION IN VERSION 2007

Wednesday, July 15th, 2009

I recently heard from a reader who wanted to know how he could tell which Style Set was in use in an MS Word 2007 Document.  It seems that someone e-mailed him a document and the style set, which he saved in his QuickStyles folder, but he has several similarly named styles and wants to know how he can easily see which style is in use in his document.

Below is how I advised him:

Display the Home Ribbon if it is not already visible.

Right-click the tiny arrow at the lower right-hand end of the Style box (or use the key combination ALT + CTRL + SHIFT + S.

That will drop down the Style list and the style being used will be highlighted.

Another solution is to to into the Customize dialog box and select Commands Not in the Ribbon and then select the Style item.

When you hover over it, it will say Commands Not in the Ribbon | Style (StyleGalleryClassic).

Add it to the Quick Access Toolbar (QAT) and it will always show the current style, the same as the one on the toolbar in MS Word 2003.

If you open the Style dialog box by clicking the little arrow in the right-hand corner of the Style Group on the Home Ribbon, you will see an icon for Manage Style which lets you restrict or recommended styles.

If you use the Option button, you can control which styles are displayed in the Style dialog box. You can also asisgn which styles you wish to display in the Home group Quick Style Gallery by right-clicking on any style in the Style dialog and choosing to add or remove it from the Quick Style Gallery.

You can learn about this and many other nuances of MS Word 2007, especially navigation tips in my book found here.

Put Checkmarks in your Cells in MS Excel

Tuesday, February 3rd, 2009

I receive lots of e-mail from subscribers asking me if they can put checkmarks into the cells in their MS Excel spreadsheets. The short answer is yes!

There are several ways to place checkmarks in the cells of your MS Excel spreadsheets. Follow the steps below to learn how:

Note – Depending upon your version of MS Excel and Windows, you may not have some of the fonts below.

  1. Type a lower case a and change the font to Marlette or Webdings.
  2. Type an upper case P and change the font to Wingdings2.
  3. Hold down the ALT key and type 251.
  4. Click on Insert | Insert Symbol and scroll down and click on the checkmark. Click on Insert | Close | Enter.
  5. Hold down the ALT key and type 0252 and change the font to Wingdings.

You may also insert a CheckBox in your worksheet by following these steps: 

  • Click on View | Toolbars | Forms.
  • Select the CheckBox icon and click where you would like to place the CheckBox in your spreadsheet.

You can also change or delete the CheckBox label or resize or move it.

To make a copy of the CheckBox, hold down your CTRL key while dragging the border of the CheckBox.

Now you have lots and lots of choices to place checkmarks into your spreadsheets!