macroland Macroland

Macroland currently has 428 macros by 226 authors

Most Popular

Insert Monthly Calendar

by that0n3guy, Omer Atay 51347 Downloads

Inserts a calendar of the selected month and year

Last Updated: July 25, 2017

Sort Pages

46503

Sort each page in current section by name, sub pages stay under their parent pages and sorted among themselves

TOC in Current Notebook

40266

Creates a new page with table of contents of the current notebook

Insert Horizontal Line

27903

Inserts a horizontal line

TOC in Current Section

27738

Creates a new page with table of contents of the current section

TOC in Current Page

24552

Creates a table of contents from heading in the current page and inserts at the top of the page. Optionally it adds "Back to Top" links to the headings.

Search & Replace

22882

Search and replace text in the current page, section or notebook

Less Popular

Sort Sections

by Omer Atay 21493 Downloads

Sort each section in current section group by name

Last Updated: August 24, 2017

Sort Sections

Sort direction
Scope

Sort Pages By Date

18219

Sorts pages in current section or notebook by created or last modified date

Resize Images

16827

Resizes each image and printout in the current page by given percentage. This extension allows to choose either all images or the selected image only on the current page to be resized.

Sort Notebooks

14149

Sort notebooks by name

Blackboard page

12726

Make the background color of the page black.

Weekly Planner

12324

Inserts page with a section for each day in the current week

List Notebooks

11359

Creates a page with a list of all open notebooks and links to them

Sort Pages By Date +

11140

Sorts pages in current section by created or last modified date. The page-subpage hierarchy won't be lost because subpages will move along with their higher level pages.

Insert Double Horizontal Line

11096

Inserts a double horizontal line

Where am I

10787

Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections

Sort Table

9621

Sorts selected table by selected column

Text to Table

9430

Converts selected text into table

Word Count

9099

Displays the number of words and characters on the page

Function

8905

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

Recent Edits

8781

Displays a summary page of recent edits in current section/section group/notebook or all notebooks

UPPER CASE

8294

Convert selected text to upper case

Search & Highlight

8246

Search and replace text in the current page, section or notebook

Tag Summary for Specific Tag

8240

Creates a tag summary page for a specific tag. Up to three tags can be specified to find paragraphs that contain all those tags together

Attachment List

7419

Creates a list of attachment filenames in current section, section group or notebook. Provides page names and links back to the page and the embedded files.

Background Color List

7336

This macro gives you several options for setting the current page background color. Choose from a drop down list of colors that's loosely based on standard HTML color names, or you can set the page to any custom background color by entering its hex triplet value.

Capitalize Each Word

7248

Capitalize each word in the selected text

Insert Date Created or Completed

6398

Insert "Created:" or "Completed:" and today's date at the cursor position. Does not work if cursor is next to or in a hyperlink.

Number of Pages

6245

Displays number of pages in current Section/Section Group/Notebook/All Notebooks

lower case

6244

Convert selected text to lower case

Sort Selected Paragraphs

6170

Sorts selected paragraphs or list items

Set Section Color

5965

Sets Section Color to selected color

Increase Font Size

5798

Increases font size of all text on the page by 1

Perfect Printouts

5534

Puts printouts on the left, butted vertically, inserts slide number to the right of the upper right corner in the current font and sets the images as background.

Auto-fill

5436

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

Where am I +

5206

Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections / Parent Pages. Automatic remove the old breadcrumb.

Sublime Theme

5206

Makes the background color of the page dark gray and converts existing text to white. Based on the Sublime text editor. Note: Does not force the Automatic Font to White. Pending fix.

Select Images

5130

Selects all images on the page

Set All Pictures as Background

5114

This macro sets all images on the page to a background image, usefull for large printouts

Sort Selected Todos

5083

Sort Todo boxes by checked/unchecked. Select the paragraphs that have todo checkboxes and run this macro.

No Spell Check

5032

Removes spell check (red squiggles) from selected text

Decrease Font Size

5017

Decreases font size of all text on the page by 1

Search Multi-Keywords

4982

Search the paragraphs containing all the multiple keywords within a scope, and create a new page reporting the search results in the current section. Use semicolons (;) to separate the keywords, e.g. keyword1;keyword2;keyword3. There is (theoretically) no limit to the maximum number of keywords. But the speed is optimized for searching three keywords, and it slows down when more than three keywords are used. There are five opinions of scopes available, namely, “Current Page”, “Selection”, “Current Selection”, “Current Notebook”, and “All Notebooks”. It can take a long time, if search in notebook(s). Skip function is available, that is mainly for excluding pages that contain the previous search reports, to avoid duplicating the search results. Skip can take place in all scopes except the “Current Page” opinion. Change the texts as if you desired. It will skip the pages if their names contain the defined string. The report page lists the matched paragraphs and where they are found in.

Word Count - Selected

4803

Displays the number of words and characters in the selected region - Credit to original Word Count by Omer Atay

Insert Yearly Calendar

4517

Inserts a calendar of the selected year

Tag Summary with Page Names

4512

Creates a tag summary page with page names and links for each tag. Orders the results first by tag, then by the page they appear in.

Insert Long Date

4488

Insert long-format date

Capitalize Titles

4476

Capitalizes the first and last word of a selection and any other words longer than 3 letters

tOGGLE cASE

4419

Toggle casing of selected text

Set Column Widths

4204

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

Tag Complete & Strikethrough

4140

Completes the Todo tag and strikes through the selected paragraph

Clean Hyperlinks

4044

Removes all friendly hyperlinks in the current page

Outlook Email Date Stamp

3898

This macro will change the creation date of each page in the current section with the time the email was sent, allowing them to be sorted by the email date. This has been made specifically for emails sent to OneNote from Outlook.

Show uncompleted to dos

3832

Reveals uncompleted to dos that are hidden by collapsed paragraphs. Useful for hierarchical task management.

Expand/Collapse Outlines

3813

Toggle Expand/Collapse, or expand to the selected outlines to the chosen level (Level 1 to 9 as well as all levels).

Column Widths+

3742

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

Indent Paragraphs

3728

Indents the first line of each paragraph on the current page to make it more readable. It can also remove the indentation if Remove option is selected.

