Macroland
Category: Table
FunctionTable
by Onetastic
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
Text to Table
TableConverts selected text into table
Auto-fill
TableAuto-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
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
TableConverts 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
Clear Cells
TableDelete 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 Onetastic
Shades alternate rows of selected table to the selected accent color
Last Updated: April 19, 2019


Insert One Cell Table
TableInsert a single celled table in an outline.
Number Selected Cells
TableSet numbers from 1 to n to the sellected Cells
Number First CellsTable
by Onetastic, 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
TableTransposes 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.
Distribute Columns
TableDistribute the width of the selected columns equally between them. This macros is similar to the command of the same name in Microsoft Word.
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 | |
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
TXT2TAB
TableConverts 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
MultiplyTwoCellsTable
by Onetastic, Rajguru
Multiply two cells of a row or a column into a adjoining empty cell in a table
Last Updated: June 14, 2018

MultiplyTwoCells
Unlock Column Width
TableUnlock the column width of the selected columns so that their width adjusts automatically based on content.
Set All First Columns Width to 30 Value
TableIt will set first columns to 'locked' set it to width 30 (certain widths below a threshold don't have any effect)
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. | |
Insert One Cell Table Anywhere
TableInsert 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
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
Samy --> InsertRowTable
by samyang12
Sample macro showing how to rearrange rows in a table
Last Updated: March 07, 2018

Samy --> InsertRow
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) | |
Advanced Table Numbering with PrefixTable
by Handy
Set a Prefix with numbers. Variable start number and increment.
Last Updated: April 24, 2021

Advanced Table Numbering with Prefix
Enter Variable Prefix (Optional) | |
Enter start number (Default = 1) | |
Enter increment (Default = 1) | |