MrExcel Publishing
Your One Stop for Excel Tips & Solutions

To hide part of Row/Column Header

Posted by Somkiat on September 24, 2001 12:08 AM

I have seen a file that show only column header from A-G and row header from 1-10 while the rest are invisible.

How to hide some part of row/column header.


Posted by Rob Jackson on September 24, 2001 12:18 AM

All you need to do is highlight the columns you don't want to see and go Format/Column/hide or Format/Row/Hide as appropriate.