#Heading rows repeat excel for mac manual#
But then, if you move the text of the table around or resize it, you risk your manual header row not being the top row of your page. Here’s the magical thing: you can of course do this manually by inserting a row at the top of each page of your table. Note: if you don’t have a row selected, the Repeat Header Row button will be greyed out and you can’t press it. Like magic, if you scroll down the page, you will now see that your header row is repeated! Find the Repeat Header Rows button:Ĭlick on the Repeat Header Rows button. Now, because you’ve got a table in your document, Word will have added the Table menu tabs to your ribbon. Select the header row of your table so that you can tell Word that this is the header row by left-clicking with your cursor to the left-hand side of that row: Word defaults to Print Layout view, but check, just in case: Please NOTE that we’re in Print Layout view on the View menu at the moment: when we repeat the headers, the repeat is only visible in Print Layout or Print Preview, both of which show you what your document will look like when it’s printed. OK, it’s fairly self-explanatory, but I might forget what the Acquired and Read headers are.Īt the moment, when the table goes onto the next page of the document, the table just carries on, with no header rows on the second and third pages: Now, this is a long list, and it goes over more than one page. We’re going to use the example of a list of books I have read. But if you think that the person who will consult the table will need to keep reminding themselves about what the different columns contain, it’s useful to add the header row at the top of each page.ĭoing this automatically rather than manually inserting a new row into each page of the table ensures that however much the table changes, the header row will stay at the top of each page. If you’re presenting a table which contains fairly self-explanatory information, for example, name, surname, book title, year, then you probably don’t need to repeat the heading row, even if the table runs across more than one page.
#Heading rows repeat excel for mac how to#
This article shows you how to do that in Word 2007 and Word 2010 (we use the same procedure for both) Why would I want to repeat my header row on multiple pages? Make sure you remove the corrupted table after you have copied the data to the new table.If you have got a table that extends over several pages in a Word document, it’s useful to be able to repeat the header row at the top of each page automatically, so that it stays there no matter what you change in the table itself. Set the Repeat Headings option and this should solve the problem. In this case, as frustrating as it might sound, it’s actually easier to start again! Simply create a new table and copy and paste the data into the new table. The fix? Simply join the tables together and the Repeat Header Rows feature should work a treat.Īnother reason might be that formatting corruption occurred during the many copying and pasting events. If the tables present as one table but are actually separate tables then Word won’t repeat the headers because each separate table is expected to have its own header. Sometimes in the hands of inexperienced users who have copied and pasted content from many different locations, you can end up with a number of separate tables which – to the naked eye – appear as one table. Here are some of the things we suggest looking for: The remaining 1% will require a little more investigation.
*The hack above fixes 99% of the issues with Table Header Rows that refuse to repeat… but what about the other 1%? For the remaining 1% Provided that you have the option for Repeat Header Rows enabled, you should see the headers repeating at the top of each subsequent page. Click OKto save the setting and close the dialog box.The Table Properties dialog box will be displayed.The Text wrapping option, “Around” prevents the heading from repeating.The Table Properties dialog box will be displayed.Select the Properties icon within the Table Group.Click anywhere in the table to display the Table sub-tabs.Repeating Table Headingsĩ9% of the time * the following steps will fix this issue: In our opinion, one of the most annoying things about table formatting is when you have one that carries over across several pages, but despite applying all the right settings, the heading REFUSESto repeat at the top of each following page:Īrrghhh!! But before you throw your laptop out the window or threaten the document with death and destruction (guilty), take a look at this quick, little hack for fixing those table headings. If you’ve ever had to work with a document containing tables, you’ll know how frustrating it can be when they just won’t do what you want them to do.
0 kommentar(er)
