+ Reply to Thread
Results 1 to 18 of 18

Missing all info above the grid box

  1. #1
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Missing all info above the grid box

    Somehow when I open EXCEL i ONLY see the grid box. Only displays the grid chart which includes all the cells - NOTHING above the column headings (A,B,C,D etc.t. no place to see the text I've written, etc. etc. etc. Please help. Thanks.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Missing all info above the grid box

    Does this solve it?

    https://www.extendoffice.com/documen...-headings.html
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    I'm sorry..........I didn't make myself clear. I can see what is called the "ribbon bar", but can't see anything ABOVE IT, i.e. can see the column headings "A B C D etc.", but nothing above it.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Missing all info above the grid box

    Can't see anything above the ribbon bar?
    The only things above the ribbon bar are the menus and the icon shortcuts

    If the formula toolbar is missing try this

    Go to View menu, under Formulas tick the Formula Bar box.

    If this doesnt fix it can you post a screenshot?

  5. #5
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    As I said, I see NOTHING ABOVE the column ribbon showing column A, B, C etc.
    Here are 2 screenshots. NOTE: I can't see any sign on this Reply window to show that I have actually attached the 2 jpeg screenshots. The attachment process I used was: Opened Manage Attachment > Upload Files from computer > found the 2 files on my computer using Browse > clicked the higher "UPLOAD" button on right of window > observed the 2 uploaded files in the middle of screen > closed the window via the "Close this window" in upper right of screen > saw "do you want to close this TAB" message > clicked "YES" > thereby, returned to message window (but didn't see any sign that there was any attachments > clicked "submit reply" .....hope attachments are there.......

    Thanks
    Attached Images Attached Images

  6. #6
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Missing all info above the grid box

    There is a paperclip icon to attach files but it doesnt work on this forum.
    Your "Manage Attachments" was the correct way to add files.

    Does it only happen on this workbook, ie if you start Excel on its own does the ribbon appear?
    These windows, are they within the main Excel window? They're not windows of their own are they?
    What happens if you open the same spreadsheet on a different PC?

    Could you post the spreadsheet?

  7. #7
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    Q-1: it happens in every workbook - file

    Q2: When I open Excel, I seen the "normal" opening page as shown on the attached screenshot. When I open ANY FILE I ONLY SEE a "grid", the top of which is
    the "column headings" ribbon showing column headings A B C D E etc.,.............and the right side of which is the "row headings" ribbon showing
    from top down, 1 2 3 4 etc. exactly what is shown on my two previous screenshots.

    Q3: the IS NO "MAIN EXCEL WINDOW" - only the "grid" I've described.

    Q 4: If I understand you right, YES, they are "on their own. NOTE: when I have an open excel window (grid only), when I click on the "+" at the bottom to the right of "Sof the
    screen, it moves to "SHEET 1" - it moves to "SHEET 2", etc. and each of those sheets are identical to the previous one (except of course, they have no writing/numbers like
    SHEET 1 has.

    NEW QUESTION: All of my files are either in the 2004 version or the 2016 version. You can see that on the Opening Page screenshots where some file icons
    have a "dark background white X" = 2016 version, and "white background dark X" = 2004 version.

    Is there a way to somehow "convert" every old version file to a new version file ??????????

    Thanks for any help.
    Attached Images Attached Images

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Missing all info above the grid box

    Hi dmkinter. Welcome to the forum.

    I managed to duplicate the screenshots by
    1. VIEW > unchecking 'Formula bar'
    2. While holding down Ctrl + Shift hit the F1 function key.
    When I reversed that everything came back.

    Does that help?
    Dave

  9. #9
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    Just noticed you 2-8-17 reply. It doesn't help now because I can't see "VIEW" or any of the normal excel screen about the 'A - B - C etc. ribbon.

    QUESTION: Since no one seems to have an answer for this problem, can't I just somehow reinstall Excel to fix this problem???? I bought OFFICE
    - home and student edition within the last 6 months. I have the "purchase card" with the 25 letter/number code............ OK?

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,457

    Re: Missing all info above the grid box

    You could reinstall or, perhaps less drastic a solution, run a repair.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,457

    Re: Missing all info above the grid box

    Could it be that the Excel Window is too big for the screen? Maybe this generic article might help: https://askleo.com/i_cant_see_the_to...at_can_i_do-2/

  12. #12
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    1. Clearly it's not a "can't view the whole screen" problem. When I've opened Excel clicking on the Excel icon on the ?? Taskbar (I think it's called),it
    opens to the green Excel homepage very nicely. However, no matter what excel saved file I click on, the correct file opens BUT it ONLY shows the "grid" (a b,
    c etc.ribbon at the top, and 1 2-3 etc. ribbon along the left side of the grid.
    2. I followed your instuctions and firstly did a "Quick Repair" = no help - no change; and then did a "complete repair" (not sure of name, repair using the I/N.
    It finished and then it said something like "click here to "activate'? all apps" but I couldn't find where to click.
    Now my Excel and Word icons are gone from the Taskbar and I can't locate those icons using Windows Explorer... Should I do another Complete Repair and try it
    again? or are the Excel and Word icons somewhere on my computer and I can use them to open them?

    Sorry to be such a pain.........I appreciate any help anyone can give.

  13. #13
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Missing all info above the grid box

    Quote Originally Posted by dmkinter View Post
    Just noticed you 2-8-17 reply. It doesn't help now because I can't see "VIEW" or any of the normal excel screen about the 'A - B - C etc. ribbon. .....
    Have you tried reversing the order of what I described in post #8? ie Ctrl + Shift + F1 function key? Does the ribbon appear when you do that first?

  14. #14
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    As I've said, I have absolutely nothing above the column heading ribbon (i.e. A - B - C - D ETC), so I can't click on VIEW bec I can't see it. When I use CNTR+SHFT >>>F1 by itself on any
    of my available excel screens, nothing changes.

  15. #15
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    1. Another thought: About 1/2 of my excel files are v. 2000 and 1/2 are v. 2016. Is there a way I can "update/ or whatever" all of my v. 2000 files into
    v. 2016? That would be nice. Just perhaps that impacts my current "missing info" problem..........

    2. I've tried several times to repair using the I/N full repair version, but to no avail. I'd like to "update" (see above) my v. 2000 files before trying
    to completely reinstall Excel. Any suggestions?

  16. #16
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Missing all info above the grid box

    1. How did you make your screen shots in post #5: a) Alt+prt Scr? or b) Ctrl+Prt SCr?
    2. Where is your WINDOWS TASKBAR? Top or Bottom of the screen?
    3. With Excel and one other program open, right click the Taskbar and choose Cascade windows.
    4. Post a screen shot of your desktop using Ctrl+Prt Scr.
    Ben Van Johnson

  17. #17
    Registered User
    Join Date
    02-01-2018
    Location
    Pinckney, Michigan
    MS-Off Ver
    2016
    Posts
    11

    Re: Missing all info above the grid box

    HALLELUJAH!!!!!!!!!!!! IT'S FIXED!!!!! Apparently my 3 attempts to "Repair by Internet" actually worked!!! Thanks all for your wise advice.

    QUESTION: About 1/2 of my excel files are from v. 2000 and 1/2 from v. 2016. Is there some way to "upgrade, or whatever" the v. 2000 files so they ALL are v. 2016 files?

    Should I start a new thread for this Q ? Again, I appreciate all your efforts to help me.

  18. #18
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,457

    Re: Missing all info above the grid box

    You should start a new thread, however I'm not sure it's possible without opening them and then converting them from within.

+ 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. Cannot get missing grid lines back
    By dcwm in forum Excel General
    Replies: 9
    Last Post: 09-22-2016, 06:41 PM
  2. [SOLVED] Excel 2008 : Grid lines missing in spreadsheet
    By alsevcik in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 13
    Last Post: 12-31-2013, 10:32 AM
  3. Missing info
    By madtaz in forum Excel General
    Replies: 1
    Last Post: 01-04-2007, 08:41 PM
  4. [SOLVED] Missing the grid window on a worksheet
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 06-07-2006, 11:25 AM
  5. [SOLVED] Legend Missing Info
    By Debra Ann in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-11-2005, 11:05 AM
  6. Where are my partially missing grid lines?
    By newbie in forum Excel General
    Replies: 1
    Last Post: 08-17-2005, 02:05 PM
  7. Missing grid lines
    By Fortissima in forum Excel General
    Replies: 1
    Last Post: 04-05-2005, 04:06 AM

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