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 based on delimiter

Select required cells and go to Data -> Text to Columns (give delimiter and finish)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s