![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 01:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com