close

I have used 6 columns and 4 rows of a excel worksheet and i would like the
rest of the sheet look blank without even the cells visible.how to do it

Highlight column G by clicking the identifier. Hold down lt;shiftgt; and
press lt;endgt; once followed by lt;right-arrowgt;, the release lt;shiftgt;. Then
select Format | Column | Hide.

Do a similar thing to the rows by selecting row 5 first and using
down-arrow.

Hope this helps.

PeteFormatgt;Columnsgt;Hide
Same for Rows

--
Kind regards,

Niek Otten

quot;Sandhyaquot; gt; wrote in message
...
gt;I have used 6 columns and 4 rows of a excel worksheet and i would like the
gt; rest of the sheet look blank without even the cells visible.how to do it
you can hide them. Highlight column G and hit ctrl shift right. Right click
the selected area and select hide. Highlight row 5 and hit ctrl shift down.
Right click the selected area and select hide.

quot;Sandhyaquot; wrote:

gt; I have used 6 columns and 4 rows of a excel worksheet and i would like the
gt; rest of the sheet look blank without even the cells visible.how to do it

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()