+ Reply to Thread
Results 1 to 4 of 4

Missing columns A & B (Already tried unhiding and column width)

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    Seattle, WA
    MS-Off Ver
    2013
    Posts
    1

    Question Missing columns A & B (Already tried unhiding and column width)

    Hi All,

    I'm really in a pickle. Something happened to my spreadsheet today that removed A & B columns. After searching online for a solution, I tried the following:

    1. f5 > "a1" > OK > Format > Column Width (100 and Autofit) - NADA
    2. Highlight column C and to the left > Right click at column C > Unhide - NADA
    3. Hover mouse to the left of column C and look for the 2 arrows symbol - NADA

    I'm not sure what else to try and this report is due soon. Any ideas?

    Thanks much,
    Lauren

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Missing columns A & B (Already tried unhiding and column width)

    Maybe the scroll area is set: Close and reopen.

    Or post the workbook.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    Hobart, TAS
    MS-Off Ver
    Office 2003, XL2007
    Posts
    46

    Re: Missing columns A & B (Already tried unhiding and column width)

    Select the whole sheet by clicking on the cell to the left of the column designators, and above the row designators.
    Right click on column designators, select column width and enter an arbitrary value then Enter. All the columns will expand to this width so you will have to be reset to your usual values.
    HTH

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Missing columns A & B (Already tried unhiding and column width)

    Do you have titles set/frozen?
    Click View tab//window/unfreeze

    Or
    click the triangle above row 1 and to the left of column A (select all), then try the right-click-on-A/ unhide again
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Splitting Columns and Column Width
    By joebell in forum Excel General
    Replies: 1
    Last Post: 06-29-2013, 09:10 AM
  2. Column Formatting-width of columns split
    By reecetn in forum Excel General
    Replies: 2
    Last Post: 08-03-2010, 10:39 AM
  3. Unhiding columns (column A that you can't click on!)
    By HighlandScott in forum Excel General
    Replies: 3
    Last Post: 01-29-2009, 08:45 AM
  4. [SOLVED] Set Column Width Based On Total Width Of Other Columns
    By rayneraingoaway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2006, 06:10 PM
  5. Setting column width for blank columns
    By gmr7 in forum Excel General
    Replies: 0
    Last Post: 01-17-2006, 11:20 AM

Tags for this Thread

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