Can Excel show column headers on every screen? Yes, in Excel it’s called Freezing Panes, which can be applied to columns or rows (or both), and it’s super-simple.

You don't have to add a header to every Excel worksheet individually when you can group them first.

Merging the Values Right-click the column header immediately to the right of the second column and select "Insert" to add a new column, if necessary.