| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column 1 Column 2 in Microsoft Excel 2007
I am creating a table where I should have heading that say across the tops
the different months. ie: Jan Feb Mar. When I clear the contents of Feb and Mar, it shows up with the words "Column 1, Column 2". Is there some way to get rid of those words and just have clear cells in Excel 2007? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column 1 Column 2 in Microsoft Excel 2007
You can convert it from a table to a normal range then delete the headings.
In Table Tools, Design ribbon choose COnvert to Range option. Hope this helps Sheila "TB in DC" wrote: I am creating a table where I should have heading that say across the tops the different months. ie: Jan Feb Mar. When I clear the contents of Feb and Mar, it shows up with the words "Column 1, Column 2". Is there some way to get rid of those words and just have clear cells in Excel 2007? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column 1 Column 2 in Microsoft Excel 2007
You are a GENIUS Sheila.
Thank you, This totally resolves the issue. "Sheila D" wrote: You can convert it from a table to a normal range then delete the headings. In Table Tools, Design ribbon choose COnvert to Range option. Hope this helps Sheila "TB in DC" wrote: I am creating a table where I should have heading that say across the tops the different months. ie: Jan Feb Mar. When I clear the contents of Feb and Mar, it shows up with the words "Column 1, Column 2". Is there some way to get rid of those words and just have clear cells in Excel 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - mixed type (line, column, stacked column) in one char | Charts and Charting in Excel | |||
| Column Chart - Adding text in the column in Excel 2007 | Charts and Charting in Excel | |||
| How do I set up the column input value in Microsoft 2007 | Setting up and Configuration of Excel | |||
| Microsoft Excel-locking a column | Excel Worksheet Functions | |||
| Microsoft Excel-locking a column | Excel Worksheet Functions | |||
Hybrid Mode
