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?
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.
How Cool!! It works! You are a lifesaver.
Thanks. M.A.
You're very welcome!
=)
To troubleshoot the issue and make sure that the far left column of itemized numbers is printed in your document, you can try the following steps:
1. Check Print Area: Go to the "Page Layout" tab and click on the "Print Area" button. Make sure that the entire range of the column containing the itemized numbers (in this case, column A) is selected as the print area. If not, select the entire column by clicking on the column letter header (A) and holding down the "Shift" key while pressing the down arrow key until all the desired rows are selected. Then, click on the "Set Print Area" option to define the selected range as the print area.
2. Adjust Page Margins: Another possible reason why the far left column is not visible in the print preview could be because of narrow page margins. To adjust the page margins, go to the "Page Layout" tab and click on the "Margins" button. Choose a wider margin option or manually adjust the margins by selecting the "Custom Margins" option.
3. Check Scaling Options: It's possible that the scaling options are set incorrectly, causing the column to be scaled out of view. To check and modify the scaling options, go to the "Page Layout" tab, click on the lower-right corner of the "Page Setup" group to open the "Page Setup" dialog box. In the dialog box, navigate to the "Scaling" tab. Ensure that the "Fit to" option is set to "1 page wide by 1 page tall" or adjust it according to your preference.
4. Enable Gridlines: If the itemized numbers represent cells with formulas or data, ensure that the gridlines are visible in the print preview. Go to the "Page Layout" tab, click on the "Sheet Options" group, and check the "Print" option under "Gridlines" to display the gridlines in the print preview.
By following these steps, you should be able to resolve the issue and ensure that the far left column of itemized numbers is printed in your document.