WORD: Repeating Table Headings on Every Page

Leave a comment

In Word, when you are creating a table, most likely it will continue to go onto the following page. And if the table is lengthy, Word doesn’t display the table’s headings at the top of each page. This can make multi-page tables hard to read. Word allows you to repeat a table’s heading row wherever the table breaks across pages regardless if the page was created by a hard page break or a manual page break.

In order for the first row of the table to repeat on every page just place the insertion point anywhere within the table’s first row. If you want to use more than the first row (maybe the headings are placed in two rows, just select the two rows)

In 2007/2010, click on Layout Tab under the Table Tool menu and click the Repeat Header Rows icon. Word automatically repeats the selected row contents wherever the table breaks across pages. Also, Word automatically adjusts the placement of repeated heading rows so that when any row(s) are added or removed from the body of the table, the repeated heading rows always appear at the top of the page.


EXCEL: Moving Rows and Columns the Alternative Way

Leave a comment

In Excel, you may want to move an entire column or row to another location. Rather than inserting a new column or row and using the copy/cut and paste method; use the following quick alternative.

  • Select the row or column by clicking on its header, hold down the Shift key, and then hover your cursor over the row or column border until it becomes a fourheaded arrow. Click and drag up or down to move the row or column and drop. You’ll see a placeholder to help guide your movements. This method will not replace a column or row with information. 
  • If you are moving a column or row to another location and there are empty columns and rows, simply hover your cursor over the row or column border until it becomes a fourheaded arrow and drag and drop.

WORD: Deactivate Hyperlinks and Field Codes

Leave a comment

To deactivate hyperlinks or convert field codes (automated dates) to normal text, Word offers a shortcut key that can be used to accomplish this task.

  1. Place the insertion point anywhere within the hyperlinked text or field you want to deactivate. (If you’re deactivating a hyperlink, be careful not to launch it.)


  2. Select the entire document by pressing Ctrl+A.

Next, press Ctrl+6. Word removes any selected hyperlinks and fields—without disturbing their original display text.