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.

How to return a set number of consecutive numbers in Excel By combining ROW () and ROUND () with a couple of input values, you can create a very flexible consecutive numbering function.