Posted by **M.A.** on Friday, June 12, 2009 at 9:56pm.

I went to File/Print Area and selected Clear Print Area. Then I went to File/Print Preview and the far left column of itemized numbers 1-619 do not show up.

How can I get the far left column of itemized numbers to be printed in my document?

- Excel spreadsheet -
**Writeacher**, Friday, June 12, 2009 at 10:08pm
OK, you're referring to the column of numbers down the left side that are automatically in every Excel spreadsheet -- the numbers of the rows. Those never print.

You'll need to add a row to the very left side:

1. Put your cursor in any cell in column A.

2. Go to Insert and click on Columns. A blank column should show up now as A and what was column A should now be B, etc.

3. In the new cell at the top left (A1), type the number 1 and press Enter.

4. In cell A2, type this formula --> =a1+1 and then press Enter. A 2 should appear in that cell.

4. Put your cursor back into A2 (where the new "2" is) and then hold the cursor over the darkened bottom right corner of the cell. The cursor should become a plus sign (+).

5. While the cursor is + hold down the left mouse key and drag it down until you reach row number 619.

6. When you let up on the mouse button, all the numbers in that column should be the numbers you want.

7. Now go to Print Preview to make sure it looks the way you want.

- Excel spreadsheet -
**M.A.**, Friday, June 12, 2009 at 10:24pm
How Cool!! It works! You are a lifesaver.

Thanks. M.A.

- Excel spreadsheet -
**Writeacher**, Friday, June 12, 2009 at 10:39pm
You're very welcome!

=)

## Answer This Question

## Related Questions

- Excel spreadsheet - I have filled in an Excel spreadsheet. On the far left ...
- Programming - 2. Then it should prompt the user for the input file name of the ...
- Math - A framer at a photo gallery wants to frame a print with a matte of ...
- Data Analysis Help - 4. Cells must be __________ and the sheet protected to ...
- math - niran has 72 centimeters of molding to make a frame for a print. this is ...
- computer programing - I am little lost how to do this here any help to show me? ...
- computer - A-Asking the user to pick a number between 1 and 20 and having the ...
- computer programming (PYTHON) - My first page is <html> <head> <...
- computer programming (PYTHON) - My first page is <html> <head> <...
- C Programming - I need help creating a program that uses a menu with options to ...

More Related Questions