How I can Set the Print Area in Microsoft Office Excel

73. How to Set the Print Area in Microsoft Office Excel
74. How to Create a Linear Series of Values in Excel
75. How to Change Gridline Colors

73. Setting the Print Area in Microsoft Office Excel
Have you ever wanted to print only certain rows or columns from a spreadsheet? Here’s how:
1. With a spreadsheet open, select all the rows or columns that you want to print.
2. On the Page Layout tab, in the Page Setup section, click Print Area, and then click Set Print Area.
3. Click the Print icon on the toolbar, or click the Office button, point to Print, and click Print. Only the required content gets printed.

74. Create a Linear Series of Values in Excel
Here’s how to use Auto Fill to create a series of values:
1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.
2. Select cells A1 and A2.
3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.

75. Changing Gridline Colors
You can change the look of your worksheet.
1. With a Microsoft Office Excel worksheet open, click the Office button, click Excel Options, and then click Advanced.
2. Under Display options for this worksheet, select the gridline color of your choice.
3. Click OK.