Question

what is the utility of a table in worksheet​

Answer 1

Spreadspeed offers spreadsheet utilities that operate on the workbook level, the worksheet level, and the range level. This page highlights the utilities that operate on the workbook level.

Create Table of Contents

The Table of Contents tool will insert a worksheet at the beginning of your workbook and list all the worksheets, full sheet charts, embedded charts, tables, and named ranges in the workbook. As the image below shows, you will be prompted with the Table of Contents listing and can opt to exclude any item from the output and choose the linking options.

Table of Contents Dialog

Table of Contents

Table of Contents Sample Output

The sample table of contents output below shows the links included to the side. Another thing to note is that worksheet-level named ranges are indented under ther parent sheet, whereas workbook-level named ranges are not, in order to highlight their scope.

Table of Contents Output

Sort Worksheet Tabs

If you have a small workbook, you can easily sort worksheet tabs by dragging and dropping them. but if the workbook is large with many sheets, the Sort Tabs tool is a fast way to rearrange them. The Sort Tabs dialog allows you to rearrange

the tab order by clicking the up/down buttons, dragging and dropping rows, or clicking the column headers to sort by name or tab color. You can also double-click the Sheet Name items to edit and rename the tabs, if desired.

Sort Worksheet Tabs Screenshot

Sort Worksheet Tabs

Follow me please and mark me brilliant pleaseeeeeee