under “edit,” click on “Delete.”
: (1) avoid Adobe Acrobat files
(i.e., “pdf” files – choose html); (2) click and highlight the data you wish to download; (3) in the upper left corner click on “Save As”; (4) while you can use any “File Name” you want, be sure that across from “Save as Type” you choose (i.e., highlight) “Text File” and for “Encoding” select “Western European (ISO)”; (5) choose the drive you want to save to and click on “Save”; (6) Open Excel; (7) under “Files of Type” choose “Text Files”; (8) double click on the file name for the file you downloaded; (9) choose “Fixed Width”; (10) click on “next”; (11) click on “next” again; (12) click on “Finish”; (13) save the data as a “Microsoft Excel Workbook” file.
: if the data in the resulting
Excel file do not “lineup” with the Excel cells (e.g., the downloaded data are wider than a typical Excel cell), go to a space halfway between two columns (e.g., half way between the letters “B” and “C”), wait to have a “plus sign” (or cross like figure) with left/right arrows appear, left click with the mouse and you should see dashed lines running down the columns which you can then manipulate.
highlight the columns that are too wide; (2) click on “Format”; (3) click
on “Column”; (4) click on “AutoFit Selection”
): follow the commands in “Data in Excel Do Not Match Columns in Excel” except; (1) go half way between columns “A” and “B” and drag the dashed line on the right side as far to the right as you can (i.e., put all the data as well as names that might appear on the left side of page in column “A” – it will be very wide – only the data will end up being transferred); (2) highlight the data you are interested in; (3) click on “Data” at the top of the screen; (4) click on “Text to Columns”; (5) click on “Next” (“Fixed Width” should be the default which will have a “dot” in it); (6) click on “Finish.” You may need to repeat this procedure because of how the data are blocked. For example, you may have data on all 50 states with left/right lines separating one group of years from another. In such a circumstance you need to go below each set of left/right lines (i.e., you don’t want to highlight the left/right lines or other such writing or figures, just the data you want to use) highlight the 50 state scores and then repeat the process for another year or set of years.
Note: If the above does not work on any part of your document try the
following: (1) repeat steps 1-5 (i.e., through “click on Next”); (2) In the “Data Preview” box click between the numbers on what appears to be a ruler at points that place vertical lines isolating the columns you want to use (i.e., say at 15, then 30, etc.) – go as far to the right as your data