How to display long cell names with large amounts of data in a table

1. How do I select 50000 rows in Excel?
2. How do you show long text in Excel cell?

How do I select 50000 rows in Excel?

Hold down Shift , then press End and then → . Then (while still holding Shift ) press End again and then ↓ . This should select everything in a very small number of key strokes. However if there are gaps in your data you may have to press End then ↓ until you have everything.

How do you show long text in Excel cell?

In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, click Wrap Text. (On Excel for desktop, you can also select the cell, and then press Alt + H + W.)