Can I make annotations in EXCEL?

joylee

New Member
Joined
Oct 12, 2019
Messages
15
Office Version
  1. 2016
Platform
  1. Windows
Dear friends,
I would like to write annotations, as shown below, while I am explaining EXCEL to my students.
Although my handwriting with a regular mouse looks ugly, I know I can manage to do it in PPT because it has the 'pen' function. But I cannot find anything like that in EXCEL. Is this because my notebook is not a touch-screen device? Can I do it if I buy a 'smart pen', 'digital pen', or 'pen mouse'? My final goal is making a video file (MP4) of my lecture. Should I buy a tablet PC? My notebook is ASUS ZEN UX330U installed with Office 365. I am very confused, and your help will be greatly appreciated. JYLee

1594924058668.png
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

JustynaMK

Well-known Member
Joined
Aug 28, 2016
Messages
674
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Hi joylee,

If you have Office 365, you should be able to add "Draw" ribbon to your Excel:

1594928042405.png


I admit it is quite difficult to use with just a mouse but I'm hoping this is a good starting point for you :) and perhaps MrExcel members will have some other ideas for you.
Good luck with your lecture!

1594928116573.png
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
63,944
Office Version
  1. 365
Platform
  1. Windows
Perhaps take a snapshot or print the file so that it is in some format like PDF or JPG, and draw on the image (with your choice of tools).
 

ZVI

MrExcel MVP
Joined
Apr 9, 2008
Messages
3,875
Office Version
  1. 2019
  2. 2016
  3. 2010
Platform
  1. Windows
Hi,
Not exact what is asked but for equations you may try Ribbon – Insert – Equation – Ink Equation.
See also 'Normal text' option for non-math text on Equation tab of the Ribbon.
 
Last edited:

joylee

New Member
Joined
Oct 12, 2019
Messages
15
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

Perhaps take a snapshot or print the file so that it is in some format like PDF or JPG, and draw on the image (with your choice of tools).

I understand the way you suggested. Thank you. But I want to write annotations while I am running EXCEL.
JYLee
 

joylee

New Member
Joined
Oct 12, 2019
Messages
15
Office Version
  1. 2016
Platform
  1. Windows
Hi,
Not exact what is asked but for equations you may try Ribbon – Insert – Equation – Ink Equation.
See also 'Normal text' option for non-math text on Equation tab of the Ribbon.
Thank you. My experiment has shown that it is not what I am imaging. I wish I can write with some pen, not with my mouse.
 

joylee

New Member
Joined
Oct 12, 2019
Messages
15
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

Hi joylee,

If you have Office 365, you should be able to add "Draw" ribbon to your Excel:

View attachment 18390

I admit it is quite difficult to use with just a mouse but I'm hoping this is a good starting point for you :) and perhaps MrExcel members will have some other ideas for you.
Good luck with your lecture!

View attachment 18391
Dear
Dear friends,
I would like to write annotations, as shown below, while I am explaining EXCEL to my students.
Although my handwriting with a regular mouse looks ugly, I know I can manage to do it in PPT because it has the 'pen' function. But I cannot find anything like that in EXCEL. Is this because my notebook is not a touch-screen device? Can I do it if I buy a 'smart pen', 'digital pen', or 'pen mouse'? My final goal is making a video file (MP4) of my lecture. Should I buy a tablet PC? My notebook is ASUS ZEN UX330U installed with Office 365. I am very confused, and your help will be greatly appreciated. JYLee

View attachment 18380

Dear JustynaMK,
Thank you very much for your help. However, my excel does not show the 'draw' tab to check.

View attachment 18452
Has my Office 365 been contaminated?
JYLee
 

JustynaMK

Well-known Member
Joined
Aug 28, 2016
Messages
674
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
@joylee hmm not quite sure, but I'd suggest following Microsoft's link to check if your subscription allows you to activate "Draw" ribbon. Seems to be what you are looking for.

Also found on Microsoft support page:

Notes: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

This feature also requires Windows 10 version 1511 or later. For help determining which version you are running, see Which Windows operating system am I running?. For information about updating, see Windows Update: FAQ.
 

joylee

New Member
Joined
Oct 12, 2019
Messages
15
Office Version
  1. 2016
Platform
  1. Windows
Dear JustynaMK,

After enough frustration, I have finally found that I have EXCEL 2016, not 365. Also, I found comments on 2016 that it does not have 'DRAW' function. Thank you for your kind help. I guess I have to buy a touch-screen notebook. JYLee
 

JustynaMK

Well-known Member
Joined
Aug 28, 2016
Messages
674
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Ahh... sorry to hear that!
I wonder if it might be cheaper for you to upgrade your Office version, instead of buying a new notebook.
Anyways, fingers crossed, hope you will find the solution soon :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,650
Messages
5,854,948
Members
431,689
Latest member
jacker01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top