SOLVED

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
New Contributor

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 

2 Replies
best response confirmed by AlKovalick (New Contributor)
Solution

@Sergei Baklan 

Thanks so much for your advice! Spot on. I thought since desktop Excel uses macros to record screen actions, scripts would not work for the Web version. You proved me wrong, thankfully.  Al