Share via

Endless rows at the bottom and unused columns to the right in my Excel spreadsheet ?

Anonymous
2020-01-24T15:59:46+00:00

How do I delete or hide the endless rows at the bottom of my Excel spreadsheet and the unused columns to the right? I like to work with only the active columns and rows in my spreadsheets. I do not want to see the rows and columns that go on infinitely. I want to work with a minimally focused spreadsheet. I have managed to do this before but now I cannot remember how or find the reference that taught me how to eliminate these distracting and unneeded columns and rows.

Microsoft 365 and Office | Excel | For home | 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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-01-24T16:10:11+00:00

    Hello Sarah5782

    I am V. Arya, Independent Advisor, to work with you on this issue. You can go to last used column. Select next column which is unused, CTRL+SHIFT+Right arrow, right click and hide

    Go to last used row, Select next row, CTRL+SHIFT+Down arrow, right click and hide

    (To find last used row and cell, you can press CTRL+END)

    300+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-02-01T20:42:08+00:00

    Thank you for your response. It took several tries, but it worked. I appreciate your most kind assistance.

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2020-03-15T09:38:14+00:00

    I have that same question that Im having difficulties as well. Ok so is there anyway to stop the endless columns and rows that i dont need with me using my Iphone 11? I just wondered if there was anything we can do about it, if not using a computer. 

    thanks

    -lisa

    5 people found this answer helpful.
    0 comments