: (1) highlight the
Data (probably, column) you want to change (if you want to change all the columns just keep highlighting as you move from left to right); (2) Click on “Edit” (upper left side of screen); (3) Click on “Find”; (4) In the “Find What” box tell it what number you want to change [if you want to convert a blank space into a “dot” (i.e., “.”) then leave the “Find What” box blank – i.e., don’t type the word “blank” in the box]; (5) Click on “Replace” (right side of gray box); (6) Put the number you want to change it to in the “replace with” box (if a dot –“.” – then put a “.” in the box); (7) Click on “Replace All.” If You need to move the gray box so it does not cover the column you are working with click in the blue area of the find/replace box and “drag” it to uncover what you need to uncover; (8) make sure to click to remove the black screen (if not, I don’t think the change occurs)
: Click on the blank gray box which is to the left
of column A and above row 1.
: Click on the row number just below
where you want the new row inserted. You will see an entire row turn black. Then go to the top and pull down the menu that says “insert.” You will then have an option for “rows, columns or cells” listed below one another. Highlight “rows” and click. A new row should be created. If you want to add another row directly below the newly created row simply hit “control Y.”
: See discussion in Stata
under “Transpose Rows and Columns.” In Excel: (1) highlight the row you
want to transpose; (2) under “edit,” click on “copy”; (3) open the document you want the new data in (it may be preferable to put it in a separate spreadsheet and work from there); (4) under “edit,” click on “paste special”; (5) check “transpose”; (6) click on “OK.” Given that Excel limits you to 256 variables, you might need to convert an Excel file in Stata. Save the Excel file as .csv and, using the “insheet” command in Stata, read the file into Stata. Then use the “xpose” command to transpose your data (see Stata manual on using the “xpose” command).NOTE: In “Vista” version of Excel you: (1) open document you want to transfer the transposed data to; (2) highlight want you want to transpose; (3) right click on the mouse; (4) click on “copy”; (5) right click again on mouse and click on “paste special”; (6) check “transpose” You might also try Stata.
In Stata type: xpose, clear (You’ll lose the variable names however)
: (1) highlight the row or column you wish to delete; (2)