How many excel rows per page

Trackbacks are On. Pingbacks are On. Refbacks are On. The time now is AM. The comments are property of their posters. About Us "It's about Microsoft Excel". First recorded activity by ExcelBanter: Oct Posts: 1. JLGWhiz external usenet poster. First recorded activity by ExcelBanter: Jul Posts: 3, Ron de Bruin external usenet poster. First recorded activity by ExcelBanter: Jul Posts: 11, Posting Rules. By default, Excel does not show the worksheet gridlines when you preview or print a sheet, even if the gridlines are visible on the sheet.

If you want to print the gridlines, follow these steps, to change one of the Page Setup options:. Instead of printing sheets one at a time, watch this short video to see how to print all the sheets in an Excel file at once.

Be sure to watch to the very end , to see an important step! If you don't do that step, you could accidentally overwrite the worksheet data.

When you're working with a named Excel table , this video shows a quick way to print just the table, without all the other stuff that's on the worksheet.

There are written steps below the video. If you do this frequently, add the command to your Quick Access Toolbar. In the "All Commands" list, look for "Print List". When you open an Excel file, or switch to a different worksheet, you might see a large "Page 1" in the middle of the sheet. It looks like a watermark, but don't worry -- that text won't appear on your printed worksheet.

Watch this short video to see how to turn that page 1 watermark off and on. You will also see how Page Break Preview can be helpful. It lets you:. In Excel, you might open a workbook, or switch to a different worksheet, and see a large Page 1 in gray in the middle of your worksheet. Forums New posts Search forums. What's new New posts New Excel articles Latest activity. New posts.

Excel Articles Latest reviews Search Excel articles. Log in Register. Search titles only. Search Advanced search…. Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser.

It may not display this or other websites correctly. You should upgrade or use an alternative browser.