When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary formulas and some VBA code that performs the same ...

Column functions and Columns functions are Lookup and Reference functions in Microsoft Excel. The Column function returns the column number of a reference, and its formula is Column([reference]).

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.