Where
is it in
Excel 2007?
|
|
Back
to Main Index |
|
Protect workbook elements
Add or
change the header or footer text
Options
PivotTable
|
Protect workbook elements
- On the Review tab,
in the Changes group, click Protect
Workbook.
- Under Protect workbook
for, do any of the following:
To protect the structure of a
workbook, select the Structure check box.
To keep workbook windows in the same
size and position each time the workbook is opened, select the
Windows check box.
|
Workbook elements |
|
Select this check box |
To prevent users from |
|
Structure |
- Viewing worksheets that you
have hidden.
- Moving, deleting, hiding, or
changing the names of worksheets.
- Inserting new worksheets or
chart sheets.
Note Users will be able to insert an
embedded chartin an existing worksheet.
- Moving or copying worksheets
to another workbook.
- In PivotTable reports,
displaying the source data for a cell in the data area, or
displaying page field pages on separate worksheets.
- For scenarios, creating a
scenario summary report.
- In the Analysis ToolPak,
using the analysis tools that place results on a new
worksheet.
- Recording new macros.
Note If you run a macro that includes an operation that
can't be performed in a protected workbook, a message appears
and the macro stops running.
|
|
Windows |
|
- To prevent other users from removing
workbook protection, in the Password (optional) box,
type a password, click OK, and then retype the
password to confirm it.
|
Note
|
The password is optional. If you don't
supply a password, then any user can unprotect the workbook and
change the protected elements. Make sure that you choose a password
that you can remember, because if you lose the password, you cannot
gain access to the protected elements in the workbook. |
|
Add or
change the header or footer text
For worksheets, you can work with headers
and footers in Page Layout view. For other sheet types, such as chart
sheets or
for embedded charts, you can work with headers and footers in the
Page Setup dialog box.
Page Layout View
- Click the worksheet to which you want
to add headers or footers, or that contains headers or footers that you
want to change.
- 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. |
- 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 at the
bottom of the worksheet page.
- To change a header or footer, click
the header or footer text box at the top or at the bottom of the
worksheet page that contains header or footer text, and then select
the text that you want to change.
- Type the text that you want.
|
Tip |
To return to Normal view, on the
View tab, in
the Workbook Views group, click Normal.
You can also click Normal
 on the status bar. |
|
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
in the text and then press BACKSPACE to delete the preceding characters.
- To include a single ampersand (&)
within 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, or press ESC.
|
|
|
PivotTable To create a
PivotTable or PivotChart report, you need to connect to a data source and
enter the report's location.
- Select a cell in a range of cells, or
put the insertion point inside of a Microsoft Office Excel table.
Make sure that the range of cells has column headings.
- Click on the Insert tab and
click on Pivot Table.
- Select a data source.
- Enter a location.
- Click OK.
An empty PivotTable report is added to
the location that you entered with the PivotTable Field List displayed
so that you can start adding fields, creating a layout, and customizing
the PivotTable report.
|
|
Options Click the
Microsoft Office Button
 , and then click Excel
Options.
|
|
Back to Top
Back to Main
Index |