While holding down, drag the cell to another location. Single click on a cell and hover your mouse over the edge of the cell until it turns into a hand. This is a problem in that text that is supposed to be together is not. Holding down the Shift key when you paste will result in each line of the PDF pasting into a new row on the spreadsheet. When pasting from the PDF all of the text is together into one cell, difficult to deal with. In Google Sheets, in particular, this is known as paste special. One trick when pasting is to hold down the Shift key.

This is going to chop up paragraphs, copy headers and footers, and do other not nice things for when you paste. Highlight the text on the PDF and use Control C to copy. Try sharing a PDF of standards with your students and asking them to copy them into a spreadsheet and to clean up the data.Īt the bottom, I have some resources for providing your students with directions on how to clean up data copied from a PDF into a spreadsheet. I am not doing that by hand! This is a handy skill. Paper or PDF you probably need to by hand type into some sort of lesson planning guide. A nicely organized PDF document is nice for printing but terrible for doing anything with it. It is so frustrating to look up online the standards for something and to not have it in a spreadsheet format. Paste Special from a PDF to a Spreadsheet

Copy text from pdf to excel