CornDog Computers

Tag: Excel 2007

Print an Entire Worksheet Even If You Defined a Print Area

posted by Rob Johnson on Jul.02, 2009, under Tips

1. Click the Office button.

2. Click Print.

3. In the Print what section, select the Ignore print areas check box.

View Comments :, more...

Prioritize with Note Tags

posted by Rob Johnson on Jun.26, 2009, under Tips

MS_excel_2007

Note tags help you to know and find what’s important in your notes (such as ideas or actions), to indicate what level priority or type each item is, and to recall these items easily. Names and icons associated with note tags can be customized to meet your needs.

To add a note tag:
1. Click the content that you want to tag.
2. On the Insert menu, click Note Tags.
3. Choose from the list of note tags.

View Comments : more...

To Change the Color of a Sheet Tab

posted by Rob Johnson on Jun.25, 2009, under Tips

MS_excel_2007


1. Right-click the sheet tab.
2. Click Tab Color.
3. Click the color from the palette that appears.

View Comments : more...

Identify Duplicate Values in an Excel Table

posted by Rob Johnson on Jun.24, 2009, under Tips

MS_excel_2007

In Microsoft Office Excel 2007, you can easily highlight duplicate values with conditional formatting.

1. Select the list in which you want to identify duplicates.
2. Click the Home tab on the Ribbon.
3. In the Styles section, click Conditional Formatting, point to Highlight Cells Rules, and then click Duplicate Values. Pairs of duplicates will then be highlighted, and you can choose which of each pair to delete.

View Comments : more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!