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.
Until next time,