Adding a new column to a defined range

%3CLINGO-SUB%20id%3D%22lingo-sub-1573889%22%20slang%3D%22en-US%22%3EAdding%20a%20new%20column%20to%20a%20defined%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573889%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I'm%20new%20to%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20sheet%20with%20defined%20names%20and%20now%20I%20want%20to%20add%20a%20new%20column%20but%20it%20says%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20value%20entered%20isn't%20valid.%3C%2FP%3E%3CP%3EData%20validation%20criteria%20have%20been%20defined%20for%20this%20cell%20to%20restrict%20the%20values%20that%20can%20be%20entered.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20do%20I%20create%20a%20new%20column%20and%20rename%20it%3F%20I'm%20using%20excel%20online.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573889%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1575196%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20a%20new%20column%20to%20a%20defined%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575196%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753050%22%20target%3D%22_blank%22%3E%40Arielperson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20right-most%20column%20in%20the%20table%20had%20data%20validation%20set%2C%20when%20you%20add%20a%20new%20column%20it%20will%20pick%20up%20the%20same%20rules.%20Just%20remove%20data-validation%20from%20those%20cells%20(or%20establish%20different%20rules).%20I've%20not%20worked%20with%20Excel%20online%2C%20but%20have%20experienced%20that%20with%20Excel%20desktop.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi! I'm new to Excel. 

I created a sheet with defined names and now I want to add a new column but it says 

The value entered isn't valid.

Data validation criteria have been defined for this cell to restrict the values that can be entered.

How do I create a new column and rename it? I'm using excel online. 

1 Reply
Highlighted

@Arielperson 

 

If the right-most column in the table had data validation set, when you add a new column it will pick up the same rules. Just remove data-validation from those cells (or establish different rules). I've not worked with Excel online, but have experienced that with Excel desktop.