On the "Summer Bookings" worksheet, remove the table functionality from the table. Retain the cell formatting and location of the data.

1. Select the Table Tools Design Ribbon on Table Tools. 2. In the Tools group, click on Convert to Range. OR 1. Right-click the table then click on Table then press Convert to Range.

Create tables

Question

On the "Summer Bookings" worksheet, remove the table functionality from the table. Retain the cell formatting and location of the data.

Explanation

Select the Table Tools Design Ribbon on Table Tools. 2. In the Tools group, click on Convert to Range. OR 1. Right-click the table then click on Table then press Convert to Range.

Topics

#convert to range#remove table#table functionality#retain formatting

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice