Welcome to Excel 3 tip Friday, your weekly Excel tips and tricks to keep your skills sharp.
This week we cover creating your own Excel shortcuts menu, an easy date formatting shortcut, and the CONCATENATE function which allows you to combine text from different cells into one cell.
An Excel tip you can use to customize your Excel menu:
Do you find yourself constantly using menus in Excel that take lots of clicks to get found? You can create a custom menu of your own for quick access to the buttons you need the most.
To set one up, go to the Excel Options menu under the File tab. From here, you can either select the Quick Access Toolbar or Customise Ribbon. Both will allow you to drag and drop buttons into a new custom menu or even a new custom tab.
Another useful shortcut to learn:
My date format of choice in Excel is dd-mmm-yy, or for example 09–Feb-19 but frustratingly, the date formatting options in Excel require quite a few clicks to get this to this format. Luckily there’s a shortcut for this, Ctrl + # will auto format any date into the above format.
A function to join text together:
The CONCATENATE function allows you to combine the contents of multiple cells into one. Use =CONCATENATE( and select each cell separated by commas to produce a text cell that combines them all together into one.
This is useful when working with data that is split across multiple columns, or when you’re trying to make a cell that creates a sentence from other cells.
For example, if you have a First Name in column A and Last name in B, you could enter =CONCATENATE(A1,” “,B1) to create a full name column, with a space in between the names.
That’s all for this week. What are your favorite Excel tips and tricks for productivity and time-saving? Let us know and we’ll include the best ones in future updates!