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
Converts selected text into table
Auto-fills selected table cells using data from the first few selected cells
Sets the column width of the selected table on the current page to the specified value.
Sets the width of selected or all column(s) of the selected table on the current page to the specified value.
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
Converts the selected table to text, columns separated by tabs. Preserves formatting but will remove any images
Delete text from selected cells
Numbers all the cells in a table starting from a given value.
Set selected Table Color for Odd and Even Lines
Shades alternate rows of selected table to the selected accent color
Insert a single celled table in an outline.
Set numbers from 1 to n to the sellected Cells
Numbers only the first column in a table starting from a given value.
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.
Numbers the cells in a specific column in the Table. If there is data in this column it will be overwritten with the number
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 a Prefix with numbers 1 to n on selected cells
Converts selected text into table with 2 columns : Odd-numbered paragraphs in the first column, even-numbered paragraphs in the second column
It will set first columns to 'locked' set it to width 30 (certain widths below a threshold don't have any effect)
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.)
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.
Multiply two cells of a row or a column into a adjoining empty cell in a table
Unlock the column width of the selected columns so that their width adjusts automatically based on content.
Insert a single celled table in an outline OR IN A 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.)
Count the selected rows and shows the result in a message box.
Sample macro showing how to rearrange rows in a table
Set a prefix, starting number and increment for a selection of cells on the page.