What are the limits if the row header and column header in Excel sheet?

 With Microsoft Excel 2016 the total rows an Excel worksheet can have is 1048576 rows. In terms of columns, you can have 16384 columns.

Well, that's a huge number of rows and columns to play with but, remember, if you fill each cell in these rows and columns the performance of the workbook will not be optimal. Yes Microsoft has provided avenue for entering data but to processing should also be supported by a good chip and board.

Probably, you can go for the cloud version of Microsoft Office (365) which should perform with a good internet connection.

In which tab hyperlink option is available in Microsoft Excel?

 Hyperlink in excel.

Text in a cell can be hyperlinked to either a webpage or to a place in the same document or email. Hyperlink option is found under the "Insert" tab in the ribbon at the top.

Once you select the desired cell and click on the hyperlink it would present with the following window.

Here you can customize the link based on your needs.