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
- Sep 29 Fri 2006 20:09
How to make unused cells blank
close
全站熱搜
留言列表
發表留言