X hits on this document

Word document

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





42 / 44

allow; (3) click on “Next”; (4) click on “Finish” – If this doesn’t work then repeat initial steps 1-4 (i.e., through “Text to Columns”) and then change from “Fixed Width” to “Delimited” and follow as immediately above.  Also, you might need to copy (i.e., highlight) what you want to move, click on “copy,” then “paste special” and click on “values.”  I’ve been able to move stuff from a downloaded Excel file into another Excel file by this method.   

Copy and Paste Non-Consecutive Rows or Columns (e.g., transforming

data organized by year to data organized by state in which case you might want to copy and paste lines 2, 52, 102, etc.):  If you keep the “control” key down, you can highlight non-consecutive rows or columns.  Unfortunately, when you then try the copy or cut option, it won’t work.  So, you need an alternative strategy.  Try the following: (1) duplicate the entire file so you won’t harm the original; (2) take the unit you trying to “stack” by (e.g., state or year) and copy the names of the various units so they are on both the left and right side of the spreadsheet (i.e., it is much easier to know what unit you’re on if the information is on both sides of the spreadsheet); (3) highlight all the information between consecutive observations on the unit (e.g., if you have data for the 50 state by year – observation 1 is Alabama in year 1920 and observation 2 is Alaska in 1920 and want to covert this so that observation 2 is Alabama in 1921 then highlight all rows between Alabama in 1921 and Alabama in 1922) and then right click on “copy” and then paste (e.g., using “control v”) into the new document.

Removing a Symbol (e.g., “$”) from a Column of Data(1) highlight the row

or column the symbol you want to remove is in; (2) click on “Format”; (3) click on “Cells”; (4) highlight “number” (to covert to just numbers); (5) click on “Okay”

Reducing the Size of a Cell (e.g., the data take two rows for each cell and

one of the rows is blank): (1) select all the cells that have information; (2) go to

the “Edit” menu; (3) within this menu go to “Clear”; (4) from the list select “Formats” (the cells should now be broken into two – now we will delete the blank cells); (5) go to the “Edit” menu; (6) within this menu select “Go To”; (7) on the “Go To” menu click “Special”; (8) on the list select “Blanks”; (9) press “OK”; (10) go to the “Edit” menu; (11) within this menu select “Delete”; (12) in the delete box select “Shift cells up”; (13) press “OK”

Interpolation: Let us say that you are working with annual time series data and

have scores at decade wide intervals (e.g., census figures every 10 years).  If you want to average the change over the intervening years, precede as follows: (1) find the amount (or rate) of change over the time interval you are interested in (e.g., if there is a 2 point change over 10 years, this would be .2 of a point per year); (2) In the first cell in which

Document info
Document views443
Page views507
Page last viewedWed Jan 18 08:14:41 UTC 2017