October 27, 2009
Applying Formatting Only to Cells Containing Text
To apply formatting only to cells containing text, use the Conditional Formatting technique:
1. Select a range of cells containing text.
2. From the Format menu, select Conditional Formatting.
3. In Condition 1, select “Formula Is” from the dropdown list.
4. In the Formula Box, enter the formula: =ISTEXT(A1)
5. Click Format.
6. Select the desired format from the Format Cells dialog box, and then click OK.
7. Click OK to close the Conditional Formatting dialog box.
October 15, 2009
Alt + Arrow Down: Open the lookup menu on a cell with a drop-down menu
Alt + M: Launch the MS Dynamics NAV menu
Alt + R: Launch the Reports menu
Alt + Tab: Switch between open items
Ctrl + +: Insert new line in a grid
Ctrl + E: Export to Excel
Ctrl + L: Show Links
Ctrl + N: Create New/Insert
Ctrl + O: Open company
Ctrl + W: Export to Word
With the Dynamics NAV software we have gained efficiency and flexibility in all areas of financial management including accounts payable check processing, cash receipts application, and particularly general ledger applications as it applies to adding programs and companies; financial statement reporting; exporting information into excel for analysis; and importing general ledger entries. The implementation team from CES was very knowledgeable and thorough so that the transition was very smooth!
Mike Matthews
Seven Hills Foundation
Worcester, Massachusetts