Find cells that meet specific criteria in Excel 2007

To find cells that meet a specific criteria, for example cells with conditional formatting or cells which have data validation, proceed as follows:

  1. In the Home tab Editing group click Find and Select.
  2. xl7find

  3. Click on:
    1. Formulas : to find cells that contain formulas.
    2. Comments : to find cells that contain comments.
    3. Conditional Formatting : to find cells that have Conditional Formatting.
    4. Constants : to find cells that contain constants.
    5. Data Validation : to find cells that have data validation.
  4. More options are available if you click Go To Special. Then you will get the Go To Special dialogue where you can specify specific criteria for the cells to be found and selected.

Note:

You can search the entire sheet for the specified criteria or you can limit your search by selecting a range of cells.

How to handle comments in Excel 2007

All commands (icons) that deal with comments are found in the Review tab, Comments group.

xl7comments1

To insert a new comment:

1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show on the top right corner of the cell.

xl7comments2

To show a comment:

1. Select the cell where you have the comment.
2. Click Show / Hide Comment.
3. If you have multiple comments then you can click Show All Comments to show all.

Note:

If the comment is already shown and you click Show / Hide Comment, then the comment will be hidden.

To edit a comment:

1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown. Click on it then edit the text.

To format a comment:

1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown.
4. Select the text that you want to format then right-click.

xl7comments3

5. Form the context menu select Format Comment.
6. in the Format Comment dialog box, select the formatting options that you want.

To move or resize a comment:

1. Select the cell where you have the comment then show the comment as explained previously.
2. Click the border of the comment box to show the sizing handles.
3. To move the comment, drag the border of the comment box, or press one of the arrow keys depending on which direction you want to move.

xl7comments4

4. To resize the comment, drag the handles on the sides and corners of the comment box.
xl7comments5

To copy a comment to another cell:

1. Select the cell where you have the comment.
2. In the Home tab, Clipboard group, click Copy (or just right click on the cell and select copy).
3. In the Home tab, Clipboard group, click the arrow below Paste, then select Paste Special (or just right click on the cell and select Paste Special).
4. In the Paste Special dialog box , under Paste, select Comments then click OK.

To delete a comment:

1. Select the cell where you have the comment.
2. Click Delete Comment.
3. The comment box and the comment indicator will both disappear.

To print a comment:

To print a comment check this post.

How to print comments in Excel 2007

To print comments in Excel 2007:

1. Show all comments or just the comments you want to print. How?

2. In the Page Layout tab, Page Setup group, click the dialog box launcher (see the mouse pointer in the image below).

xl7commentsp2

3. The Page Setup window will open.

4. Click on the Sheet tab.

xl7commentsp1

5. In the Comments box, select As displayed on sheet or At end of sheet depending on how you want to print the comments.

6. Click Print.

Notes:

1. If you select As displayed on sheet, then only the comments that are shown will be printed. So make sure that your comments are shown on the worksheet first. How?

2. To see how comments are printed, you can click Print Preview before you click Print.

How to freeze the top row in Excel 2007

If you have a worksheet with a heading row at the top, then you may want to freeze the heading row while scrolling throw the data rows below it. To achieve that follow these simple steps.

1. In the View tab, Window group click Freeze Panes.

xl7panes1

2. From the drop down list select Freeze Top Row.

xl7panes2

3. A dark line will show below the header row indicating where the freeze is established. The row above the line is frozen, and the rows below the line are scrollable.

xl7panes3

How to freeze panes in Excel 2007

If you have a large worksheet, then you may want to freeze the worksheet at one point while scrolling throw the rest of the rows below it. To achieve that follow these steps.

1. Select the top row of the area which you want to be scrollable (or just a cell in that row). I.e. all rows including and below the selected row will be scrollable, all rows above the selected row will be frozen.

2. In the View tab, Window group click Freeze Panes.

xl7panes1

3. From the drop down list select Freeze panes.

xl7panes4

4. A dark line will show above the selected row indicating where the freeze is established. The rows above the line are frozen, and the rows below the line are scrollable.

xl7panes5

Save Excel 2007 workbook as PDF file

You can now convert Excel 2007 files directly to PDF format without the need for a third party software. However to be able to do that you need to download and install Microsoft Office “Save as PDF” Add-in (SaveAsPDF.exe) from Microsoft web site.

Check SaveAsPDF.EXE download page Here.

After the add-in is installed:

1. Click the Office button in Excel 2007.
2. Point to Save As then click PDF or XPS.

SavePDF

3. The window Publish as PDF or XPS will open.
4. In the Save as type drop down select PDF.
5. Click the Publish button.

Excel 2007 User interface – View Tab

View Tab

viewtab

The view tab in Excel 2007 ribbon consists of 5 groups:

Workbook Views

viewworkbook

Switch between Normal, printer page layout or page break views. You can also create and show your custom views or switch to full screen view.

Show/Hide

viewshow

You can show or hide gridlines, formula bar or columns and row headings.

Zoom

viewzoom

Zoom in or out with different options.

Window

viewwindow

Create new windows, arrange windows and switch between them, freeze panes or save a workspace.

Macros
viewmacros

This group handles VBA macros. You can record, edit or run macros.

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Applies to : Excel 2007

Excel 2007 User interface – Review Tab

Review Tab

reviewtab

The review tab in Excel 2007 ribbon consists of 3 groups:

Proofing

reviewproofing

The proofing group gives you options to check spelling, translate or check synonyms in the thesaurus.

Comments

reviewcomments

Handles comments: add, edit, delete, show or hide.

Changes

reviewchanges

For workbook and worksheet protection, workbook sharing or tracking of changes.

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Applies to : Excel 2007

Excel 2007 User interface – DataTab

Data Tab

datatab

The Data tab in Excel 2007 ribbon consists of 6 groups:

Get External Data

dataexternal

Here you can import data into Excel from various external sources like Microsoft Access, Microsoft SQL Server, text files or the web.

Connections

dataconnect

Create and edit connections to external data sources that are stored in a workbook or in a connection file.

Sort and filter

datasort

Sort or filter data based on a specified criteria.

Data Tools

datatools

Here you have various data tools like removing duplicates, validation or data analysis.

Outline

dataoutline

Here you can group data based on a selection or you can create a subtotal in a given column based on values (keys) of another column.

Analysis

dataanalysis

Provides various data analysis tools like random number generation, histogram or moving average.

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Applies to : Excel 2007

Excel 2007 User interface – Formulas Tab

Formulas Tab

formulastab

The formulas tab in Excel 2007 ribbon consists of 5 groups that deal with formulas and functions:

Function Library

formulafunction

Chose from a set of Excel 2007 built-in functions. Functions are divided into groups for easy access.

Defined Names

formulanames

Manage names of ranges. Create, edit, delete or use in formulas.

Formula Auditing

formulaauditing

Show or hide formulas, trace dependents, check errors … etc.

Calculation

formulacalc

Specify calculations options for formulas : manual, automatic … etc.

Solutions

formulasolutions

From here you can use the conditional sum wizard and lookup wizard to help you in creating new formulas.

Posts on Excel 2007 user interface:

  1. Introduction
  2. The Home tab
  3. The Insert tab
  4. The Page Layout tab
  5. The Formulas tab
  6. The Data Tab
  7. The Review Tab
  8. The View Tab
  9. The Developer Tab

Applies to : Excel 2007