Have you ever been knee-deep in creating a PowerPoint presentation when someone sends you a table that you’re supposed to include? The catch? It’s a screenshot and you’re left scratching your head, wondering how to convert this picture into an editable table in Excel. We’ve all faced this frustrating scenario. You’re not alone. Most of us have probably yelled at these images, wishing they’d somehow morph into editable text. But there’s good news! There’s a simple way to transform that static image into a dynamic table you can adjust to your heart’s content. Let’s walk through the process together.
Step 1: Copy and Paste the Image into Word
Start with your image. This is your sales table, if you will. Select the picture by clicking on it, then press Control + C or right-click and choose “Copy”. Open Microsoft Word and get ready to paste your image. But wait! Don’t just hit the paste button.
- Go to Paste on the toolbar
- Select Paste Special
- Choose PNG from the list, avoiding options like JPEG or GIF
Once you’ve pasted your image, you might find it looks enormous. Don’t worry, just shrink it down so it fits comfortably on your screen.
Step 2: Save as a PDF
Now that your image is in Word as a PNG, you’ll want to convert this document to a PDF. It’s easier than you think:
- Click File
- Select Save As and choose your desktop or a location that’s easy for you
- Name your file, something like “Annual Sales”
- From the file type dropdown, pick PDF
- Hit Save
Your beautifully converted PDF should now be resting on your desktop. Close Word to proceed.
RELATED CONTENT: How to Export Data from a PDF to Microsoft Excel
Step 3: Convert PDF Back in Word
We need to open this PDF in Word for its magical conversion powers.
- Go to File again, then Open
- Navigate to your desktop and select your new PDF
- Word will mention it’s converting the PDF. Click OK
In an instant, your image has transformed into an editable table. It’s pretty amazing, right?
Step 4: Copy the Table into Excel
You now have an editable table. Time to take it to Excel for some data manipulation.
- Select the entire table
- Control + C or right-click and Copy the table
- Switch over to Excel
- Paste your table where you need it
In Excel, you can go wild with edits. Bold text, change font sizes, adjust styles—whatever suits your needs.
RELATED CONTENT: How to Perform Calculations in a Pivot Table Microsoft Excel
Step 5: Paste Back into PowerPoint
Finally, once your table looks just how you want it, paste it back into PowerPoint.
- Control + M gives you a new slide
- Control + V pastes your freshly edited table
Now, you’re ready to apply some stylish PowerPoint designs or leave it as is, snugly fitting into your presentation, perfectly editable.
Conclusion
With these steps, you can convert any frustrating picture into an editable table in Excel to be used in PowerPoint. No need to plug away at manual entry, yelling at an unyielding image. It’s a simple trick that opens up a world of efficiency. Don’t forget, the key step is the Paste Special in Word as a PNG. Miss that, and your plans might falter. This little gem of a process is here to save your time and sanity. If you liked this guide or have suggestions for future tips, drop me a comment. Until next time, happy presenting!
Get started with Microsoft 365.
Be sure to subscribe to my YouTube Channel for more Microsoft Excel and Microsoft 365 tutorials.
This page may contain affiliate links. These are tools I personally use and love. I may receive a small commission should you make a purchase using one of these links. This helps keep the tutorials and website posts coming and up to date. Thank you for your support! For more information please see my full disclaimer.
