How to add comments in Excel

dataminded excel course

Welcome to your weekly 3 tip Friday update, it’s just a short dose of Excel help before you start the weekend. Each week we’ll cover a tip, a shortcut and a function - making it super easy for you to get better at Excel. 

 

A quick win you can learn today - 

When you’re printing a long data sheet, did you know that you can set up the page to print column headers at the top of each page. To do this, 

  • Click the [Page Layout] tab > In the "Page Setup" group, click [Print Titles].

  • Under the [Sheet] tab, in the "Rows to repeat at top" field, click the spreadsheet icon.

  • Click and select the row you wish to appear at the top of every page.

  • Press the [Enter] key, then click [OK].

 

A keyboard shortcut I'm adding to my list - 

Adding comments to cells can be done through the right click menu on any cell, allowing you to create a hover over pop up comment explaining a number or table. To add these using a keyboard shortcut, use Ctrl + F2. 

 

A function I've found super useful this week - 

I often find myself working with messy text in Excel, trying to remove excess characters or extract information from text. 

The FIND function will return the number of characters into a cell that a specified character appears - so to find the character ‘-‘ in cell A1 containing 01-03, use the function

=FIND(“-“,A1,1), where 1 is the position in the cell that you want to search from (1 would mean from the start of the cell). In this case, the function would return 3. 

You could then use this to determine which cells contain the character, or return cells to the left or right of this using LEFT and RIGHT.  

In the meantime, check what’s new in Excel 2019 for Windows by clicking here!

Until next time,

- Martyn

Edinburgh, Scotland

August 2018

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit