How do you show more rows and columns in an Excel worksheet?

Change the Zoom or view percent. A smaller zoom percent will let you see more on the screen, but everything will be smaller.