Clear column of data Online Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2300466%22%20slang%3D%22en-US%22%3EClear%20column%20of%20data%20Online%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300466%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20with%20a%20column%20of%20entered%20numbers.%20I%20need%20to%20clear%20all%20the%20values%20(25%20cells%20set%20to%20blank)%20before%20entering%20a%20new%20set%20of%20values%20in%20the%20column.%20This%20is%20easy%20with%20a%20macro%20in%20Desktop%20Excel.%20Is%20there%20any%20trick%20that%20will%20do%20this%20for%20the%20Online%20version%3F%20Is%20there%20an%20%22Add%20in%22%20that%20would%20do%20this%3F%20Is%20there%20an%20API%20way%20to%20do%20this%3F%20Thanks!%20Al%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2300466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2301569%22%20slang%3D%22en-US%22%3ERe%3A%20Clear%20column%20of%20data%20Online%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2301569%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1039055%22%20target%3D%22_blank%22%3E%40AlKovalick%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20Excel%20for%20Web%20that%20is%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fdev%2Fscripts%2Foverview%2Fexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOffice%20Scripts%20in%20Excel%20on%20the%20web%20-%20Office%20Scripts%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fintroduction-to-office-scripts-in-excel-9fbe283d-adb8-4f13-a75b-a81c6baf163a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EIntroduction%20to%20Office%20Scripts%20in%20Excel%20-%20Excel%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a table with a column of entered numbers. I need to clear all the values (25 cells set to blank) before entering a new set of values in the column. This is easy with a macro in Desktop Excel. Is there any trick that will do this for the Online version? Is there an "Add in" that would do this? Is there an API way to do this? Thanks! Al 

1 Reply