Post a New Question

Excel spreadsheet

posted by .

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 -

    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 -

    How Cool!! It works! You are a lifesaver.
    Thanks. M.A.

  • Excel spreadsheet -

    You're very welcome!

    =)

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. computer programming (PYTHON)

    My first page is <html> <head> <title>Name Game</title> </head> <body> <h1>Name Game</h1> <form action="namegame.py"> <p> Enter your name: <input type="text" name="name" …
  2. computer programming (PYTHON)

    My first page is <html> <head> <title>Name Game</title> </head> <body> <h1>Name Game</h1> <form action="namegame.py"> <p> Enter your name: <input type="text" name="name" …
  3. Math

    A framer at a photo gallery wants to frame a print with a matte of uniform width all around the print. To make it pleasing to the eye, the area of the matte should equal the area of the print. If the print measures 40 cm by 60 cm, …
  4. Excel spreadsheet

    I have filled in an Excel spreadsheet. On the far left column are itemized numbers from 1-619. When I print the document, the far left column of itemized numbers does not print. How do I tell the computer to print the far left column …
  5. Data Analysis Help

    4. Cells must be __________ and the sheet protected to prevent edits being made to the data. locked secured formatted values 5. To print column and row headings on all pages, set the options in the __________ command in the Page Setup …
  6. math

    niran has 72 centimeters of molding to make a frame for a print. this is not enough molding to frame the entire print.How shouldhe cut the molding to give the largest possible area for the print using the inside edge of the molding …
  7. computer

    A-Asking the user to pick a number between 1 and 20 and having the computer pick a number between 1 and 20 and telling the user if they won or lost B- For finding the logic error in the program C- For finding and fixing the logic error …
  8. Programming

    2. Then it should prompt the user for the input file name of the file containing the data to sort. 3. If the program can't open the file or if no file name is entered (^d or ^z is entered for EOF), it should print an error message …
  9. C Programming

    I need help creating a program that uses a menu with options to enter student information (name, ID, GPA), print student information, or quit the program. Use data files and FILE pointers to store and print information entered.
  10. computer programing

    I am little lost how to do this here any help to show me?

More Similar Questions

Post a New Question