Latest version of excel how to freeze column header

itвЂ™s only available as long as NO FREEZE is active. Horizontal splitting can also be done by dragging the splitter above the vertical scroll bar. It can be done by selecting the first cell below/right of the rows/columns to fix and then mark the submenu item вЂWindowвЂ™ > вЂFreezeвЂ™ checked.Д®xample1: You want to only freeze the rows 1 through 3: Select A4, > вЂWindowвЂ™ > вЂFreezeвЂ™Д®xample2: You want to only freeze the first coluimn: Select B1, > вЂWindowвЂ™ > вЂFreezeвЂ™Д®xample3: You want to freeze the first column AND the topmost 5 rows: Select B6, > вЂWindowвЂ™ > вЂFreezeвЂ™ If you want them shown also while doing something much more to the right (higher column numbers) in the sheet you will have to fix the complete columns.ДЇixing rows and or columns is only possible for the topmost/leftmost rows/columns. This makes sense only if the вЂњheadingвЂќ stays in place above the headed columns.

See also this thread in the other forum and the there linked in sources. Please note the comment by Starting with version 5.1 a new campaign of reworking the menu structure with respect to clarity and usablility has reached the surface.

Latest version of excel how to freeze column header