Set Proofing Language

3656

Prompt user to set proofing language on selected text.

Clean Authors

3642

Cleans author information from the current page

Clean Authors (Select Scope)

3619

Cleans author information on selected lines, in the current page, section, section group, notebook or all notebooks

Insert Subpage With Selected Text As Title

3549

Inserts a new page at the bottom of the section and makes it a subpage and makes the selected text the title. It also creates a link back to the original page.

Apple

3422

Make the background color of the green, more color than default apple color

Team Activity Tracker

3418

We use OneNote as an activity tracker for my small team of IT Support techs. Each day has its own page, with a table for tracking our work. Each month is its own section, and each year is a section group. This Macro allows me to create an entire year's worth of blank pages in about 5 minutes. I know there's more that could be done to improve it, but I havent the time. Feel free to use or edit this in any way that suits you. Thanks to Omer for a fantastic product, and great support!

Color Sections by Section

3409

Color all Sections in current SectionGroup by the current Section color

Programmer (Sensitive Eyes)

3407

This changes the following on the active page: Background Color, Body Font Color, Title Font Color, Header Colors, and Hyperlink colors. The theme is a light programmable theme for people with sensitive eyes.

Insert Horizontal Line between Paragraphs

3333

Inserts a horizontal line between each of the selected paragraphs

Set Page Font

3325

Sets the whole page to 1 specific font.

Remove Paragraph Breaks

3312

Removes paragraph breaks on selected paragraphs and merges them into a single paragraph

Collapse Pages

3217

Collapse all Pages in the current Section

Sort Tags

3213

Sort items by whether they are complete or not.

Resize and space

3067

Resizes images and printouts and spaces them out by the specified amount. Useful for slide images.

Title -> Calibri Light 20

2944

Changes title of each page in the current section to Calibri Light 20 to match OneNote 2013 style

Insert Page at the Top

2926

Inserts a new page at the top of the current section

Set Notebook Color

2860

Changes notebook color to hexadecimal value.

Search & Replace in Hyperlinks

2858

Search and replace in hyperlink URLs in the current page, section or notebook

Fit printout images to Letter template - for entire section

2842

If you import an 8.5x11 page from a printout (Ex. from a PDF) into OneNote, this macro will fit the image to the size of the Letter template and also set the image to background, making it ready to annonate and easily print out to paper if necessary. Note that this will only work when using the Letter template included in OneNote. This macro will apply the change across all pages in the current section, for when the imported printout's pages are spread across multiple subpages in OneNote.

Collapse Parent

2737

Collapse parent outline element

Clean Timestamps

2732

Cleans timestamp information from the current page, typically added by Insert Screen Clipping command

Insert Time Stamp

2692

Insert YYYYMMDD-HHMMSS

Search & Select

2498

Select search terms in the current page

Teal

2476

Make the background color of the page Teal, higher satuartion and more color than default teal

Insert DD Month YYYY

2390

Insert DD Month YYYY

Insert legal symbol

2355

Inserts a legal symbol (one of Δ, Π, §, §§, ¶)

Select Done Tasks

2345

Select all done tasks on current page for easy deleting (just hit delete key).

Programmer (Wombat)

2322

This changes the following on the active page: Background Color, Body Font Color, Title Font Color, Header Colors, and Hyperlink colors. The theme is a dark programmable theme similar to Wombat.

Sort Pages Ascending

2310

Sort each page in current section by name in ascending order, sub pages stay under their parent pages and sorted among themselves

Tag Completion Date

2271

Displays the completion date/time of the To Do tag on the selected paragraph

Font -> Calibri

2219

Changes text font on current page to Calibri to match OneNote 2013's style (useful for pasted text)

Sort Table (optional header)

2130

Sorts selected table by selected column. Has an option to exclude header.

Select Text With Similar Formatting

2119

Selects all the text in the current page with similar formatting to the currently selected text

Extract segment

2118

Creates a new page from a selected segment, using the first line as the title

Monthly Calendar With Task List

2074

修改自 Insert Monthly Calendar.

Tag Complete & Add Date

2029

Completes the todo tag on the selected line and adds the current date/time to the end of it

Create Task Cards

2001

Create tasks cards on the page

Customize the Title

1987

This macro is intended to show how to customize the title. You have to select the first paragraph in the current page and replace the text

Color (Select Scope)

1980

Color in the current section group, notebook or all notebooks, based on the current section.

TOC in All Notebooks

1973

Creates a new page with table of contents of all notebooks

Content Map in Current Page

1955

Add a compact, mind map style table of contents to the top of the current page. The table of contents is limited to 3 heading levels. The connector lines between nodes are 'drawn' using special glyphs from a monospace font. To minimize user interaction, no UI is displayed.

Insert Subpages With Selected Paragraphs As Title

1941

Inserts a new page at the bottom of the section for each paragraph selected in the current page, using it as a title

Black Theme

1933

Makes the background color of all the pages in a Section Black and converts existing text to white

Insert Time Last Modified

1924

Inserts the last modified date/time as MM/DD/YY HH:MMpm for each outline in the current page

Collapse Pages in Notebook

1916

Collapse all pages in the current Notebook

Clear Cells

1909

Delete text from selected cells

Content Map in Current Section

1905

Add a compact, mind map style TOC tree at the top of the current section. The tree contains links to all section pages and up three levels of headings per page. The connector lines between nodes are 'drawn' using special glyphs from a monospace font. To minimize user interaction, no UI is displayed.

Move Page to Top of Section

1847

Moves the current page to the top of the section

Insert Subpage

1838

inserts a new page at the bottom of the section and makes it a subpage

Diary Pages

1809

Create Group Section ( Diary 2017)->Create month TAB ( January )->Macro will create diary pages for a given month

Columns Width of Selected Table

1807

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

Insert Comment

1805

Insert a comment by the current author at the end of the current paragraph

Lemon

1789

Makes background Yellow, brighter than default Lemon color

Show Month

1785

This macro will draw a month calendar for the specified month. The events are the titles of pages form one or two sections in the same notebook, based on teh dateTime for the page. A page whose title has a tag will show the tag instead of the time. Each calendar event links to the relevant page

