Mam... I'm using 2019 version of excel. Ctrl+E(Flash fill) is not working in my excel. Like in your excel the date seems like (8/2/2021) but in my excel it shows like (08-02-2021). You said that it works in 2013 Or above that version alone. But why it's not working in my excel.. Can i know the reason mam?
@clicknlearn45173 жыл бұрын
Kindly select the column in which you are applying flash fill and change it to 'text format' then enter the first row value,for ex: in ur case, 08-03-2021, enter '08' and apply flash fill (ctrl+e). Thanx for your valuable comment..keep watching !!!