6th Grade

​Defining a Range Name​
 

A range, is normally identified by the references for its first and last cells (for example, A1:A10 or B5:E20).  You can also assign a special name to any range (as well as to a single cell) and then use that name, in place of the cell references, to identify the range.

​

 

​

​

​

​

Named Range (B4:B8 = Week1)

The number of named ranges in a workbook is limited only by computer memory.  All names within a particular workbook, however, must be unique.
To define a range name:
• Select the cell(s) that is/are to be named.  (The selection can include contiguous, as well as non-contiguous, cells.)
• On the Formulas tab, in the Defined Names group, click on Define Name (or right-click on the selection and choose Name a Range).
• In the New Name dialog box, which is subsequently displayed, enter the name for the selection.
• Click on the OK button.
To define a range name (using the Name box):
• Select the cell(s) that is/are to be named.
• Click in the Name box.
• Type the name for the selection.
• Press [ENTER].

Notes:
1. A range name can include letters, numbers, periods and underscores.  (The first character must be a letter or an underscore.)  Spaces are not allowed.  The name, furthermore, cannot be the same as a cell reference.
2. The program does not distinguish between uppercase and lowercase characters in a range name.  For example, the names "WEEK1," "Week1" and "week1" are considered to be the same.

 

Reflection Activity:

• How many ranges can you have in a spreadsheet.
   

​Comments
You can add notes to individual cells by using comments to give the reader additional context for the data it contains. When a cell has a comment, a red indicator appears in the corner of the cell. When you rest the pointer on the cell, the comment appears.

​

​

​

​

​

​

 

1.1.1 How to add a comment
1. Select the cell that you want to add a comment to and do one of the following:
• On the Review tab, in the Comments group, click New Comment.
• Right-click the cell and then click Insert Comment.
 

TIP   You can also right-click the cell, and then click Insert Comment.
A new comment is created, and the pointer moves to the comment. An indicator appears in the corner of the cell.
By default, the new comment is labeled with a name. To use a different name, you can select the name in the comment, and then type a new name. Or, you can remove the name by selecting the name in the comment and pressing Delete.
 

NOTE   To change the default name that is used for comment labels, see the section Change the default name that is displayed in new comments, later in this article.
2. In the body of the comment, type the comment text.
3. Click outside the comment box.
The comment box disappears, but the comment indicator remains. To keep the comment visible, do the following:
• Select the cell.
• In the Comments group, on the Review tab, click Show/Hide Comment.

​ 

1.1.2 Edit a comment
1. Select the cell that contains the comment that you want to edit.
2. On the Review tab, in the Comments group, click Edit Comment.

​

​

​

​

​

Keyboard shortcut     You can also press Shift+F2.

NOTE   If the cell that you select does not have a comment, the Edit Comment command is not available in the Comments group. Instead, the New Comment command is available.
3. Double-click the text in the comment, and then in the comment text box, edit the comment text.

1.1.3 Delete a comment
• Click the cell that contains the comment that you want to delete and do one of the following:
• Right-click the cell and then click Delete Comment.
• On the Review tab, in the Comments group, click Delete.

​ 

​Headers and footers in a worksheet
You can add headers or footers at the top or bottom of a printed worksheet in Microsoft Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. You can create your own or use many built-in headers and footers.
Headers and footers are not displayed on the worksheet in Normal view — they are displayed only in Page Layout view and on the printed pages. For Excel worksheets, you can insert headers or footers in Page Layout view where you can see them. You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at the same time. For other sheet types, such as chart sheets, you can insert headers and footers only by using the Page Setup dialog box.
 

1.1.1 Add or change the header or footer text in Page Layout view
Click the worksheet that you want to add headers or footers, or that contains headers or footers that you want to change.
1. On the Insert tab, in the Text group, click Header & Footer.

​

​

​

​

NOTE    Excel displays the worksheet in Page Layout view. You can also click Page Layout View  on the status bar to display this view.
2. Do one of the following:
• To add a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header or above Footer).
• To change a header or footer, click the header or footer text box at the top or the bottom of the worksheet page, and then select the text that you want to change.
3. Type the new header or footer text.

NOTES
• To start a new line in a header or footer text box, press Enter.
• To delete a portion of a header or footer, select the portion that you want to delete in the header or footer text box, and then press Delete or Backspace. You can also click the text, and then press Backspace to delete the previous characters.
• To include a single ampersand (&) in the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services.
• To close the headers or footers, click anywhere in the worksheet. To close the headers or footers without keeping the changes that you made, press Esc.
1.1.2 Add or change the header or footer text in the Page Setup dialog box
1. Click the worksheet or worksheets, chart sheet, or embedded chart to which you want to add headers or footers, or that contains headers or footers that you want to change.
2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher.

​

​

​

​

​

Excel displays the Page Setup dialog box.

TIP   If you select a chart sheet or embedded chart, clicking Header & Footer in the Text group on the Insert tab also displays the Page Setup dialog box.
3. On the Header/Footer tab, click Custom Header or Custom Footer.
4. Click in the Left section, Center section, or Right section box, and then click the buttons to insert the header or footer information that you want in that section.
5. To add or change the header or footer text, type additional text or edit the existing text in the Left section, Center section, or Right section box.

NOTES
• To start a new line in a section box, press Enter.
• To delete a portion of a header or footer, select the portion that you want to delete in the section box and then press Delete or Backspace. You can also click the text, and then press Backspace to delete the previous characters.
• To include a single ampersand (&) in the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services.
• To base a custom header or footer on an existing header or footer, click the header or footer in the Header or Footer box.

​

Reflection Activity:

•  Write the shortcut to edit a comment.