Tag Summary for Specific Tag with Page Name

1731

Creates a tag summary page for a specific tag with Page Name

Code mode

1710

Changes the text style to code (Consolas 10 pt, with a very light background, reminiscent of Evernote Code Blocks). Works even when no text is selected.

Set rule lines on/off in scope

1708

Enables or disables rule linese in given scope

Resize Images by Pixels

1707

Resizes all images image and printouts in the current page to a specified image size.

Dim Tags

1696

Dims tags on the current page so that they don't show up in tag search results

Add link

1685

ADD A LINK-TO-ORIGINAL-FILE THAT IS MISSING Procedure: 1-Shift + right click on the file 2-Choose Copy as Path 3-Go to OneNote, Onetastic Link > Add Link (the macro) 4-Paste it in the box with Ctrl+V

Uncheck All Todos

1673

Uncheck all todo boxes on the current page

TOC in Current Subpages

1623

Creates a table of contents of the current page subpages

Insert Time Stamp ISO

1611

Insert YYYY-MM-DD HH:MM:SS

Collapse Pages in SectionGroup

1577

Collapse all pages in the current SectionGroup

Grey Rulelines for Black Pages (Page)

1575

Toggles rule lines on and off for current page, sets color to dark grey, and style to small grid (made for blackboard and dark windows themes)

Set Page Date & Time

1568

Set the page date and time to desired time

Extract highlighted Text

1568

Extracts any highlighted text and prints it at the end of the page

Purple

1541

Make the background color of the page purple, fuller color than default purple

Undo No spell check

1528

Undoes "No spell check" macro. This allows OneNote to display spell check (red squiggles) in selected text if one has previously disabled this feature through the "No spell check" macro.

Add Comment

1524

Add comments to selected text. The selected text is highlighted with a color picked from a built-in pallette. Comments are put into their own section on the right of the commented text and marked with the same highlight color.

BG: Blue

1503

Highlights a text blue.

Expand Pages

1486

To expand pages

Sort All Paragraphs

1478

Sort all paragraphs on the page and optionally empty duplications

Prepend Creation to Title

1476

Prepends create date *yyyy-mm-dd* to tite if it does not exist

Perfect Printouts II

1471

Puts printouts on the left against the margin line and removes the vertical gap between each page/slide. Pages/slides are not given numbers and not turned into part of the background.

Insert Dated Page at the Top

1467

Inserts a new page at the top of the current section with title as date

Reference Pages in this Section

1443

References are added to Pages in this section (case-sensitive)

Undim Tags

1423

Undims tags on the current page so that they show up in tag search results

Add @Context

1422

In function of the Todo.txt concept, add a context to all tags that have the name "Takenlijst" in the Dutch OneNote. In English it must be "To Do" I think so you'd have to correct it in this macro. Contexts are defined in the Prompt-function so you'd have to adjust it to your likings.

Align Left

1421

Left align all selected outlines with the first one. You may wan to to add an empty outline on Top of the page before executing the macro to set a specific position.

Un/Complete Tasks

1407

Strikes through all tasks set as done (in entire page) and adds current date & time (greyed) to their end to signify when they were completed. Does the reverse on tasks that aren't done, to automatically reset a task and remove strike/date.

Proofing Language Page -> English (US)

1395

Sets the proofing language on selected page to English (US)

Go to end of the page

1391

Moves the cursor to the end of the page

Outlook FROM SubPager

1373

Creates header pages for each sender, then sorts and sets emails as subpages under the header pages. Running it a second time removes the subpaging, sorts by name, but cannot remove the header pages. These are renamed 0000DeleteMe for easy removal. This tool is for use with emails that were sent to OneNote specifically from Outlook. It may not work with exports/prints from other mail clients. Updated Jan 2017

Prio

1361

This macro is to sort a prioritized To Do list, colors them based on priority and status. You need to select the To Do list to sort them. Indented sections are treated as one, and sorting will not harm them.

Create a title for the page

1360

The titel is in form of yyyymmdd - and free text of titel (for e.g. "20141016 - Test the best")

Platinum

1338

Make the background color of the page #E5E4E2 (RGB: 229, 228, 226 - HSL: 0.11, 0.05, 0.89)

Zotero References

1315

Copy the all the zotero reference to the end of the current page.

Table to Matrix

1315

Convert a table into a matrix string, which represents a matrix in equation editor. To display as matrix, select the result string and press Alt+"=" to make it an equation and then switch it from "linear format" to "professional format".

Dark Ruled Lines for Black Pages

1307

Sets color to a dark grey for a black background

Clean Authors From Section

1295

Cleans author information from all pages in the current section

中英样式

1289

一键分别设置整个page为 英文字体14/Arial、中文14/微软雅黑,颜色黑,另外可在宏编辑器中修改以自定义喜欢的样式,已解决英文被onenote识别为中文的问题

Align and Space

1267

Left-aligns and vertically spaces the selected outlines. Change the padding value to control spacing between outlines.

Collapse All Parents

1256

Collapse all parent outline elements (based on the macro Collapse Parents but does it on the parents of the parents and so on)

Toggle Complete/Strikethrough and Sort

1253

Toggles the Todo tag Complete/Incomplete and Strikethrough of the selected paragraph. Then, sorts completed items at the bottom. This is a combonation of two existing macros.

Proofing Language Text -> English (UK)

1249

Sets the proofing language on selected text to English (UK)

Collapse Pages in Notebooks

1247

Collapse all pages in all Notebooks

Number Cells

1240

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

Set images not as background

1215

Sets all images as not background.

Set All Pages In Section Color

1206

Sets All Pages in selected Section color

Page Template Name

1169

Displays the original template used to create the current page

Shift all images up and left

1142

Shift all images up to the top left corner of the page (useful if you hate the top margin made by default with printouts)

Search & Bold

1126

Bold search terms in the current page

Sort Pages in all Sections in Notebook

1121

Sort each page in current notebook by name, pages in section stay in section and are sorted among themselves, sub pages stay under their parent pages and sorted among themselves

全页字体微软雅黑

1116

Changes text font on current page to Microsoft Yahei (for Chinese typing, refers to macro'Font -> Calibri')

Daily Manager Log

1107

