easy way to copy and paste list into excel

#Easy way to copy and paste list into excel how to#

So go ahead and make all your columns a suitable width for the text they contain, and bear in mind that you’ll be fine-tuning the fonts later so no need to be too fussy. The first adjustment you can make to your table is to get the columns to fit within the page margins. When the small double arrow appears, click and drag to the left or right to change the width of that column. Now try changing the width of a column by hovering your Type Tool over a vertical line between two columns. Click with the right arrow showing, and you’ll select a row (or click and drag up or down, and you’ll select a number of rows). And finally, run the Type Tool along the left edge of the table, and you’ll see a black arrow pointing right. Click with the down arrow showing, and you’ll select a column (or click and drag to the left or right, and you’ll select a number of columns). Next run the Type Tool along the top edge of the table, and you’ll see a black arrow pointing down. Click with the diagonal arrow showing, and you’ll select the whole table (it’ll look black). Start by hovering your Type Tool at the top left corner of your table, and you’ll see a black arrow pointing diagonally down to the right. So switch to your Type Tool and spend a few moments experimenting with selecting rows, columns, and the whole table, as this will be useful later on. You might assume that you’ll use the Selection Tool to resize your table, but actually you’ll use your Type Tool for absolutely everything to do with your table from now on. Next you’ll work on the table itself, to get it looking just right. You’ll notice that changing the size of your text frame doesn’t change your table at all it simply aligns the frame on the page.

#Easy way to copy and paste list into excel how to#

We’ve explained how to lay out and typeset tables in Book Design Made Simple (pages 342 through 347), but if you don’t have the book in front of you, you can use these steps to format a simple table.įirst, get the text frame lined up on your page by dragging the whole frame onto your page and then adjusting the edges of the text frame to line up on your margins. So … you’re done, right? Well, not exactly.ĭon’t be discouraged if your table looks like a disaster in InDesign! We’ve imported a very simple Excel spreadsheet as an example, and you’ll see below that all of our bold and italic formatting has been lost, the columns are different widths than they were in Excel, the text frame is a different size than the table, and there is overset text (some rows at the bottom that don’t show). That’s right, whether you placed a table from Word or a spreadsheet from Excel, it is converted into a table in your InDesign document. Note that your spreadsheet has now become an InDesign table. Voila! You’ve successfully placed your Excel spreadsheet in InDesign. You want the spreadsheet to be separate from your other text frames for the time being, so click anywhere on a blank page or on your pasteboard to place the spreadsheet. Now your mouse pointer will be loaded with your Excel spreadsheet. Your Cell Range will be different than shown below, but no need to worry about it.

The settings shown below are the default settings, and they are fine. Next you’ll see the Microsoft Excel Import Options dialog box. Make sure the Show Import Options box is checked, then click Open. Choose File>Place (or use the keyboard shortcut Ctrl/Cmd+D), then browse to select your Excel file. Click anywhere outside of any existing text or image frames to make sure nothing is currently selected. To import your Excel spreadsheet into an InDesign document, first open your InDesign document and choose the Selection Tool. Get started importing from Excel into InDesign And, because spreadsheets and tables rarely import into InDesign looking like they did in Excel and Word, we’ll give you a few tips on the easiest way to get started. Have you tried importing from Excel into InDesign? In Book Design Made Simple we walk you through importing tables from Word, but importing a spreadsheet from Excel is a bit different so we’ll walk you through it here.