hide column and rows
 

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

hide column and rows
 

Select A51:IV65536, do formatrowshide, select G1:IV50,
do formatcolumnshide


--

Regards,

Peo Sjoblom

"m_john" wrote in message
...

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

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