Creates a Daily Manager Log page for each day in the whole year or a month

Completed tags - grey out, checked date

1104

Grey out completed tags and write date when it was completed

Tag Incomplete

1092

Marks the Todo tag Incomplete and clears strikethrough of the selected paragraph.

Align Left

1079

Aligns Left all selected containers to the topmost selected one

Custom Grid Lines

1075

Set spacing and color of grid lines to any value.

Move empty pages to end of section

1058

Moves empty pages to end of section. (Caveat: this will identify pages without text as empty, so be sure to inspect each one of them before deleting them!)

Clean Hyperlinks and HTML spaces

1046

Removes all friendly hyperlinks in the current page and any "&"nbsp";" that may subsequently appear. Many thanks to omeratay for both the original hyperlink macro and the software environment in which generate macros!

Custom Theme

1044

apply your theme. please edit macro.

To-Do List with Page Names

1028

Creates a page at the top of the section that lists all un-checked To-do tags. It is titled "TO-DO List (yyyy-mm-dd h:mm)".

Search & Spell Check Off

1019

Turn spell check off for matching text. Useful to programmers to get rid of spell check errors for technical terms you do not want to add to the custom dictionary. Examples of such terms are camel case words used for XML tag, type or function names.

Insert Day and Date

1017

Insert DD Day

All Page Font Calibri Size 11

977

All fonts change to Calibri black size 11, Titles to Font Size 20. 1 page effect

Matrix to Table

948

Convert a matrix into a table. To use this macro, you need first change your matrix into plain text by using Alt+"=".

All Section Font Calibri Light

931

All fonts change to Calibri Light, Titles to Font Size 20

New Website

929

Create a predifine structure for current Webpage

Table to Text

921

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

Insert Short Month Date

908

Insert short month format date

Sort Completed

901

Sorts all todo lists on the page by completed status.

Tag Started and Completed

896

When run once on a todo item, records the time started at the beginning. When run a second time, replaces the start time with the time elapsed since the tag and the current time and tags the item as completed. Known bugs: the cursor may jump around. Does not validate that the text after "- started at" is correct.

Title -> Calibri Light 20 (Current page only)

895

Changes title of current page to Calibri Light 20 to match OneNote 2013 style

Insert Horizontal Line (A4)

892

Inserts a horizontal line adjusted for notes (A4)

HTML Space

886

Replace the HTML space character "&nbsp" with a space " ". Helpful following use of hyperlink removal macro.

Veritical Spacing

881

This will make all selected content containers equaly spaced away from each other, Enter into the dialog box how much you want the spacing to be.

Remove All Indents From All Paragraphs

880

For every paragraph, it will sent the indent to nothing

FG: White

875

Colors a text in white.

Vehicle Auction_Spaced

873

A new vehicle auction

Search & Tag

863

Find a search term and create tags in matching paragraphs in the current page, section or notebook

Add URL to label of links

839

Take each link and add its URL to the displayed text

设置默认格式

832

设置段落的默认字体为10.5,字体为微软雅黑

Insert SubPage with Data as Title

832

Insert subpage at the end of the section and set date as a name of the page.

Insert User Comment

823

Insert a Text comment highlighted at end of current paragraph with author's initials

Insert Short Date Stamp

822

Insert "YYMMDD - "

Number Selected Cells

815

Set numbers from 1 to n to the sellected Cells

Replace Page Title with Text Selection

811

Replaces current page title with selection; if no text selected leaves page title unchanged

Sample - Create tables

808

Creates sample tables in the current page

Bring selected stacked image to front

795

Simple macro using z property - useful for stacked offset images

Mark All Pages as Read

790

This will mark each page in the current Section as Read

Dim Selected Tags

786

Dims selected tags on the current page so that they don't show up in tag search results

Annotate

782

Hightlight selected text and insert comment about the text into a new tag. Comments will be visible when you hover the cursor over the tag symbol.

Super Color

776

You can change all colors Onenote, it is recommended with Snipaste practical, / 可以改Onenote所有颜色,建议搭配Snipaste使用,.

Sort each paragraph on the page Ascending

773

Exclude empty paragraph and title and no selection needed.

Insert Page at the Top with Short Date as Title

766

Inserts a new page at the top of the current page stack and sets a short date as a page name

Clean External Hyperlinks

765

Removes all external hyperlinks, leaving internal and files intact

Create Page With Completed Tag Summary

757

Creates a tag summary page at the end of the section(s) selected for all completed tags. The page name that the tag was on is included in the summary list.

Sort paragraphs and Empty Duplications

753

Sort every paragraphs on the page exclude empty ones and title. And also delete duplications.

White Theme

749

To reset theme to defaults which is white background with black font colour, this macro is very useful if you are unable to undo changes of custom theme such as black theme, etc

Horizontal Spacing

736

This will make all selected content containers equaly spaced horizontaly away from each other (starting with topmost container), Enter into the dialog box how much you want the spacing to be.

Number First Cells

728

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

Print/SaveAs SimpleHelper - Grid 0.5" on LetterPaper

723

First, manually apply Letter size w/ margins T&B 0.5" and L&R 1". Then, run this macro to see the "ideal"printable-area if scale-down is not applied. (See my message).

Number Cells in a Specific Column

720

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

Proofing Language Text -> English (US)

717

Sets the proofing language on selected text to English (US)

Zotero Link in form of Author, Year

713

