Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Header row in table is changing formatting

0

I've been using the shortcut to create a table (Control/t) to convert most all of my spreadsheets to tables to make them easier to view with the alternating shading pattern.  When I first started using this several months ago, the default table formatting would cause the header row to be in reverse text with a dark blue background (See Table Screenshot 1 attachment)  And, if I scrolled down the document, this formatting of the header row would remain the same throughout the entire document when scrolling from top to bottom.

However, recently when using this same method to create new tables, when first viewed from the top row, the header row formatting is just the same as shown in Table Screenshot 1.  But now, when you scroll down the document, the formatting of the header row changes to appear as show in Table Screenshot 2 (attached.)

So, is there a way to revert back to the previous behavior such that the formatting of the header row will remain the same from the top to the bottom of the document as you scroll.

Thanks in advance to anyone who can help.

Answer
Discuss

Discussion

Images aren't generally allowed on here. What version of Excel are you using?
don (rep: 1989) May 18, '17 at 12:57 pm
Excel 2016

When I submitted the question it asked to attach files which I did with the screenshots.  Is there another way to show screenshots with your question?
eoninc May 18, '17 at 1:09 pm
No. It literally says "You can upload Excel or CSV files."
don (rep: 1989) May 23, '17 at 8:36 am
Upload a sample file and tell us which version of Excel you are using.
don (rep: 1989) May 23, '17 at 8:37 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login