If you want to work out average inflation rates over the period 1961 to 2008, you will also want to delete all except rows 5, 8, 9, 20, 31 and 40. In the above table you will probably want to delete rows 1, 2, 3, 4, 6 and 7. Next delete unwanted rows, by selecting the row (click on the row number in the left-hand column) and then pressing the delete row icon ( ). This will move all the entries in row 5 one column to the right. Then click on Insert > Cells > Shift Cells Right and then OK.

To rectify this, click in cell A5 (currently labelled BE). In the above, row 5 is one cell too far to the left. It will help if you have an Insert Row and a Delete Row icon in your toolbar at the top ( how to configure your toolbar).įirst ensure that the columns are correctly aligned. You will now need to do a little manipulation. This will give you a table similar to that below. Click in this cell and past in the table you have copied from Word. While still highlighted, copy this by pressing Ctrl C. Press OK.Ī table will appear (poorly formatted) which will be all highlighted. A dialogue box will pop up and under Separate Text at, you should select Other and click in the little box next to it delete what is there and type in a space. Now convert this into a table by highlighting it all (you can easily do this by pressing Ctrl A) and selecting Table > Convert > Text to Table. Open a new Word document and paste the copied text by pressing Ctrl V. Step 2: Copy this into Word and convert to a table

To copy the table, click on Select and click and drag the cursor to highlight the whole table. The first page of Table 10 from the Spring 2007 version of the European Economy Statistical Annex is shown below. This shows economic growth rates for all 27 EU countries plus the USA and Japan (see site 8 in our links to free economic data) Step 1: Open the relevant PDF file and select and copy table We will use Table 10 from the European Economy Statistical Annex. If such services are not working for you, there is also a conversion process that involves moving the data first into Word and then into Excel.

There are online services to convert data tables from PDF to spreadsheet for example, , PDF2Excel, SmallPDF, or DocsZone.

Insert pdf in excel 365