Share via

How do I decrease the number of rows and columns in a worksheet?

Anonymous
2024-04-20T19:49:31+00:00

I worked with a worksheet that had the maximum numbers of rows and columns permitted by Excel. I need to limit them to what I already am using, keeping them to their max., renders the scrolling a nightmare.

Thanks,

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-04-20T21:04:39+00:00

    Select the entire row immediately below the last used row.

    Hold down Shift, press End, then Down-arrow.

    Right-click anywhere in the selection, and select Delete from the context menu.

    Select the entire column immediately to the right of the last used column.

    Hold down Shift, press End, then Right-arrow..

    Right-click anywhere in the selection, and select Delete from the context menu.

    Save the workbook.

    2 people found this answer helpful.
    0 comments