Here are some Excel tricks for easier work.
1: Selecting a row
press ‘SHIFT’ + ‘SPACE’. A row will be selected.
2: Selecting a column
press ‘CTRL’+ ‘SPACE’. A column will be selected.
3: Removing hyperlinks
select the cell + Right Click -> select Remove Hyperlink.
4: Wrapping the text with in the cell
select the cells +Right click + Format Cells +Under Alignment tab +Check Wrap text +Click ‘OK’.
the text will be adjusted with in the cell. If the text is too long then the hieght of the cell will be increased to wrap the content.
5:Shrinking the text with in the cell
In case if you don’t want the height of the cell to incease and fit the text with in the cell then follow these steps:
Select the cell + Right click + Format cells + Under Alignment tab+Check Shrink to fit+ Click ‘OK’
6:Add text in the cell in the next line
Enter the text in the cell then press ‘Alt’+'Enter’. The cursor will move to the next line.