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
We are a small company dealing not only with the sophisticated ordering systems of our nations biggest retailers, but also a myriad of independent fabric stores across the country. Having both hardware & software support from a solid provider like CES, has allowed us to grow & succeed in a competitive market, without our own IT department. That’s huge to me!
Jack Vanderbeck
General Fabrics