Under Print , select Gridlines. Click OK. Printing Row and Column Headings When both planning and troubleshooting a worksheet, you may find it helpful to print the column A,B,C Under Print , select Row and column headings. Repeating Items on Each Page When you are working with large worksheets, repeating information like row or column descriptions on subsequent pages can help improve the readability of your reports.
Under Print titles , in the Rows to repeat at top text box, type an absolute row reference for the row you want to repeat. Under Print titles , in the Rows to repeat at top text box, type the absolute row references for the rows you want to repeat. Changing the Print Quality You can change the quality of your printout to print at a higher resolution. Select the Page tab. In Microsoft Excel , grid lines are automatically displayed in worksheets; however, grid lines do not print automatically on a worksheet.
If you want to print the grid lines on a worksheet, you have to change the Page Layout settings. In addition, people often confuse the cell borders in a worksheet with the grid lines in Excel. Grid lines are not the same as borders and cannot be customized in the same way that you would customize a border.
Open the worksheet or worksheets in Excel that you wish to print. Read More ». Follow Us. Weekly Tutorial. Backlink Analytics — Free Until Get Started. Let's have a chat. Fill out the form below to consult with us. Full Name. Company Email. Company Website.
0コメント