X hits on this document

Word document

click on “Load Preferences”; (4) click on “Factory Settings.” If the ... - page 41 / 44





41 / 44

under “edit,” click on “Delete.”

Downloading a Non-Excel Data File into Excel: (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.  

Data in Excel Do Not Match Columns in Excel: 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.  

Reducing the Width of Columns (e.g., the columns are too wide)


highlight the columns that are too wide; (2) click on “Format”; (3) click

on “Column”; (4) click on “AutoFit Selection”

Data in Excel Can Not be Manipulated (e.g., can not transfer rows and

columns or perform other functions): 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

Document info
Document views457
Page views521
Page last viewedSat Jan 21 16:13:29 UTC 2017