Delete Rows in an existing array in Excel


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"?
 
Ad

Advertisements

M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top