Posts

Showing posts from June 20, 2010

Excel TipsTricks Conditional Formatting

Conditional Formatting In Excel 2000, 2002, 2003 the contents of the cell or b) a formula (which can simply refer to another cell) Format based on the cell’s contents 1. Select the cells you want to format (remember you can hold Ctrl to select contiguous ranges). 2. Choose Format Conditional Formatting. 3. Choose Cell Value Is from the drop-down list. 4. Use the text boxes and drop down lists to create your condition. 5. Click the format button and set the format to apply when the condition is true. 6. Close the Format dialog box. Click Add if you want to apply more than one condition to this range of cells. If not, click OK. Format based on a formula 1. Select the cells you want to format (remember you can hold Ctrl to select contiguous ranges). 2. Choose Format Conditional Formatting. 3. Choose Formula Is from the drop-down list. 4. Enter an = symbol. 5. Create a formula that evaluates to either True or False. When creating the formula, create it for the first row and column in th

MS Excel Worksheets Tips Tricks

Worksheets Renaming sheets Double-click the sheet tab and type a name of up to 32 characters. Spaces, hyphens, and underscores are allowed in worksheet names. Press Enter when finished. Coloring sheet tabs Excel 2002/2003 Only Right-click the sheet tab and choose Tab Color from the shortcut menu. Select a color. Moving worksheets in a workbook Drag the sheet tab to a new location. Copying a worksheet in a workbook Hold Ctrl and drag the sheet tab to a new location. Moving and copying between workbooks Right-click the sheet tab and choose Move or Copy to open the dialog box. Navigating between sheets Right-click the navigation buttons and select the sheet you want to move to OR Press Ctrl+PgDn to move to the next sheet; Ctrl+PgUp to move to the previous sheet; Ctrl+Tab to move to the next open workbook.