VBA Code to remove duplicate rows . 4 different methods are explained in this article including Formula. Step1 Open an excel sheet. Step2 press alt F11