close

Simple question - how do I reduce the number of lines in an Excel spreadsheet
from say 25000 to say 45? Delete doesn't work.

Hi Philamon

You can't delete rows in excel but you can Hide them
Check out this first before you do that
www.contextures.com/xlfaqApp.html#Unused--
Regards Ron de Bruin
www.rondebruin.nlquot;Philamonquot; gt; wrote in message ...
gt; Simple question - how do I reduce the number of lines in an Excel spreadsheet
gt; from say 25000 to say 45? Delete doesn't work.
You can hide the unwanted rows: highlight the row identifier for row
46, then hold down the SHIFT key and press END followed by DOWN-ARROW,
then release SHIFT. Click on Format | Row | Hide.

Hope this helps.

Pete

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

    software

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