How do I fix print area in Excel?

Set one or more print areas

1. On the worksheet, select the cells that you want to define as the print area. Tip: To set multiple print areas, hold down the Ctrl key and click the areas you want to print.
2. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

.

Furthermore, why won't excel Let Me Set Print Area?

If your Excel spreadsheet isn't printing properly, clearing or setting a print area can often help. To do this from the Page Layout Ribbon, click the Print Area icon and select Clear Print Area. If you now want to redefine the print area, select the cells that you want to print.

Additionally, how do I get rid of the GREY area in Excel? Under the View tab of the Ribbon, "Page Layout" (second button from the left). Looks like the cells have been hidden, to do this select the column from where you want the grey to start, then hit control, shift and the right arrow, then right click and hit 'hide' Ta da!!

Beside above, why does only part of my Excel spreadsheet print?

The reason that only part of your spreadsheet is printing in Excel 2013 is due to something called a Print Area. This is a setting for a spreadsheet where you can choose to only print part of the data that is included in the sheet.

How do I print a large Excel spreadsheet on one page?

Follow these steps:

1. Click the Page Layout tab on the ribbon.
2. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic.
3. To print your worksheet, press CTRL+P to open the Print dialog box, and then click OK.

Related Question Answers

How do I change print settings in Excel?

Shrink a worksheet to fit on one page

1. Click Page Layout.
2. Select the Page tab in the Page Setup dialog box.
3. Select Fit to under Scaling.
4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes.
5. Press OK at the bottom of the Page Setup dialog box.

How do I change the print settings in Excel?

1. In the worksheet, click File > Print.
2. Under Settings, click Custom Scaling > Custom Scaling Options.
3. Click Page and in the Adjust to box, pick a percentage by which you want to increase or decrease the font size.
4. Review your changes in Print Preview and if you want a different font size, repeat the steps.

Why can't I print from Excel?

Selecting a new print area can often resolve Excel printing issues. First, reset the print area by selecting the Page Layout tab and clicking the Print Area. Then select the Clear Print Area option. Thereafter, select a new print area.

How do you autofit in Excel?

Select any cell in the column/row you want to autofit:

1. To autofit multiple non-adjacent columns/rows, select one column or row and hold down the Ctrl key while selecting the other columns or rows.
2. To autofit the entire sheet, press Ctrl + A or click the Select All button.

Why are my margins different when I print Excel?

From the File menu, select Print. Under "Settings", select the Normal Margins drop-down menu. Choose a different pre-set option, or select Custom Margins, adjust the values for each margin that you want to change, and click OK.

How do you clear formatting in Excel?

To remove cell formatting in Excel, select the cells from which you want to remove all of the formatting. Then click the “Home” tab in the Ribbon. Then click the “Clear” button in the “Editing” button group. Finally, select the “Clear Formats” command from the drop-down menu that appears.

How do I move the print lines in Excel?

Move a page break

1. To verify that drag-and-drop is enabled, do the following: Click the File tab > Options.
2. Click the worksheet that you want to modify.
3. On the View tab, in the Workbook Views group, click Page Break Preview.
4. To move a page break, drag the page break to a new location.

How do I print an Excel spreadsheet?

Print all or part of a worksheet

1. Click the worksheet, and then select the range of data that you want to print.
2. Click File, and then click Print.
3. Under Settings, click the arrow next to Print Active Sheets and select the appropriate option.
4. Click Print.

Why is Excel cutting off text when I print?

Go to Tools > Options > General. Change the default font size to the font size that you want (the font size at which you can view the text). Excel will then alert you to close out of Excel and re-open Excel in order to accept the new font size. Exit out of Excel entirely and then re-launch it.

How do I get my Excel spreadsheet to fill the whole page?

Microsoft Excel - Scale a worksheet to fit a printed page

1. Click the Page Layout tab on the ribbon.
2. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic.
3. To print your worksheet, press CTRL + P (CMD + P on a Mac) to open the Print dialog box, and then click OK.

Why can't I change the fill color in Excel?

Set a default fill color for all cells in a worksheet In Excel, you cannot change the default fill color for a worksheet. Click the Select All button, to select the whole worksheet. On the Home tab, in the Font group, click the arrow next to Fill Color. , and then select the color that you want.

How do you make a cell Uneditable in Excel?

To make a column non-editable:

1. Select the whole worksheet, Right Click->Format Cells->Protection, uncheck the "Locked" check box.
2. Select the column you want to protect, right Click->Format Cells->Protection, select the "Locked" check box.

How do I remove infinite columns in Excel 2016?

How do I delete infinite blank rows?

1. Highlight the first blank row below your data (i.e. the first row you want to delete)
2. Hit ctrl + shift + down arrow to highlight all of the rows below.
3. Right click the row labels (where each row's number is shown) on the left side and select "delete" in order to delete all of these rows.

Can you redact in Excel?

Redacting a Single File With the copy open in Word or Excel, select the text to be redacted and then click “Redact Selection” on the Redact tab. If you make a mistake in Word, you can use the Undo command to reverse the redaction. In Excel, you cannot undo a redaction, so be careful.

How do I remove a color filter in Excel?

Go to the Data ribbon and click the Clear icon in the Sort & Filter group. Go to the Home ribbon, click the arrow below the Sort & Filter icon in the Editing group and choose Clear.

How do I make an Excel spreadsheet Fit to Page?

Shrink a worksheet to fit on one page

1. Click Page Layout.
2. Select the Page tab in the Page Setup dialog box.
3. Select Fit to under Scaling.
4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes.
5. Press OK at the bottom of the Page Setup dialog box.

Why is my Excel spreadsheet so small when I print it?

In the worksheet, click File > Print. Under Settings, click Custom Scaling > Custom Scaling Options. Click Page and in the Adjust to box, pick a percentage by which you want to increase or decrease the font size. Review your changes in Print Preview and if you want a different font size, repeat the steps.

How do I print a PDF to scale?

Acrobat can size the pages of a PDF to fit the selected paper size.

1. Choose File > Print.
2. From the Page Scaling pop-up menu, select one of the following options: Fit To Printable Area Scales small pages up and large pages down to fit the paper.
3. Click OK or Print.

How do you determine what is causing large Excel file size?

Excel has a “used range” for every sheet in your workbook. The larger this is, the bigger the file size becomes. For new & blank Excel files, the used range is only cell A1. But as you work on a file, it will increase to represent the rightmost column and furthest row that you've edited or formatted.