+ Reply to Thread
Results 1 to 6 of 6

Reversing Column Removal at End of Sheet

  1. #1
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    244

    Reversing Column Removal at End of Sheet

    I'm sure this is a no-brainer for someone, but I just can't figure it out.

    Some time ago, I thought I was clever and removed the excess columns at the end of this sheet (I think by adjusting the last cell of the worksheet). Now, I can't figure out how to reverse it.

    Could someone take pity on this poor fool? LOL
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Reversing Column Removal at End of Sheet

    You have hidden those excess columns, e.g. in the Summary sheet it only shows up to column S. If you want to change this, then you can click on the column identifier for S and slide the cursor to the right. Then right-click and click on Unhide.

    Hope this helps.

    Pete

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

    Re: Reversing Column Removal at End of Sheet

    The columns are merely hidden

    To unhide
    Ctrl+G -- Type in XFD1 -- Shift+Left arrow -- Right click -- Unhide

    reversing-column-removal-at-end-of-sheet-corea-coop-daily-invoices_2020.xlsm
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    244

    Re: Reversing Column Removal at End of Sheet

    Thank you so much to you both. As it turns out, I was on the right track, but the trick is to right click exactly at the edge of the column where the cursor changes. I was right clicking in the column itself and nothing was happening.

    Thank you again!

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Reversing Column Removal at End of Sheet

    Glad you sorted it out in the end, and thanks for the rep.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Pete

  6. #6
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    244

    Re: Reversing Column Removal at End of Sheet

    Oh yes, thanks for reminding me Pete.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Reversing the order of Auto Updated Rows into a new Sheet
    By hammer2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-24-2013, 11:11 AM
  2. Replies: 2
    Last Post: 03-17-2010, 04:01 AM
  3. [SOLVED] Stacked Column Graph with automatic zero column removal
    By Niper in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-06-2010, 12:22 PM
  4. reversing a column of names
    By conductorbob in forum Excel General
    Replies: 2
    Last Post: 11-15-2006, 07:34 AM
  5. Sheet removal...help please
    By Terry in forum Excel General
    Replies: 2
    Last Post: 07-19-2005, 07:05 PM
  6. [SOLVED] removal of zero in column chart
    By Caroltchr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-18-2005, 10:06 PM
  7. [SOLVED] reversing the sheet
    By Moreken in forum Excel General
    Replies: 1
    Last Post: 03-28-2005, 11:06 PM

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