There are different print problems experienced when you use Microsoft Excel but we will present solutions to some of the problems as outlined below;
- Microsoft Excel prints only a portion of the worksheet
- I need to print one page wide or tall of my sheet
- The footer or header of the printed sheet does not look the way in wanted
- Why is Microsoft excel ignoring page breaks I have set
- Some columns and rows are printing on the wrong page
- Excel is not printing multiple print areas on same page
- I am not able to scale a chart to print to a desired size or I am not able to print multiple charts on one page
Microsoft Excel prints only a portion of the worksheet
If Excel is only printing a portion of your worksheet, you need to check whether a print area has already been defined. If there is a print area already set, then Microsoft Excel will only print the print area. To check whether a worksheet contains a printing area, you should go to “Page Break Preview” located on the “View” menu. The areas you see of the worksheet in a white background are the parts that will appear in a print. In order to print the whole sheet, you need to clear the print area by going to the “File” menu, then to “Print Area” then select “Clear Print Area”
You can also adjust the print area by changing its size to include or exclude rows and columns. You do this by going to “View” menu and then clicking “Page Break Preview”, where you then adjust the borders surrounding the print area by dragging them. If you want to include nonadjacent cells to the printable area, you need to select the cells then right click any cell within the selection, then click the “Add to Print Area” button found on the shortcut menu..
I need to print one page wide or tall of my sheet
If you want your excel sheet to print one page tall or wide, you need to prevent the columns or rows from spilling over the edges of the page. This is done by shrinking the excel sheet in order to appear in one page tall or wide. To do this, you go to “File” menu and click “Page Setup”, then click “Page” tab. When you are at the “Page” tab, you click “Fit to”, and type in “1″ in the pages wide box or tall box. This action deletes the number from the other box.
The footer or header of the printed sheet does not look the way in wanted
If the header or footer you have printed does not look the way you wanted, you can solve this problem by choosing from the various built in footers and headers to create your own. You can go to “View” menu and click “Header and Footer” where you choose black and white only. The footers and headers text will always be black meaning that it cannot be printed in color even when you are using a color printer.
In case you want to repeat linked information or graphics on top of every page, you can use print titles instead of using print headers. This feature can be used to print a company log or address at the top part of every page of the sheet. You place the company information on the first few rows within the worksheet. Then you go to “File” menu, and click “Page Setup”, then next click the “Sheet” tab, and on the “Rows to repeat at top” box, you enter the rows that contain the company log and the address.
Why is Microsoft excel ignoring page breaks I have set
If Microsoft excel ignores the page breaks you set, it means that your workbook has been set in such a way that Excel fits the printed work on a certain number of pages thus ignoring the manual page breaks you set. This reduces the size of the printed Excel worksheet. To check whether this is the case, you need to go to “File” menu, and click “Page Setup”, then the “Page” tab and under “Scaling”, check the “Fit to” option.
You use “Adjust to” instead of using “Fit to” in order to fit the worksheet. To go to “Adjust to”, you click “Page Setup” in the “File” menu and then click “Page” tab and you will see the “Adjust to” button.
If you find that the “Adjust to” option does not give you the results you want, you can set a print area by selecting each page as a separate range. Excel prints the worksheet nonadjacent ranges on separate pages.
Some columns and rows are printing on the wrong page
If some rows and columns are printing on the wrong page, you need to make some adjustments. The row height, column width, page margins as well as page breaks help determine the number of rows and columns that are printed on a page. You can make the margins smaller. If some columns and rows are printing on the next page, you may try decreasing the margins at the top, bottom, left and right.
To adjust the margins, you go to “File” menu, then click “Page Setup”, and go to “Margins” tab and click it. You can also adjust the page breaks by moving them before you print the worksheet. To do this, you go to “View” menu, and click “Page Break Preview” and the manual page breaks are displayed in thick blue lines. Usually automatic page breaks will appear as dashed lines. The page breaks can be moved through dragging them up, down, right or left.
Excel is not printing multiple print areas on same page
If multiple print areas are not being printed on the same page, you can specify that separate parts of the excel worksheet be printed on same page. The nonadjacent areas of an excel worksheet are printed in separate pages by default. To change this scenario, you need to bring together the columns intend to print.
In order to print the nonadjacent columns in the same page, you need to select the columns, which you do not want to print and hide them. Once you have selected them, you go to “Format” menu, then click “Column” and then click “Hide”. The same happens with the nonadjacent rows whether below or above the worksheet, which you do not want to print. You hide the rows by going to “Format” menu, then click “Row” and then click “Hide”. After that, you can now set the print area containing all the rows and columns including those, which are hidden.
I am not able to scale a chart to print to a desired size or I am not able to print multiple charts on one page
If you cannot scale the chart to print it in the size you want, you can set the print size. The chart on the chart sheet can be scaled when you want to print. To activate the chart sheet, you go to “File” menu, then “Page Setup” and next click the “Chart” tab. Under the “Printed chart size”, you click the scaling option you need to print. For “Custom”, it means that your chart will print in the size that you create when you drag the selection handles. If you have embedded charts, you need to drag to resize.
On the other hand, if you want to print various charts together on same page, you embed them. It is not possible to print multiple chart sheets within one page. If you want to print two or more charts on the same page, you should create embedded charts, which are then resized to fit into one page.