Convert each Quick Copy of Zotero Scanable Cite { | Author, Year | | |zotero://select/items/#_########} on the current page to a text in form of "Author, Year" with a hyperlink linked to Zotero. Each cite must in an individual paragraph.

Toggle Red/Black

702

Toggles selected text between red and black font colour.

Grey Out & Strike Through Completed

692

Grey out and strike through completed tags

Align Top

688

Aligns Top all selected containers to the topmost selected one

Font -> Courier New 9

680

Changes selected text font on current page to Courier New and font size 9 to indicate code parts

Task Count + Tags

664

Modified version of Task Count by Dawid. This macro counts all checkboxes and adds how many are completed to the title of the page. It also counts how many exclamation, question, star, and pin tags there are. This version counts all checkbox style tags (including CheckBox priority 1 - n, meeting checkboxes, starred checkboxes etc). Furthermore, it counts all checkbox tags applied to the same paragraph rather than just 1, so if two checkbox tags are applied to the same paragraph, it will count both of them.

Transpose Table

653

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.

Grey out completed

648

Grey out completed tags and write date when it was completed

Reset Stacked Image Order

647

Select all images on the page & put in the original order

Sample Notebook/Section/Page Picker

646

Sample macro showing how to allow user pick a notebook, then a section, than a page

Select All Containers

639

Selects All Containers

Insert Page At Top With YYYY-MM-DD + Title

635

The title is in form of yyyy-mm-dd plus text as entered in a dialogue-box. Result will be e.g. "2016-10-16 Meeting with XYZ". This helps to always keep the newest pages on top and also allows sorting pages 'alphabetically' by date. Helpful if many pages (e.g. meeting minutes of a project or customer are collected in one section).

Add icon to page title

633

Adds an icon (emoji) to the front of the title, for easy reference of page type. For example, use "✉" as the first character to easily identify pages created from emails.

Selected text --> Calibri 12 Black

631

Changes selected text font to Calibri size 12 black

Add icon to all emails

622

This macro will change the title of each page in the current section to add an email emoji to the beginning (unless it already has one). This has been made specifically for emails sent to OneNote from Outlook. Great from seeing all emails in a section at a glance.

Text To Web Search Link

612

Turns selected text into hyperlink. User can find words or phrases on the internet without copy pasting the text to browser. Choises of search engines are Bing and Google. Options are "Web", "Images", and "Videos". Helpful for online research, especially when you have many phrases to look up.

Toggle Complete/Strikethrough

608

Toggles the Todo tag Complete/Incomplete and Strikethrough of the selected paragraph.

Next Unfinished To-Do Item

608

Selects the next unfinished to-do item in the current page. The search starts after the current cursor location. Otherwise selects the first unfinished to-do item on the page.

New Meeting

607

Insert a small string of text with an automatic date & author. Ideal to start a new meeting.

Custom Rule Lines

604

Set spacing and color of grid lines to any value.

Set label of links to URL

603

Take each link and set its displayed text to the URL

Add link and rename URL text to display

598

ADD A LINK-TO-ORIGINAL-FILE THAT IS MISSING Procedure: 1-Shift + right click on the file; 2-Choose Copy as Path; 3-Go to OneNote, Onetastic Link > Add Link (the macro); 4-Paste it in the box with Ctrl+V; 5-Type a custom document name or Paste the URL and modify it to your linking

Reformat Quick Paste text and URL into a hyperlink

596

Select pasted text and link from a web page, then run a macro - the URL will be added as a Hyperlink to the text.

Add some BBcode tags

593

Adds BBcode [u][/u] [i][/i] and [b][/b] tags to underlined, italics, and bold text for copy/pasting into various places on the web. May not work across paragraphs. Preserves original formatting.

Copy text to first Page

593

This will copy all of the text from a page (and title) to the bottom of the first page in the same section. It will not copy images etc. it is a rough way to merge text pages from the bottom up. Please improve!

Insert FILES

593

Inserts a text string for clickable hyperlink to a file in filesystem

Scale

592

Inserts fixed-font 80 point scale

Input Font (Select Scope)

590

Change text and title font in the current page, section, section group, notebook or all notebooks. Size to text is 11 and title is 20.

Clone Hyperlinks

587

Clone Hyperlinks Across Same Texts in Current Page. Find each text with hyperlink, and then clone the hyperlink to the same texts in Current Page. Last updated: 2015-01-01 (fixed bugs)

Sample - Create a new page

587

Creates a new page in the current section with given title and some text content

GrayBlack Theme

586

Changes the background color of all the pages in a section to GRAY and converts existing text to BLACK.

Fix Printout RedX Issue

584

Worksaround a bug in OneNote 2016 where prinouts will show up as red X on other clients. This macro runs on current notebook and fixes all such pages.

All Section Font Calibri

576

All fonts change to Calibri, Titles to Font Size 20

Recent Edits with Author Info

574

Displays a summary page of recent edits in current section/section group/notebook or all notebooks with author info that made the edits and date

Yellow Text Background

569

Highlights a text to yellow.

A4-hoch Skala für Handnotizen

565

Fügt eine A4-hoch breite Skala für Handnotizen ein

Proofing Language Text -> German(DE)

560

Sets the proofing language on selected text to German(DE)

Light Ruled Lines for White Page

560

Sets color to a lighter grey for a white background

Übersichtliche Gestaltung für Checklisten

558

bearbeitet erledigte aufgaben auf den Ebenen 1-4

Insert YYYY-MM-DD

547

Insert YYYY-MM-DD. Original macro by alarsen: https://getonetastic.com/macroland&id=97AF320199992D0BAA87AD68887C8885

Insert One Cell Table

545

Insert a single celled table in an outline.

Sample - Insert Tags

543

Inserts all possible tags on a new page

Align Bottom

525

Aligns Bottom all selected containers to the bottom most selected one

Table Numbering with Prefix

520

Set a Prefix with numbers 1 to n on selected cells

List hyperlinks from search in new page (choose scope)

515

List hyperlinks from search in new page

Create pages from list of titles

508

Creates pages in the current section from a given list of titles separated by comma (;)

Align Right

505

Aligns right all selected containers to the topmost selected one

Insert Page At Bottom With Title

499

The titel is in form of yyyymmdd - and free text of titel (for e.g. "20141016 - Test the best")

All Section Font Calibri Light

498

All fonts change to Calibri Light, Titles to Font Size 20

Sort by Tag

489

Sort selected paragraphs by their tag name

Normal Text

481

Changes the text style back to normal after code mode (Calibri 11 pt with no background). Works even when no text is selected.

Copy Current Page to Other Notebooks

477

Copies current page to other notebooks. Only copies text content. You can select one or more target notebooks, or pick all notebooks.

Proofing Language Page -> English (UK)

470

Sets the proofing language on selected page to English (UK)

全页字体设为微软雅黑

470

点击这个脚本,即可将当前页的文本全部设置为微软雅黑。(PS:大家如果遇到什么问题,或有什么其他需求可以给我留言(请留下联系方式,以便通知您),或发邮件到 wenmin92@gmail.com)

Reset Container Size

466

Resets the container size back to automatic after forever losing the auto-width property due to manually resizing the note container.

Convert Zotero scannable cite to a Hyperlink

465

Convert each Quick Copy of Zotero Scanable Cite { | Author, Year | | |zotero://select/items/#_########} on the current page to a hyperlink linked to Zotero. Each cite must in an individual paragraph.

Shrink Pages

459

Resizes each image and printout in the current page by given percentage. This extension allows to choose either all images or the selected image only on the current page to be resized.

Search & Highlight Language

456

Highlight text with a specified proofing language

TXT2TAB

454

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

Insert YYYY/MM/DD

451

Insert YYYY/MM/DD

Font -> Verdana

450

Changes the paragraph fonts on the current page to Verdana (helps with readability). Only the font name changes. (Size, bold facing, italics, highlighting and other font options stay the same.)

Insert Page at the Bottom with Short Date and time as Title

449

Inserts a new page at the bottom of the current page stack and sets a short date and time as a page name

List hyperlinks from search in new page

445

List hyperlinks from search in new page

Clean Strikethrogh

443

Remove strikethrough texts in CurrentPage

Insert Date - ISO 8601 Basic Format

431

Insert YYYYMMDD

Go to the begining of the page

431

Moves the cursor to the beginning of the page.

Search links & add text to label

429

Prompts for: scope, text to search in link target, text to add to the label of the links found

Create new page with an ID for a Zettel

422

Creates a new Zettelkasten-Page in the current section with title beginning with yyyymmdd

Dim "In Attendace" tags

417

Dims "In Attendance" tags in current page so that they don't show up in tag search results

Enspace Hyperlinks

412

Replaces encoded spaces (%20) in hyperlink display text with actual spaces

All Section Font Calibri Black Size 11

407

All fonts change to Calibri black size 11 with no highlight color, Titles to Font Size 20

Proportional Function

406

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

Toggle Tags w/ strikethrough & date completed

403

Checked tags are disabled, strike-thoughed, & stamped w/ date completed (Only adds complete date to tags not currently disabled). Unchecked tags are enabled & remove strike-through.

Set Page to Staedtler Engineer

402

Set the Page to emulate Staedtler engineering computation pad ala TOPS TOP35502

Select all printout images beneath selected printout page.

399

This macro will select every picture with a subsequent printout page number so that they can be deleted, probably. Useful for inserted lecture slides that come in sets which encompass multiple lectures. I intend to make a more general version of this which selects images in a page based on y position instead of printout page number.

Proofing Language -> French (CA)

397

Sets the proofing language on selected text to French (CA)

Replace Line Breaks with Paragraph Breaks

391

Replaces line-breaks (inserted with Shift+Enter) with paragraph-breaks in selected text

Set All First Columns Width to 30 Value

384

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

Insert Date - ISO 8601 Extended Format

382

Insert YYYY-MM-DD

TOC in Current Section Group

378

Creates a new page with table of contents of the current section group

Bee Society - MoSCoW

376

Prioritizing using MoSCoW Technique

Insert Date - ISO 8601 Basic Format at Beginning of Page

374

Insert "YYYYMMDD - " at title location

Selected text --> Consolas

364

Changes selected text font to Consolas size 10

Duplicate Paragraph

361

Creates a new paragraph with the same text as the current paragraph

Sample Insert Text

359

Inserts text at the current position

HTML Apostrophe

355

Replace the HTML apostrophe character (&apos) with an apostrophe (').

Daily planner Page (Today)

354

Planner with Tasklist and a daily Notes page. This will create a single page with todays date on it.

Disable all tags (5)

348

Disable all tags on current page

Set Page Level to Three for All Pages in Section

345

Modifies every page level property in current section and sets it to 3

Append Date to Title (dd.mm.yy)

340

Modifies the page title to append the date in DD.MM.YY format

Toggle Complete & Strikethrough

340

Every checked tag becomes disabled w/ strike-through, every unchecked tag becomes enabled w/o strike-through.

Find Table Rows with Search Term

335

Searches for a term in the current notebook in tables and outputs the found whole table rows into a new page

[Activity #] tag & type

334

Inserts bold [Activity #] tag and then prompts user to enter the title of the activity and type of activity in Adler University's course build OneNote books

First-line indent

333

Set a first-line indent of each paragraph. However, it ignores the following cases.

  • Paragraph in the table
  • bulleted paragraph
  • numbered paragraph
  • blank paragraph
  • paragraph other than default style is set
  • "center" or "right" alignment is set.
  • If you want to change the default value of each setting, please edit the macro.

    Toggle To Do & Strikethrough for Selection

    324

    Toggles the todo tag and strikethrough for the selected paragraphs

    Insert page with selected text as title

    319

    Inserts a new page at the bottom of the section and makes the selected text the title. It also creates a link back to the original page.

    Replace [KW] with current calendar week

    317

    Replaces placeholders with pattern [KW] or [KW]+d; (where d is a digit) with the corresponding calendar week (adding the digit behind +)

    转换中文

    317

    将选定内容的校验语言设为中文,以屏蔽单词拼写问题 (Set the proofing language on selected text to Chinese)

    Exponentiate Cells

    316

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

    我的评论

    308

    Insert a comment by the current author at the end of the current paragraph

    Set Left = 0

    302

    Sets Container(s) Left = 0

    Rename Links to Single Name

    301

    Rename Links - useful for batch renaming links to a single name - good for tables when link acts as a button to launch a media file or site

    Add Footer to All Pages

    284

    Adds the given text to the end of all pages in the current section

    Add URL to label of links if missing (any scope)

    276

    Take each link and add its URL to the displayed text

    Capitalize Page Titles

    276

    Capitalize titles of pages under selected scope

    全页字体等线

    275

    Changes text font on current page to Microsoft Yahei (for Chinese typing, refers to macro'Font -> Calibri')

    Sample Create Section Hierarchy

    274

    Creates a sample section group/section hierarchy

    Sentence Case

    273

    Capitalize the first letter in each sentence in the selected text

    Move page with a given string in the title to end of section

    270

    Move page with a given string (case-insensitive) in the title to end of section

    Convert Paragraph Font to Segoe UI

    270

    Standard text on the page will now be Segoe UI 10 and headings will be Segoe UI 14

    Add Author to Title

    266

    Modifies the page title to append the author's name

    Insert Dated Page with Section

    266

    Inserts a new page with title as date and section name. Update to 'Insert Dated Page at the Top' by Cyrus/Omer Atay to append the section name at the end of the title as well. Also add's the page to the bottom of the section rather than at the top.

    Highlight Hashtags

    265

    Highlights hashtags (#word)

    Font -> 맑은 고딕

    265

    Changes text font on current page to Calibri to match OneNote 2013's style (useful for pasted text)

    Create sections from list of titles

    259

    Creates sections in the current notebook (or section group) from a given list of titles separated by semicolon (;)

    Proofing Language -> Portuguese (Standard)

    259

    Sets the proofing language on selected text to Portuguese (Standard)

    Obscure Toggle

    254

    Convert Selected Text into other text based on key requested from user. Same process will convert back to original if same key is supplied. (This mimics the way Evernote encryptation works, but the algorithm here is quite weak. Note that spaces, quotation marks and control characters such as carriage returns are simply passed through.)

    Proofing Language Page-> Dutch (NL)

    251

    Sets the proofing language on selected page to Dutch (NL)

    Sample - Custom Sort Notebooks

    245

    Sort notebooks by after the first 6 characters of name

    Change Tag Text

    244

    Change the text that appears when you hover over a tag. The new text have more than one line. Select anyplace in paragraph that contains the tag whose text your want to modify.

    Rename Selected Links to Single Name

    241

    Rename Selected Links - useful for batch renaming links to a single name - good for tables when link acts as a button to launch a media file or site (selected links only)

    Proofing Language -> French

    241

    Sets the proofing language on selected text to French

    Proofing Language Text -> Dutch (NL)

    238

    Sets the proofing language on selected text to Dutch (NL)

    [Page] tag & text

    237

    Inserts bold [Page] tag and then prompts user to enter the author, year, page title and URL for a web page or web site in Adler University's course build OneNote books

    Color PowerShell Comments

    237

    Changes color of text starting with a single quote (#) on selected lines to green

    Spanish Proofing

    236

    Switch proofing and change style to show Spanish text

    Select Highlighted

    232

    Selects all highlighted text on the page

    Créer page avec Tag

    223

    Crée une page avec le tag choisi

    Task Count++

    220

    Modified version of Task Count by Dawid. This macro counts all checkboxes and adds how many are completed to the title of the page. This version counts all checkbox style tags (including CheckBox priority 1 - n). Furthermore, it counts all tags applied to the same paragraph rather than just 1, so if two checkbox tags are applied to the same paragraph, it will count both of them.

    创建任务卡

    220

    在当前页面创建任务卡

    Collect Clipped URLs

    214

    Collect clipped URLs from current section or notebook

    Proofing Language -> Spanish (es-ES)

    211

    Sets the proofing language on selected text to Spanish (es-ES)

    Untag/Select All Completed Tasks

    206

    Untag and select all completed checkbox tasks for easy deletion within the page being edited.

    Search & Replace in Titles

    203

    Search and replace text in titles of pages in selected pages, current section, notebook or all notebooks

    DateTime Stamp

    162

    Add properly formatted DateTime stamp

    Insert page Title at Cursor

    160

    Inserts current page title + " - " at cursor

    Color PowerShell Comments + NoSpell

    154

    Changes color of text starting with a hash comment (#) on selected lines to green and remove spell checks

    Color VB Comments

    153

    Changes color of text starting with a single quote (') on selected lines to green

    [PDF] tag & text

    151

    Inserts bold [PDF] tag and then prompts user to enter authors, year and short title of the PDF document in Adler University's course build OneNote books

    Set Container Width 618

    149

    Sets the container size

    Offline Reading tag & text

    149

    Inserts bold Offline Reading tag and then prompts user to enter authors, year, short title and chapters of textbook in Adler University's course build OneNote books

    Vote Count

    144

    This macro will count the todo list tag for voting purposes on a collaboration workspace such as on OneNote Classroom Creator. The result of the vote is displayed on the header. in order to use the Vote count you should create a list of voters. Giving them a to do list. Each votore check the to do list. it means voted.

    Crear título fecha

    132

    "AAAA-MM-DD Título_opcional" con fuente por defecto

    List Password Protected Sections

    131

    Lists the password protected sections in the current notebook

    Proofing Language Page -> Polish (PL)

    129

    Sets the proofing language on selected page to Polish (PL)

    Proofing Language -> Dutch (NL)

    129

    Sets the proofing language on selected text to Portuguese (Standard)

    Sample - Move Last Row To Top

    124

    Sample macro showing how to rearrange rows in a table

    Sort Paragraphs by Highlight Color

    120

    Sort selected the paragraphs by the highlight color on them. You can use this after using "Extract Highlighted Text" macro to sort the extracted text by highlight color

    Format Numbers

    118

    Applies specific formatting to all numbers in the selection or the current page

    Create Take a Test App link

    116

    Converts selected URL to URL used by new Take a Test App in Windows 10 Education edition.

    Proofing Language Page -> German (CH)

    115

    Sets the proofing languae on selected page to German (CH)

    Add current paragraph link to currently selected text

    112

    Transform into an hyperlink to their own paragraph all selected texts in the current page

    Add Date before Title (yy/mm/yy)

    111

    Modifies the page title to add the date in yy/mm/yy format

    [Interview] tag & text

    111

    Inserts bold [Interview] tag and then prompts user to enter the title of the interview, Kaltura vido's entry ID, and title of video as it appears in the Kaltura video in Adler University's course build OneNote books

    Reformat Quick Paste text and URL into a hyperlink (text in BOLD)

    109

    Select pasted text name (must be bold) and link from YouTube video name and link, then reformat in only one line reduced format

    Set Proofing Language to en-gb or pl-pl

    105

    Toogle proofing language on selected text between en-gb and pl-pl

    字体修正

    103

    不会修改页面中的”Consolas“字体。修改自”中英样式“,未免丢失上传。

    Proofing Language Text -> Polish (PL)

    101

    Sets the proofing language on selected text to Polish (PL)

    Insert REVERSE

    97

    Inserts text string REVERSE with red background and white font color

    Calibri2微软雅黑

    96

    把页面中所有Calibri字体的文字修改为微软雅黑字体

    Insert HH:MM:SS Time Stamp

    96

    HH:MM:SS

    SetstatusRecycle

    90

    Sets background of currently selected to orange

    [Panel Discussion] tag & text

    87

    Inserts bold [Panel Discussion] tag and then prompts user to enter the title of the panel discussion, Kaltura vido's entry ID, and title of video as it appears in the Kaltura video in Adler University's course build OneNote books

    Add Collmex Link

    82

    Creates a link to collmex customer from selected text. Collmex is a german ERP cloud solution at www.collmex.de. How to use: Adjust your own collmex number. Then start using: Every of your customer gets a unique number. Just type this number, select the number and this macro will insert a link to this specific customer.

    Proofing Language -> Czech (CZ)

    81

    Sets the proofing language on selected text to Czech (CZ)

    Set Page Level to 1 for All Pages in Section

    77

    Modifies every page level property in current section and sets it to 1

    Proofing Language -> Slovenian (SLO)

    76

    Sets the proofing language on selected text to Slovenian (SLO)

    Proofing Language Page -> Spanish (ES)

    75

    Sets the proofing language on selected page to Spanish (ES)

    Letter sized paper with infinite length and ruled horizontal lines

    73

    Adds a vertical rule line to a letter sized paper with infinite length and ruled horizontal lines. You can change the rule line color afterwards from View > Rule Lines > Rule Line Color if you want.

    Proofing Language Text -> German(AT)

    73

    Sets the proofing language on selected text to German(AT)

    Select Between First two Heading 1

    69

    Selects all content between the first and the second Heading 1 styled paragraphs in the current page

    Generate Random String

    68

    Generates a random string of 10 characters and inserts it to the current page

    Append Desired Text to All Page Titles

    66

    Appends given text to all page titles in either the current notebook or all notebooks

    Set Page Level to Two for All Pages in Section

    64

    Modifies every page level property in current section and sets it to 2

    Reformat Quick Paste text and URL into a hyperlink (YT tam18)

    63

    Select pasted text (default text size 18) and link from YouTube video name and link, then reformat in only one line reduced format

    All Page Font Meiryo UI Size 10

    63

    All fonts change to Meiryo UI black size 10, Titles to Font Size 20. 1 page effect

    Check All Todos

    62

    Check all todo boxes on the current page

    Proofing Language -> Danish

    56

    Sets the proofing language on selected text to Danish

    Resize Images Android

    54

    Resizes each image to good size for Android app

    Convert Copied Paths to File Hyperlinks Macro

    54

    Converts selected pasted "Copied Paths" into file hyperlinks. This provides similar functionality now removed from OneNote that allowed files copied from windows explorer to be pasted as hyperlinks. To use; 1-Ctrl Select multiple files within windows explorer, 2-Shift + right click one of the selected files, 3-Choose "Copy as Path" from context menu, 4-Go to OneNote and paste into a page, 5-Select all pasted paragraphs, 6-Select "Convert Copied Paths to File Hyperlinks" from Onetastic's hyperlink menu. See a demo of the macro in action at https://youtu.be/22nMT8wy8Cc. If you find this macro useful please consider donating to http://www.paypal.me/SimonRear to encourage the development of more useful timesavers.

    Set Entire Section Font to Segoe UI Family

    53

    This will change all fonts in the section to the Segoe UI (Windows 10 style) family of fonts. Paragraph font Segoe UI 10, Title font Segoe UI Light 16, Tables font Segoe UI 10. It will not adjust bold or other styles leaving them intact.

    All Section Font Meiryo UI

    53

    All fonts change to Meiryo UI, Titles to Font Size 20

    Insert Space Between Paragraphs

    53

    Inserts an empty paragraph between each of the selected paragraphs

    Proofing Language -> Swedish

    47

    Sets the proofing language on selected text to Swedish

    Title > 黑体 15.5

    40

    修改当前页面标题的字体为黑体,字号为 15.5。

    Proofing Language Page -> Bulgarian (BG)

    38

    Sets the proofing language on selected page to Bulgarian(BG)

    Tag Action Owner

    35

    Prompts for and tags action owner e.g. [PS] - at beginning of paragraph in bold, red text

    Font -> Consolas 11pt

    34

    Changes font to Consolas with size 11pt on current pages

    Clark_Title

    34

    标题格式:中文宋体,英文Times New Roman,20号粗体

    Insert Selected Text in a Custom Table

    33

    Styles a selected text (adds a highlight color and an important tag) and builds a custom table for the current section group in a new section [Course Overview], on a new page [Recent Feedback]. New rows are added at the top when further text from the same section group is selected.

    Sort Rows by Tag

    32

    Sorts the rows of the selected table based on the first tag in the first cell of each row

    Clark_Text

    28

    正文格式:中文宋体14号,英文Times New Roman14号

    Clark_Code

    26

    代码格式:代码Courier New12号斜体

    字体修正by翠翠酱

    22

    正文中文改为微软雅黑12号,英文改为consolas12号,标题为20号,修改自”字体修正“,为避免丢失上传。PS:大家如果遇到什么问题,或有什么其他需求可发邮件到 shadowspacex@163.com)

    Set Section Container Width 618

    19

    Sets the container size

    Proofing Language -> English (US)

    14

    Sets the proofing language on selected text to American English

    Proofing Language Page -> Croatian (Hr)

    14

    Sets the proofing language on selected page to Croatian (Hr)

    All Section Font Meiryo UI Size 10

    13

    All fonts change to Calibri Light, Titles to Font Size 20 Other Font Size 10

    Proofing Language Text -> Croatian (Hr)

    12

    Sets the proofing language on selected text to Croatian (Hr)

    Replace SmartQuote

    6

    Find & Replace smart quotes from Microsoft word

    Proofing Language -> Swedish

    4

    Sets the proofing language on selected text to Swedish