Delete Rows in an existing array in Excel

  • Thread starter Thread starter wlfoote
  • Start date Start date
W

wlfoote

I have a spreadsheet with a series of formulas in various columns. I now want
to delete some of the rows. How do I overcome the error message "you cannot
change part of an array"?
 
Select any cell within the array,
then press CTRL + "/"
(to select the entire array)
Now you can press Delete key to clear the entire array at one go ..

voila? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Back
Top