How do I enable paper size in Excel?

How do I enable paper size in Excel?

To switch the default paper size, go to Page Layout > Page Setup > Size, and then choose the size you want.

How do I unlock Page Setup in Excel?

Unprotect an Excel worksheet

1. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
2. If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box, and click OK.

How do I fix greyed out in Excel?

How to fix: Excel Data not showing – not visible – data area is grayed out.

1. Go to View Menu and ensure first that the Unhide option is inactive.
2. Select Arrange All.
3. At the menu that comes up, check the “Windows of active workbook” checkbox and click OK.
4. One last action.

How do I fix the page size in Excel?

Changing page orientation and paper size

1. Select the correct worksheet.
2. Choose File Page Setup from the menu bar.
3. Click the Page tab.
4. Choose an orientation—portrait or landscape—for the worksheet.
5. Select a paper size from the list of available paper size options that appear in the list box.
6. Click the paper size.

How do I get more paper size in Excel?

How to Adjust Page Size and Scale in Excel

1. Click the Page Layout tab.
2. Click the Size button.
3. Select a page size. If you don’t see the paper size you need, select More Paper Sizes.

How do I get rid of GREY area in Excel?

Remove cell shading

1. Select the cells that contain a fill color or fill pattern. For more information on selecting cells in a worksheet, see Select cells, ranges, rows, or columns on a worksheet.
2. On the Home tab, in the Font group, click the arrow next to Fill Color, and then click No Fill.

How do I fix Page Setup in Excel?

More information

1. Press CTRL and then click each worksheet tab in the workbook that you want to affect.
2. On the File menu, click Page Setup. In Excel 2007, click the dialog box launcher in the Page Setup group in the Page Layout tab.
3. Make the changes that you want in the Page Setup dialog box, and then click OK.

How do I make an Excel sheet GREY and white?

Click the “Format” button. Click the “Fill” tab and select the gray color you prefer from the Background Color swatch. Click “OK” to confirm your selection.

How do I change the default paper size in Excel 2016?

How do I create a custom paper size?

In the Print window, click Preferences, Properties, or Printer Properties. Click the Paper/Quality tab, and then click Custom. Click New, type a name for the custom paper size, select the width and height, and then click OK to save the paper.

How do I make an Excel sheet gray?

How do I lock cells greyed out in Excel?

Press Ctrl + 1 to open the Format Cells dialog (or right-click any of the selected cells and choose Format Cells from the context menu). In the Format Cells dialog, switch to the Protection tab, uncheck the Locked option, and click OK.

Why is my Excel spreadsheet grayed out?

In large spreadsheets or complicated spreadsheets, Excel will take some time to refresh all of the formulas on a sheet. During that time, it will gray out things to prevent you from making changes while it is unable to process or keep track of those changes. It is not available to you. Why?

How do I print on A4 paper size?

Go to Print page and look for page set up under settings,a pop up appears Mine is ok so this is what it says,orientation potrait and paper size A4 click on options bottom right,paper option size is A4 and scourse should be automatic not saying it will work but thats the correct default

How do I get rid of greyed out menus in Excel?

When the actions that you are attempting to perform in a worksheet apply to a protected cell or sheet, you will see grayed-out menus. You must unprotect the workbook, worksheet or cell to unlock the unavailable menus. Click the “Home” menu, then choose “Format” in the “Cells” tab. Thanks. How do I grey out cells in Excel?

How to grey out cells based on another column values in Excel?

Select the cells in column A you want to grey out, click Home > Conditional Formatting > New Rule. 3. Click OK > OK to close the dialogs. And the cells have been greyed out based on another column values.