macroland Macroland

Macroland currently has 596 macros by 317 authors
Sort By:

Category: Table

FunctionTable

by Omer Atay

Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions.

Last Updated: April 24, 2018

Function

Select the function to apply to the cells

Text to Table

Table

Converts selected text into table

Auto-fill

Table

Auto-fills selected table cells using data from the first few selected cells

Set Column Widths

Table

Sets the column width of the selected table on the current page to the specified value.

Column Widths+

Table

Sets the width of selected or all column(s) of the selected table on the current page to the specified value.

Columns Width of Selected Table

Table

Use this macro to set the same columns-width for the selected table/s. To make a single table selected, just click a cell of it

Clear Cells

Table

Delete text from selected cells

Table to Text

Table

Converts the selected table to text, columns separated by tabs. Preserves formatting but will remove any images

Number Cells

Table

Numbers all the cells in a table starting from a given value.

Number Selected Cells

Table

Set numbers from 1 to n to the sellected Cells

Number First Cells

Table

Numbers only the first column in a table starting from a given value.

Insert One Cell Table

Table

Insert a single celled table in an outline.

Transpose Table

Table

Transposes the selected table. It may leave empty cells if the table is not a square. It only works if the table has text. Non-text content will be lost.

Number Cells in a Specific Column

Table

Numbers the cells in a specific column in the Table. If there is data in this column it will be overwritten with the number

Shade Alternate Table Rows

Table

Shades alternate rows of selected table to the selected accent color

Set Table Colors

Table

Set selected Table Color for Odd and Even Lines

Table Numbering with Prefix

Table

Set a Prefix with numbers 1 to n on selected cells

TXT2TAB

Table

Converts selected text into table with 2 columns ： Odd-numbered paragraphs in the first column, even-numbered paragraphs in the second column

Distribute Columns

Table

Distribute the width of the selected columns equally between them. This macros is similar to the command of the same name in Microsoft Word.

Set All First Columns Width to 30 Value

Table

It will set first columns to 'locked' set it to width 30 (certain widths below a threshold don't have any effect)

Proportional Function

Table

Useful for math; for each table cell, it creates a grid of proportions for a specific number and division number of your choosing. WARNING: Create a new scrap page with a table for this to work! (Also, it can only go down/up to a certain integer value, Onetastic limitation.)

Exponentiate Cells

Table

Useful for math; for each table cell, it creates a grid of powers for a specific number of your choosing. WARNING: Create a new scrap page with a table for this to work! (Also, it can only go up/down to a certain integer value, limitation of Onetastic.)

MultiplyTwoCells

Table

Multiply two cells of a row or a column into a adjoining empty cell in a table

DivideTwoCells

Table

Divides Two Cells in a row or a column in a Table, Select 3 Cells, the Cell to be divided first then the Divisor and a Blank Cell for the Quotient and run the Macro.

Unlock Column Width

Table

Unlock the column width of the selected columns so that their width adjusts automatically based on content.

Insert One Cell Table Anywhere

Table

Insert a single celled table in an outline OR IN A TABLE

Samy --> InsertRow

Table

Sample macro showing how to rearrange rows in a table

Count Selected Rows

Table

Count the selected rows and shows the result in a message box.

Table Numbering with Prefix, Starting Number and Increment

Table

Set a prefix, starting number and increment for a selection of cells on the page.

See macros in other categories