Tips

To compare two cells in a single sheet =IF(Sheet1!A1=Sheet2!A1,"true","false") To compare two cells in multiple sheets =IF(A1=A2,"true","false") To Select a single row in excel Shortcut Key: Shift + End + <Down Arrow> To create a table in excel Select required cells and give Control + T To Split a line in excel into different cells …