Select the cells you want to magnify. Select View on the Ribbon and select Zoom to Selection.
This will zoom in on the specific section you want to analyze in your Excel worksheet.
To return to the normal view click on 100%.
Now you’re back to the view you started with.