English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Ok my problem is that i have a bunch of worksheets that i need to type up. After i get them typed up, i need to be able to go in and put in the customers information on the lines. Such as Name, address.... Anyway, everytime i type up the sheet and go to put that info in, it moves my line. How do i type it up the first time, and then be able to go back in and type on top of the line. I am trying to do this so i dont have to use a typewriter anymore. I hope this makes sense. I have the original forms, but for each customer i have to type their into on the lines. But when i type their name in on the line, the line moves, so i can't type it on the line. Can someone tell me what i need to do so the line will stay there, and i can type their info on the line. Thanks

2007-10-18 03:01:06 · 4 answers · asked by tsumrall2004 1 in Computers & Internet Software

4 answers

you can do them in Excel

2007-10-18 03:04:31 · answer #1 · answered by cherokee.diamond 4 · 1 0

This is the type of work for which Excel was written.
Open an Excel file.
In the worksheet, each column has a column heading - A, B, C., etc.
Below that, in Line 1, you should type your own heading - like Firstname, Lastname, Address, City-State, Zip, Phone, etc.
Beginning at line 2, Enter your data appropriately.

If you have a large file, you will find it helpful to have the headings display as you scroll down. To do this:
click in cell A2.
click Window, click Freeze Pane
***
Then, click File
Page Setup
click the Sheet tab
where it says "row to repeat at top" type $1:$1 then click o.k.

Here is the how-to page from Microsoft.
http://office.microsoft.com/en-us/help/results.aspx?qu=Excel&sc=9

There are easy ways to drag out the width of the columns, the height of cells, type two or more lines in a cell or have the text wrap, etc. You should definitely get a book on Excel. I get used books from www.amazon.com. Cheap and in excellent condition.

2007-10-18 12:43:30 · answer #2 · answered by TheHumbleOne 7 · 0 0

You have probably created the lines by using the underscore character. What you should do is create the lines by turning on underlining, and creating the lines by typing blank spaces. You can then use the INSERT key to type on the lines, replacing the blank spaces with the information you need to enter.

If you are using a spreadsheet, a better alternative is to use borders to create the lines, then type in the cells.

2007-10-18 10:08:10 · answer #3 · answered by cmor5859 3 · 0 0

To do this u need word. U can just measure the position on the line then u can locate it on the sheet on the screen with that dimensions. It will target perfect the line.

Another way is that u have to work it out in any editor on the screen with just trying to locate the text that will fit the position. Once u have done it then with the next sheet u just change the data of name and so on. in the same positions.

2007-10-18 10:18:17 · answer #4 · answered by Lost In Space 5 · 0 0

fedest.com, questions and answers