In this week’s Excel tips update, we cover how to create images of tables, a shortcut to close Excel, and how to extract text from the middle of a cell.
A quick win you can learn today -
I’ve recently been working with a client on executive reporting - which involves a LOT of powerpoint. One aspect that always used to frustrate me was copying and pasting tables between Microsoft Excel and Powerpoint - they never ended up looking right. I’ve since discovered that you can paste tables as images into Excel, or any other Microsoft Office program, which allows you to simply resize the image to the page or area, rather than changing borders, font sizes, fitting text etc.
To paste a table as a picture in Microsoft Excel - first copy the data, and right click into any cell, hover over paste special, and select the ‘paste as image’ option. These images can’t be edited or turned back into an Excel table to be sure to keep the original!
A keyboard shortcut I'm adding to my list -
Keyboard shortcuts are all about making Excel quicker to use, even if it’s just saving seconds each time, they all add up. Use the shortcut Alt + F4 to close your current workbook, or Shift + Alt + F4 to close all workbooks in Excel. You’ll be prompted to save your work where changes have been made, but this is a great way to quickly close all of you Excel work if you have many workbooks open.
A function I've found super useful this week -
It’s common to have datasets where more than one piece of data is contained in a single cell - say a product code 0123-XYZ-9876 is in a single cell, and you need to extract the ‘XYZ’ for the whole column. You can use the MID function to do this - it’s a pretty easy function to use - just type =MID( followed by the location of the cell containing the text, the start position within the cell (for this example, we’d start at the 6th character), and the number of characters to return (3, in this example.
It’s another great function to know to be able to manipulate text in Excel.
As always, I hope you find these tips useful, and please do reply if you have any comments or questions!
Get my new mini course in the Black Friday Sale
I’ve recently compiled a new course of the 40 most useful functions in Excel, you can get it now over on Udemy in the Black Friday sale!