I've accidentally created a LIST range. How can I get rid of it??

G

Guest

I was in Excel and highlighted a range that I wanted to print as a selection.
Somehow I clicked the wrong thing and now it thinks it's a LIST (has the dark
blue border around it with column lables at the top). I don't want it to be
there. I just want my plain old spreadsheet back.

Anyone know how to get rid of this??

Delaine
 
T

Trevor Shuttleworth

Delaine

right click on the list and, from the menu, select List | Convert to range
and confirm that you want to convert the list to a range.

Regards

Trevor
 
G

Guest

Thank you. That worked just fine!

Trevor Shuttleworth said:
Delaine

right click on the list and, from the menu, select List | Convert to range
and confirm that you want to convert the list to a range.

Regards

Trevor
Click to expand...
 

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

Similar Threads

Data Validation: How do I hide border of ACTIVE lists? 2
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Windows 10 How to get rid of lines on documents 2
How do I get rid of duplicate rows? 5
How do I get rid of a series of hyperlinks in a column or row 4
How do I get rid of Hourglass 5
get rid of drop down boxes in excel 2007 6
How can I get rid of a watermark on an Excel spreadsheet? 3

Top