editing a table range in name manager

[Lizzi]

Hi,

i'm using excel 2010 and have a table within a work book that i would like to edit, ive been in to the name manager and selected edit to make the table one column shorter but the field is greyed out so i cant do it.

The workbook/sheet is not protected so i'm confused as to why i cant do this, can anyone shed some light plse?

many thanx

 

[apo]

Hi..

You can try this..

1. Click anywhere in the Table.. then.. in the top left part of the Menu Ribbon.. you will see "Resize Table".. click that and resize your table..

or...

2. Just right click on one of the actual columns (the actual column letter at the top).. and select Delete.. that will remove that column..

 

[Lizzi]

Thanku for helping, the thing is the table starts at col A and ends at column EE, i want the table to end at ED but i still need the data thats in EE to use on a pivot table. so if i make the table smaller by one column, i cant use that info in the last column. This is all very confusing but to cut a long story short, i have sales guys spreadsheets that i use a macro to roll up to a team level and then another macro to roll up the team level in to one final sheet. the data in col EE is only put in the final sheet and not individual ones so when i run the macro, it clears the data. I informed by someone else to make the table smaller but i can now see that wont work......

Hi..

You can try this..

1. Click anywhere in the Table.. then.. in the top left part of the Menu Ribbon.. you will see "Resize Table".. click that and resize your table..

or...

2. Just right click on one of the actual columns (the actual column letter at the top).. and select Delete.. that will remove that column..