Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a excel spreadsheet with A-K columns. How do I force it to print A-K to fit the width of a page?

share|improve this question
    
For more on Excel printing :google.co.uk/… –  joe Sep 25 '09 at 14:30

2 Answers 2

up vote 1 down vote accepted

Found here

  1. Choose File -> Page Setup. You see the Page Setup dialog box.

  2. Select the Sheet tab.

  3. Select the Row and Column Headings check box.

  4. To repeat rows, click the Return to Worksheet button next to the Rows to Repeat at Top text box; to repeat columns, click the Return to Worksheet button next to the Columns to Repeat at Left text box. The dialog box shrinks so that you can get a better look at your worksheet.

  5. Select the row or column with the labels or names you need. You can select more than one row or column, as long as they’re next to each other.

  6. Click the Return to Dialog Box button to enlarge the dialog box and see it again. The text box now lists a cell range address.

  7. Repeat Steps 4 through 6 to select column names or row labels.

  8. Click OK to close the Page Setup dialog box. Click the Print Preview button to make sure that row labels and column names are indeed repeating from page to page. To remove row labels and column names, return to the Sheet tab of the Page Setup dialog box and delete the cell references in the Rows to Repeat at Top text box and the Columns to Repeat at Left text box. You can also press Ctrl+F3 and delete Print_Titles in the Define Name dialog box.

for Adjusting the margins

  • Choose File -> Page Setup and, on the Margins tab of the Page Setup dialog box, change the size of the margins.

  • Click the Print Preview button (or choose File -> Print Preview) to switch to the Print Preview window. From there, you can drag the margin lines to adjust the size of margins (margin lines are the outermost lines). If you don’t see the margin lines, click the Margins button.

share|improve this answer

If you go to File --> Page Setup and then click the Sheet tab you will see a box for Print Area. You can either click and drag to highlight what you would like printed or you can type in something like A:K. That will tell it what columns to specifically print.

To get it to fit the width of the page I would probably play around with the settings under File --> Page Setup under the Page tab. If you need to shrink it to fit you can use the Fit to [x] page wide by [y] pages tall. If you want to enlarge it you can use the Adjust to [%] of normal size (though you could also shrink it this way I find the previous method easier).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.