View Single Post
  #1   Report Post  
Paul Sheppard
 
Posts: n/a
Default hide column and rows


m_john Wrote:
In my spreadsheet, I just want to show some rows and some columns and
hide the rest. For example, I want to show column A- F and row 1-50
and hide the rest .How should I do it ?


--
m_johnPosted from - http://www.officehelp.in


Hi m_john

Select columns G-IV, then Format Columns Hide, select rows 51 -
65536, then Format Rows Hide


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=482231