G Guest Feb 12, 2006 #1 Simple question - how do I reduce the number of lines in an Excel spreadsheet from say 25000 to say 45? Delete doesn't work.
Simple question - how do I reduce the number of lines in an Excel spreadsheet from say 25000 to say 45? Delete doesn't work.
R Ron de Bruin Feb 12, 2006 #2 Hi Philamon You can't delete rows in excel but you can Hide them Check out this first before you do that http://www.contextures.com/xlfaqApp.html#Unused
Hi Philamon You can't delete rows in excel but you can Hide them Check out this first before you do that http://www.contextures.com/xlfaqApp.html#Unused
P Pete_UK Feb 12, 2006 #3 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
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
