Posts Tagged ‘rows’

Keep your Table on One Page in MS Word

Monday, January 30th, 2012

When you create large, complex documents (i.e., technical manuals, theses, etc.) you will find that you are adding tables to them. It has been my experience that most tables in these documents are not very long and can very easily fit onto one page. Having said that, it can be problematic when there is a page break smack dab in the middle of your table.

Follow the steps below to prevent such behavior:

  1. Select all rows in your table.
  2. Display the Paragraph dialog box by clicking on Format | Paragraph in version 2003 and in versions 2007-2010, click on the Home tab of your Ribbon and click the small icon at the bottom-right of the Paragraph group.
  3. Be certain the Line and Page Breaks tab is selected.
  4. Select the Keep Lines Together check box.
  5. Click on OK.

Having done that, you now need to repeat the steps, with two very minor changes.

  1. First, in step one, select all the rows in your table except the last one.
  2. In step four, make sure the Keep with Next check box is selected.

This will make sure that your table stays together as a unit rather than staying with teh paragraph that follows it.

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?