Company News

How to Use AutoFill in Excel to Quickly Create a Bullet Journal Layout in OneNote

March 13, 2018

One tip that I’ve found very useful for building bullet journal templates in OneNote is to use the AutoFill Series feature in Excel 2016. It works well for both dates and months, and when you copy/paste it into OneNote the table formatting is preserved.

Here’s a screenshot to illustrate what copying from Excel into OneNote looks like:


Here’s how the AutoFill months works:

After typing the first month, drag the AutoFill handle across the row to fill in the other months:

After you create the table in Excel, select the cells and copy. Then insert your cursor into the OneNote page and Paste – see:

Here’s a link for instructions from Microsoft Support website on how to use the AutoFill in Excel.

Leave a Reply

Kelly Marshall

itgroove Alumni

Kelly Marshall

Subscribe via Email


Powered by...

itgroove Corporate Profile
Connect With Us