+ Reply to Thread
Results 1 to 9 of 9

Extra Extra! I need to remove extra columns and rows in my spreadsheet.

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    Hi. Help. Please.

    I have somehow ended up with extra columns and rows in my spreadsheet that go on into infinity and make it unprintable. They . How can I do a "delete all columns to the right of... and deleted all rows below..."?

    Thanks.

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    Adjust your print settings.

    Go to view--print preview, see the print area and adjust accordingly by dragging the lines
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    08-01-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    are you saying go to the view tab because if so, there isn't a print preview there. when I go to print preview, don't have the drag option. what a I missing?

  4. #4
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    Oops..I meant page break preview!

  5. #5
    Registered User
    Join Date
    08-01-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    That is fine for printing, but I want to delete all of this extra space. Any ideas?

  6. #6
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    I have somehow ended up with extra columns and rows in my spreadsheet that go on into infinity and make it unprintable
    this led me to think, it was a printing problem.

    but I want to delete all of this extra space. Any ideas
    Select the blank rows/columns right click and delete.

    Does this work?

  7. #7
    Registered User
    Join Date
    08-01-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    apologies for the confusion. I guess that's what I am asking. How do you select infinity?

    added: i have been scrolling, highlighting, deleting and it doesn't help.

  8. #8
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    Once you have selected your first non-functional (blank) row of the rows you want to delete press Ctrl+Shift+Down arrow keys to select till the last row (infinity!) -- then delete

    Similarly, for columns on selecting your first non-functional (blank) column press Ctrl+Shift+Right arrow keys to select till last column (infinity!) -- then delete

    If this does not work, upload a sample workbook

  9. #9
    Registered User
    Join Date
    08-01-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Extra Extra! I need to remove extra columns and rows in my spreadsheet.

    That's it! I knew it was something painfully obvious. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1