Print area, rows to repeat at top, and columns to repeat at left grayed out. Set Print Area Greyed Out - Help !!! Large tables are much easier to read. trying to redefine the print area, but the "Print Area" option on the Pagelayout tab is grayed out. Look at the title bar of the workbook window - does it contain [Group]? They're disable if you try to get to them via print preview. Did you get to the Page Setup dialog from File > Print? Excel defaults to printing the entire worksheet. I've tried selecting the entire spreadsheet along with individual cells and can't get the area to become active. Increases your productivity by See screenshot: If you want to go back to normal view, just click Normal under View tab. Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by The print settings screen includes a quick-and-dirty print preview. As shown in the screen shot below, that setting, and a few others, are greyed out. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. If so, many options will be disabled. I think the margin was imposed by my printer (I had had a similar issue printing from LibreOffice) and the greyed-out 25mm margin setting made me think it was added by Reader. The problem is that I cannot get it to print properly without that page setup command because the printing options in that area seem to override the printing … All other functionality in the Page Setup is unaffected. I am using Excel in Office 365. Excel Set Print Title Greyed Out If you click Page Setup on the screen, Excel again displays the Page Setup dialog box and all the tools are available within it; none are disabled. OR From the File menu, select the Page Setup option. This can happen say if you accidentally group the worksheets. I have set an area to print which covers a few pages and I want them printed with the same row as a title. After free installing Kutools for Excel, please do as below: Select a range you want to display only, and click Kutools > Show & Hide > Set Scroll Area. Can anyone confirm to me: Those margin settings in Print, Page Setup don't do anything and shouldn't be shown at all! Enable the sheet in which you want to display working area only, and click View > … This occurs, when you just press Ctrl + p and go through the print preview. To specify a print area: Choose View Page Break Preview from the menu bar. Once all of the changes are completed, your Page Setup will look similar to ... > Page Setup margins greyed out > print Production > set Page window. Note: The other languages of the website are Google-translated. Open and create multiple documents in new tabs of the same window, rather than in new windows. If you frequently print a specific section of your worksheet, you can set a print area for it. Some page setup options aren't available in this situation. It's however necessary to determine in advance the printing area that you need. Once you have received the verification code, you will be able to choose a new password for your account. 80%, Convert Between Cells Content and Comments, Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier. Set One or More Excel Print Areas Open a worksheet and select the cells that you want to be part of the print area. While you are working at a worksheet, you may want to only display the working area in the worksheet, which means to grey out all unused area in some times as below screenshot shown. Please help. Print Titles is not available/greyed out. You can enlarge the print area by adding adjacent cells. Grey out unused area by Page Break Preview In the Page Break Preview view, the unused area will be greyed out. Select the range of cells that you need to print. Back to. Right-click the active sheet tab and select 'Ungroup sheets' from the context menu to undo this. Greetings, I have a word document in which the File > Page Setup command is greyed out. However, entering Print Preview - Page Setup - Sheet shows the section "Print Titles" greyed and I cannot select any row (nor columns). Regards, Hans Vogelaar (http://www.eileenslounge.com). A verification code will be sent to you. With the Page Break Preview, it will show all used cells, but if you want to only display some cells in a specific range, you can use Kutools for Excel’ Set Scroll Area utility. This happens if you open the Page Setup window from the Print Preview window. If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart. Also the Edit > Select All is greyed out as well. Excel Manual Print Area Greyed Out 2007 Setup Sheet. To ungroup the worksheets, simply click on one of the sheets. I'm going to seek further info from HP. From the File menu, select the Printing area and Define options. I try to print a table with A1 to C4 , or even chose one cell, from an Excel Worksheet. Make a range of cells with the area that you need to print. Instead, you have to go through the “Page Layout” ribbon and set the print range there. Each print area gets a... Go to the Page Layout tab. Why might they be greyed out and what do i have to change in order to be able to modify them please? Another possibility is that you activated “Freeze Panes”. Print column headers at the top of every page (1) On the 'Page Layout' tab go to 'Page Setup' group and click 'Print Titles' Note: If the 'Print Titles' button is locked (greyed out), it may be because you are currently editing a cell / chart or if you do not have a printer set up in Windows. I go to print and go to Page Setup". Please enter the email address for your account. In the Page Break Preview view, the unused area will be greyed out. If so, you have selected multiple sheets. Enable the sheet in which you want to display working area only, and click View > Page Break Preview. When I go to the sheet options in Page Setup, the Print Area, Rows to repeat at top and Columns to repeat at left are all grayed out. If you want to display all, click Kutools > Show & Hide > Unhide All Ranges.