By default, gridlines don't appear on a printed Microsoft Excel worksheet or workbook. This article describes how you can make the gridlines appear in your printed worksheets. Select the worksheet or worksheets that you want to print.
Kathy developed a protected worksheet that allows users to input data into certain cells. The data in some of the input cells shows fine in the worksheet; the contents appear on a single line. When viewing the worksheet in Print Preview or printing the worksheet, however, the text that doesn't wrap on the screen wraps in the printout.
Joinsubscribers and get a daily digest of news, geek trivia, and our feature articles. Gridlines and the row and column headings can be helpful when viewing data on worksheets printed in Excel. Open the workbook and select the worksheet for which you want to print the gridlines. The state of the option on or off for each worksheet is saved with the workbook.
It happened again. You go to print your latest Microsoft Excel spreadsheet, and half your data is cut off because the ugly, large white borders of the document are too large. You want to fit as much data onto each spreadsheet page as possible, which is why you need to change the page margins in Excel to be as small as possible.
I received an Excel spreadsheet via email from a colleague, and I added two rows of data at the bottom of the page. I went to print the spreadsheet, but the whole page would not print out. Everything would print, except the two rows that I added.
Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page. You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. The problem with that is that you can find your page fits onto one page, but becomes too small to read.
If you have created a small worksheet in Excel, you may want to center it on the page when you print it. By default, it will print in the upper, left corner of the page. For a very small set of data, this can detract from the effectiveness of your presentation. There is an easy way to center the data on the printed page.
If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page. Follow these steps:. In the Scale to Fit group, in the Width box, select 1 pageand in the Height box, select Automatic.