| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I've accidentally created a LIST range. How can I get rid of it??
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 |
|
#2
|
|||
|
|||
|
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 "Designs4Less" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
Thank you. That worked just fine!
"Trevor Shuttleworth" wrote: 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 "Designs4Less" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
You're welcome. Thanks for letting me know it fixed your problem.
"Designs4Less" wrote in message ... Thank you. That worked just fine! "Trevor Shuttleworth" wrote: 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 "Designs4Less" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add list to newly created menu | Excel Discussion (Misc queries) | |||
| add list to newly created menu | Excel Worksheet Functions | |||
| Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
| Database or list range is not valid | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Linear Mode
