Why is my Page Setup greyed out in Excel?

Why is my Page Setup greyed out in Excel?

The first thing to check is if you have printer drivers installed in Windows and, if you are using a networked printer, that the printer is online. It could be that if you don’t have a printer available to Excel that the program is disabling those options because setting them would have no meaning.

How do I enable Page Setup in Excel?

To apply page setup attributes to a group of worksheets in a workbook, follow these steps:

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.
3. Make the changes that you want in the Page Setup dialog box, and then click OK.

Why can’t I change the Page Setup in Excel?

In Excel, page setup properties are only available when you print or preview one or more sheets in a workbook. Because of this, you cannot change or return most page setup properties unless at least one printer driver is installed as the default printer.

Can’t access Page Setup Excel?

If you have not installed Classic Menu for Office

1. Click the Page Layout tab in the Ribbon.
2. Go to the Page Setup group, and then you will find that some common used setups, such as margins, backgrounds and size are listed in this group.
3. Then a “Page Setup” box appears, and you can choose the settings based on your need.

Why does my Excel not have a page layout?

If it’s checked and can’t see the Page Layout tab, please follow the below steps: Open the Excel application> File> Options> Customize Ribbon> Under Choose commands from, selects All Tabs> Select Page Layout> Click Add> OK.

Why is my page layout not working in Excel?

Close all office applications and change your default printer through Start > Devices and Printers to another printer. It may be some physical one or One Note or XPS or PDF or anything else. If this is the problem, then you will need to update your printer driver for default printer.

Why does my excel not have a Page Layout?

How do I unlock the Page Layout in Excel?

You can do it by following these steps:

1. Click the File tab and then click Options.
2. At the left side of the dialog box click Customize Ribbon.
3. In the right column of the dialog box, click the small plus sign at the left of the View tab entry.
4. Click once on the Workbook Views option.
5. Click the Remove button.
6. Click OK.

How do you unlock the greyed out menu in Excel 2016?

Make sure you are not in Edit mode by hitting Esc (Escape key), as edit mode >will gray out a lot of menu options — notably most Edit options (except cut >& paste). Will grayout Options under Toolbar; many options under Data and >under Window.

How do I change the default page setup in Excel?

How to Make Page Layout the Default View in Excel 2010

1. Open Excel.
2. Click File.
3. Choose Options.
4. Select the General tab.
5. Click Default view for new sheets, then choose Page Layout.
6. Click OK.

Why does my Excel not have a Page Layout?

How do I get the Page Layout tab in Excel?

To access Page Layout view, locate and select the Page Layout view command in the bottom-right corner of your workbook.