The extra “Design” (2) tab

In the third section, the “External table data” section, we have a number of options we can choose to share and analyze information with third parties.

The method you choose to share data depends on several factors.

If I ever write a course on “SharePoint”, I will consider explaining all the features but, it is outside the scope of this “Excel” course.

In the fourth section, the “Table Style Options” section, we find a number of options that are self explanatory. When you try them out, they will be clear.

The fifth section, “Table Styles” opens a window with a whole bunch of different formatting tables. Move the mouse pointer over the different formats and a live example is shown in the “Worksheet”.

Creating a custom table

To create a custom, formatted “Table”, click the “New Table Style” (2) link in the “Table Styles” tab.

This opens a dialog where for each table element can set a different layout. Select the table element and click “Format”. This will open a second dialog box where you can set the formatting for the text, border and padding. Click the OK button when you’re done and again click on the OK button in the first dialog.

Our custom “Table” layout is added to the list.

Delete a custom table

To delete a custom “Table” from the list, right-click the style in the list and choose “Delete”.

Change style of a custom table

To change the style of a custom “Table”, right-click on it and select “Modify”. This opens the dialog “Quick change style for table” where all our “Tables” can be modified or deleted.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats