MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Michelle on December 28, 2001 10:26 PM

Dear Mr. Excel,
I have created a data base for work divided by rows. I want to be able to delete the lines that divide the rows in areas throughout my chart without moving the rows up or down. I would like to use these larger areas to write freely in and if I just fill in the lines with "no color" my text is still governed by the lines. How do I get rid of the rows I chose all together within my chart?



Posted by Jacob on December 29, 2001 4:59 AM

You want to keep the rows but delete everything in em, right?

Try this

select the rows

then put this line in your code


is this what you needed?