skip to Main Content

Word – Prevent a Table Row from Breaking (Word 2003, Word 2007 & Word 2010)

If you create and use tables in Microsoft Word, it can be frustrating when the bottom row contains too much data to fit on the same page.  This causes the table to ‘break’ and the data to flow onto the next row of the table on a new page.  By changing a setting in your table you can force the row to remain together on one page.
 

This post is only available to members.
Read More

Excel – How to Get Ampersand to Print in Headers/Footers (Excel 2010/2007/2003)

When printing out worksheets in Excel, many people add a header and footer to print on each page as a finishing touch.  Some characters will not print since Excel considers them a
command.  One example of this is the ampersand.  This will work the same in Excel 2003, Excel 2007 & Excel 2010
 

This post is only available to members.
Read More

Excel – Keyboard Shortcut to Display Formula in a Cell (Excel 2010/2007/2003)

You can change the settings in Excel to display the formula in a cell instead of the results.  This can be a time consuming process if you need to change the view several times while reviewing the worksheet.  There is a keyboard shortcut available that you can use to toggle from viewing the formula to viewing the results of the formula.  This will work in Excel 2003, Excel 2007, and Excel 2010.
 

This post is only available to members.
Read More
Back To Top