Tag: David’s Favorite Tricks

Add amortization table to any Excel workbook-Right-click worksheet tab, choose Insert, double-click Loan Amortization on Spreadsheet Solutions tab

Filtering a list for blank rows in Excel 2010? Type a single parentheses “(” in the Search box instead of unclicking Select All and scrolling down.

Monitor your printout size from anywhere in Excel 2007/10: On Page Layout tab, right-click on Scale, then Add to Quick Access Toolbar.

Accidentally close a spreadsheet without saving? In Excel 2010 choose File, Info, Manage Versions, and then Recover Unsaved Workbooks.

Double-click Format Painter (paintbrush icon) to transfer cell formatting to multiple non-contiguous cells; press Escape when complete.

Does your Excel spreadsheet contain numbers stored as text? Select the numbers, choose Data, Text to Columns, and then click Finish.

To move selected columns, hold the Shift down while you move the edge of your selection with left mouse.

In Excel 2007, save a couple clicks when hiding rows or columns: choose Format, Row Height or Column Width, and enter 0.

Right-click on the navigation arrows in the lower left-hand corner of the screen to display a worksheet selection menu.

Press F2 in the formula bar to enable the arrow keys to move left and right in the formula bar without changing cell addresses.

Apply border line to the top of SUM cell rather than the bottom of the cell above–avoids erasing border when copying formulas.