ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column 1 Column 2 in Microsoft Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/208054-column-1-column-2-microsoft-excel-2007-a.html)

TB in DC

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?

Sheila D

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?


TB in DC

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