[Fixed!] Excel Rows to Repeat at Top Feature Greyed Out

While printing in Excel, we often use the Rows to Repeat at Top feature of Excel to print the headers on every page. but In some cases, you may get that the feature is greyed out means it’s not working. If you don’t know the reasons then you may get tensed but the good news is, it happens because of some silly mistakes. Today I’ll show those reasons and solutions in this article with easy steps and clear illustrations. I hope, after finishing this article you will get rid of all the issues regarding the problem.


Download Practice Workbook

You can download the free Excel workbook from here and practice on your own.


3 Fixes If Rows to Repeat at Top Feature Is Greyed Out in Excel

First of all, get introduced to our dataset that we’ll use to explore the reasons and solutions. It represents some salespersons sales in different regions.


Fix 1: Apply Page Setup from Page Layout Ribbon

The most common reason is- if we try to use the Rows to Repeat at Top feature from the print preview window that we open by clicking on the Print option of the File tab then it won’t work. Because by default Excel doesn’t allow to use of the command from print preview. Have a look at the image below, I opened the Page Setup dialog box from the print preview window that’s why the Rows to Repeat at Top feature grayed out. There’s no way to use this command form here. So, we’ll have to follow the alternate option must.

Apply Page Setup from Page Layout Ribbon to Activate Excel Rows to Repeat at Top Feature

Solution:

The solution is quite simple, just open the Page Setup dialog box from the Page Layout ribbon and then use the Rows to Repeat at Top feature and it will work.

  • First, click as follows: Page Layout > Print Titles.

Apply Page Setup from Page Layout Ribbon to Activate Excel Rows to Repeat at Top Feature

  • Now see, the feature is working and I selected the title row.

Read More: How to Repeat Rows in Excel When Printing (3 Effective Ways)


Fix 2: Unselect Multiple Sheets Before Page Setup

Let’s see another common issue if we select multiple sheets before opening the Page Setup dialog box then the Rows to Repeat at Top feature won’t work whether you use it from the Page Layout ribbon or the Print Preview window. Take a look, I clicked on the Rows to Repeat at Top feature but it won’t work although I opened it from the Page Layout ribbon.

Unselect Multiple Sheets Before Page Setup to Activate Excel Rows to Repeat at Top Feature

  • Because here I selected two sheets before using the feature.

Unselect Multiple Sheets Before Page Setup to Activate Excel Rows to Repeat at Top Feature

Solution:

  • Select only one sheet and then apply the Rows to Repeat at Top feature and it will work perfectly.

Now you see, it is working properly.

Read More: How to Select Column A as Titles to Repeat on Each Page


Similar Readings


Fix 3: Escape from Editing a Cell Before Page Setup

There’s another silly issue, but for that many problems occur in Excel. When we are editing a cell and gonna apply other commands keeping the cell editing then many commands don’t work. For the same reason, you won’t be able to use the Rows to Repeat at Top feature because it’s not possible to open the Page Setup dialog box then, all the options of the Page Layout ribbon will be grayed out. Have a look, I clicked on the Page Layout ribbon but no option is available.

Escape from Editing a Cell Before Page Setup to Activate Excel Rows to Repeat at Top Feature

Because I was editing Cell D5 and keeping it in editing mode, I clicked on the Page Layout ribbon. That’s why no option is working.

Escape from Editing a Cell Before Page Setup to Activate Excel Rows to Repeat at Top Feature

Solution:

  • Press the ESC key from your keyboard to escape from the editing mode of a cell.

Soon after you will see that every option of the Page Layout ribbon is available.

And so then you will be able to apply the Rows to Repeat at Top feature.

Read More: How to Repeat Rows at Top of Specific Pages in Excel


Conclusion

That’s all for the article. I hope the procedures described above will be good enough to solve the problem if Excel rows to repeat at the top feature grayed out. Feel free to ask any question in the comment section and please give me feedback. Visit ExcelDemy to explore more.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

2 Comments
  1. I am still greyed out and none of these apply. Any other suggestions?

    • Hello KATHY,
      Thanks for your feedback. Would you please check whether your worksheet is protected or not? If not then your problem is quite specific. So if you would share your file with us then hope, we could find out the reason and provide a solution.

Leave a reply

ExcelDemy
Logo