Why is rows to repeat greyed out

Excel all the menu options are greyed out AccountingWEB. Right click the file you want to open, and from this menu click "properties". At the bottom is a small section called "Attributes". If ticked, Untick the "Read-only" box.

Website: Accountingweb. Category : Use all in a sentence. Excel , Explorer. Flintstone July 31, , am 2. Website: Ask. Excel Print Area Greyed Out. By deault the option for settiing print area, rows to repeat and columns to repeat are greyed out if you display the Page Setup. Website: Easy-online-courses. How can I get it to work since I have multiple sheets that I need to carry over the titles when I print out the sheets?

The titles I need are not in the first column or row. I see how it is done if it was available. GA -- My address is spoofed, so do not reply directly. Category : Use question in a sentence.

Under the [Sheet] tab, in the "Rows to repeat at top" field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK]. Website: Cedarville. Every , Enter.

The first benefit of using Page Layout is that it divides your workshee. How to fix common printing problems in Microsoft Excel. Website: Techrepublic. Excel Orientation Greyed Out. Excel Details: Excel Details: Excel Details: Excel page layout functions greyed out Margins, orientation, size For some reason all options to change the layout of my sheet in Excel are. Related related Backup your files, always take backups. Website: Dmcritchie. Website: Exceljunction. Every , Editing. Excel Repeat Rows Greyed Out.

Details: 1 Open a beer. Manage Custom Sizes is greyed out Apple Community. Website: Discussions. Grey out unused area by Page Break Preview. In the Page Break Preview view, the unused area will be greyed out. See screenshot: If you want to go back to normal view, just click Normal under View tab.

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. NoteIn Excel , click the dialog box launcher in the Page Setup group in the See More Excel Page Setup greyed out MrExcel Message Board 8 hours ago Excel - If more than one cell is selected on a worksheet other than the one you are trying to set the print area on, the Print Area icon will be greyed out.

Quora 2 hours ago Answer 1 of 4 : It might be hidden too. A document which was previously on 2 pages and set to landscape is now set across 12 pages excel page setup greyed out Website: How-use-excel.

I have tried selecting one cell and hitting esc a few times and I … Website: How-use-excel. Fix: Excel Sheet is grayed problem in Windows 10 2 hours ago 1. Estimated Reading Time: 3 mins. You cannot use page setup properties in Excel if no 4 hours ago Use the Printers option in Control Panel to install a printer. If you go to the same window via the Page Layout ribbon like in the screenshots, it … Website: Professor-excel.

Excel print area greyed out in page setup 3 hours ago Set One or More Excel Print Areas Open a worksheet and select the cells that you want to be part of the print area. By deault the option for settiing Website: Imageslink. Set page setup attributes for more than one sheet Office 4 hours ago To set page setup attributes for a group of Excel worksheets, use one of the following methods. New posts. Excel Articles Latest reviews Search Excel articles.

Log in Register. Search titles only. Search Advanced search…. Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.

You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Thread starter strorg Start date Feb 4, Joined Mar 27, Messages The "Rows to repeat at top" and "columns to repeat at left" options are disabled on Sheet tab of Page Setup dialog. So, the problem is that the fields for setting the rows and columns to repeat are greyed-out. To be honest that is quite confusing and there seems no obvious reason for me to do it like this.

But anyway, now you know how to solve this problem! As it seems, far more people than expected still print out Excel sheets. At the same time, printing Excel sheets seems to be as troublesome as it always was. Just click here to see the guide. You learn about all the frequently asked questions about printing in Excel.