tables
RH

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tables

Tables

resolvedResolved · Medium Priority · Version 2013

Carmen has attended:
Excel Intermediate course

Tables

Once you have selected tables how do you return it to the original format?

RE: Tables

Hi Carmen

Do you want to return the table to a data format or just remove the fill colour from the cells?

To "reset" the formatting of the table, you could select the Table Tools tab and remove the ticks next to banded rows / columns. Then select a plain design from the style options on the right of the tab.

If you wish to return the table to a standard data format, you can select "Convert to Range" on the left side of the Table Tools tab. This will keep any table formatting you may have applied, so if you don't want any formatting, you may have to do the step above before converting the table.

Kind regards

Wendy

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 30 Oct 2017: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips


Server loaded in 0.05 secs.