Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft.excel.training - pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.training - Pivot Tables

microsoft.excel.training - Pivot Tables

ResolvedVersion Standard

Barbra has attended:
Excel Advanced course

Pivot Tables

How do you publish a pivot table on the web?

RE: Pivot Tables

Dear Barbra

To publish a Pivot table on the web:

Select the Pivot table sheet

Open the File menu

Select Save as Web page

In the dialog box click Selection:Sheet

Click the Publish button

Follow the instructions where to save the spreadsheet

Regards

Carlos

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.