macroland Macroland

Macroland currently has 619 macros by 335 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 WidthsTable

by Randy not @ MS

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

Last Updated: June 19, 2016

Set Column Widths

Specify column width

Column Widths+Table

by wenmin92, Chris K.Y. FUNG

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

Last Updated: May 01, 2017

Column Widths+

Specify column width

Table to Text

Table

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

Columns Width of Selected TableTable

by DL-IND

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

Last Updated: June 19, 2016

Columns Width of Selected Table

For the selected table, the width of ALL columns will be:

Clear Cells

Table

Delete text from selected cells

Number CellsTable

by Qe7qBP5h

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

Last Updated: June 19, 2016

Number Cells

Please enter a starting number.
How much should it go up each time?

Set Table ColorsTable

by Garion

Set selected Table Color for Odd and Even Lines

Last Updated: January 10, 2019

Set Table Colors

Change Font Color or Shading Color?
Odd line color
Even line color

Shade Alternate Table RowsTable

by Omer Atay

Shades alternate rows of selected table to the selected accent color

Last Updated: April 19, 2019

Insert One Cell Table

Table

Insert a single celled table in an outline.

Number Selected Cells

Table

Set numbers from 1 to n to the sellected Cells

Number First CellsTable

by Omer Atay, Massimo

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

Last Updated: May 23, 2017

Number First Cells

Please enter a starting number.
How much should it go up each time?

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 ColumnTable

by khowes

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

Last Updated: June 20, 2016

Number Cells in a Specific Column

Please enter a starting number.
How much should it go up each time?
Which Column should the number go in

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.

Table Numbering with PrefixTable

by Eiv

Set a Prefix with numbers 1 to n on selected cells

Last Updated: June 20, 2016

Table Numbering with Prefix

Enter Variable Prefix (Optional)

TXT2TAB

Table

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

DivideTwoCellsTable

by Rajguru

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.

Last Updated: January 16, 2019

DivideTwoCells

Please select cell(s) from a single table

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)

MultiplyTwoCellsTable

by Omer Atay, Rajguru

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

Last Updated: June 14, 2018

MultiplyTwoCells

Please select cell(s) from a single table

Proportional FunctionTable

by Qe7qBP5h

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 valu...

Last Updated: June 19, 2016

Proportional Function

Set the number to divide.
Please set the number you want to divide by.

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

Exponentiate CellsTable

by Qe7qBP5h

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 Onetasti...

Last Updated: June 19, 2016

Exponentiate Cells

Set the number to exponentiate.

Count Selected RowsTable

by Unknown User

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

Last Updated: June 25, 2018

Count Selected Rows

~ value decided at runtime ~

Samy --> InsertRowTable

by samyang12

Sample macro showing how to rearrange rows in a table

Last Updated: March 07, 2018

Samy --> InsertRow

Please select a table for this macro

Table Numbering with Prefix, Starting Number and IncrementTable

by Quinn

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

Last Updated: October 23, 2019

Table Numbering with Prefix, Starting Number and Increment

Enter Variable Prefix (Optional)
Enter starting digit (defalut is 1)
Enter increment (defalut is 1)
See macros in other categories