Feb 25, 2016
I am often asked how to format an Excel table in InDesign as many of us frequently work with Excel tables given to us by clients. The one I run into most often is the Excel spreadsheet of price listings or item features, which I then have to make presentable for a catalogue or sales collateral. Many designers recreate these tables from scratch to make them clean and attractive, but this can be time-consuming, especially with large tables.
There is a better way. InDesign has an “Import table” feature. You can import the client’s table from Excel and style it however you want. Use the “Place file” option in the File menu (or Command/Control + D), make sure that you select “Show import options” and you’ll be able to define the cells to import on the next screen and then style them as a group.
How do your Excel skills stack up?
Test NowNext up:
- Streaming Xbox One to Windows 10
- 3 Simple Pie Chart Tricks
- Tips and Tricks with Nintex Forms
- The Agreement Frame: Solving Complex Arguments
- How-To Series: Photoshop CC Intelligent Upsampling
- My thoughts on the Moto 360 SmartWatch
- Skype for Business Server Architecture
- Windows 10 Command Prompt Shortcut Keys
- Do you Kanga?
- PowerShell Profiles - Have it your way (Part 2)
Previously
- Rugby in the workplace
- Configuring Lync Room System
- Transparent Images in PowerPoint 2013
- PowerShell Profiles – Have it Your Way
- Get a Better View – Through Office Lens
- The problem with accepting constructive feedback
- Adding videos to your website
- The magic of scrollbar control in Excel
- Service Design in ITIL®
- Slugging it out, and the need to bleed