societysuper.blogg.se - Excel for mac page layout

EXCEL FOR MAC PAGE LAYOUT HOW TO
EXCEL FOR MAC PAGE LAYOUT MANUAL

To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet.

EXCEL FOR MAC PAGE LAYOUT HOW TO

This article from Microsoft goes into more detail.Do you want to know how to make a header in Excel? Or are you wondering how to add the footer page 1 to the current worksheet? This tutorial will teach you how to quickly insert one of the predefined headers and footers and how to create a custom one with your own text and graphics. My solution in this case is usually to manually delete empty rows and columns around my spreadsheet that are within the active range but contain no data. If this cell is way outside the range you are trying to print then you may want to reset this "last active cell". This will locate the last cell in the worksheet that Excel recognises as part of your working area. If it does, then you need to review your spreadsheet for data that should be excluded when printing.Īnother way you can test for the presence of extra or "empty cells that Excel thinks aren't empty" is to press CTRL+SHIFT+END. This should achieve what you're intending. When the Print options appear, make sure you're printing the selected cells only. The easiest way to test the second and third scenarios is to select just the cells you want to print. If you had formatted the cell and then only deleted the values in the cell, then Excel can be confused and think that the cell is still part of the range it should print. This can happen when you've entered data into a cell and then deleted it later. Sometimes cells look empty but aren't so they are included when printing your spreadsheet.These are included when Excel determines the range of cells that should be printed, causing your spreadsheet to appear very small. You have cells outside the range you want to print that contain data.This will cause the technique outlined here to fail.

EXCEL FOR MAC PAGE LAYOUT MANUAL

You have manual page breaks in your spreadsheet.There are a couple of possibilities that might be causing you to have problems:

Sounds like it's working as designed, except Excel is getting confused about what you want to print and including cells that you don't want to include in the printout. Set the Scale to Fit option for Height to be Automatic. Set the Scale to Fit option for Width to be 1 page. It could also be that you have horizontal page breaks that you want to keep when you print your spreadsheet. Suppose you want your Excel spreadsheet to print out one page wide, but you don't mind how many pages tall the print out is. Scaling an Excel spreadsheet to a specific number of pages Not only that, but Excel ignores any manual page breaks you've entered. The problem with this approach is that you can find your spreadsheet is scaled down too far and becomes too small to read. For example, you may choose to set your spreadsheet to be 1 page wide and 2 pages tall when printed.

Enter the number of pages wide and tall you want your spreadsheet to be when printed.

In earlier versions of Excel, and for Excel 20 for Mac, click File, then Page Setup. In Excel 2007, click the Page Layout tab, then click the small arrow in the bottom right corner of the Page Setup group (this also works for Excel 2010 as an alternative to the instructions above) If you're using Excel 2007 and earlier for PC, or Excel for Mac 2008 or 2011

Set the Scale to Fit options for Width and Height to the values you want.

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. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.