Posts Tagged ‘shift’

Insert Rows and Columns Quickly in MS Excel

Monday, December 14th, 2009

Inserting rows and columns into your MS Excel worksheet is a fairly easy task.

  1. Select a row or column.
  2. Click on Insert | Row or Column, respectively.

MS Excel will insert a new row above the selected row and a new column to the left of the selected column.

As you all know, I like to take the quicker route with less keystrokes and save some time!

Alternative to the steps above, you can also achieve the same results using your keyboard:

  • Select a row or column and click Ctrl + Shift + =.
  • You can delete a row or column just as speedily by clicking Ctrl + Shift + -.
  • Should you change your mind, and decide you do not want that new row or column immediately after you added it/them, simply click Ctrl + Z.

Who doesn’t love to save time?

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.

Inserting a Non-Breaking Hyphen in MS Word

Tuesday, September 16th, 2008

Many times you wish to have a non-breaking hyphen in your document.  For example, when you type a phone number, you do not want to have three numbers at the end of one line and a hyphen at the beginning of the next line.  It’s just poor form.  This is just one example but there are many other reasons why you would want to use a non-breaking hyphen in your documents.

Follow the steps below to learn how to insert a non-breaking hyphen:

  1. Click on Insert | Symbol.
  2. Click on the Special Characters tab.
  3. Highlight the Non-breaking hyphen character.
  4. Click on Insert.
  5. Click on Cancel to close the dialog box.

You can also use the shortcut that I use which is CTRL + Shift + _