hide column and rows

[m_john]

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

[Paul Sheppard]

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

[Peo Sjoblom]

Select A51:IV65536, do format>rows>hide, select G1:IV50,
do format>columns>hide


--

Regards,

Peo Sjoblom

"m_john" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>