+ Reply to Thread
Results 1 to 3 of 3

Excel 2010 Not Showing Formatting/Data in a Merged Cell

  1. #1
    Registered User
    Join Date
    12-30-2014
    Location
    Colorado, USA
    MS-Off Ver
    Office 2013
    Posts
    2

    Excel 2010 Not Showing Formatting/Data in a Merged Cell

    I am by no means an Excel Guru or all that knowledgeable about Excel - I use it daily and can function in it well enough for what I need to do day to day.

    My father in law has run into an issue with an Excel spreadsheet that he needs to utilize for work.

    The workbook itself is password protected - so I do not really have the ability to edit or attempt to manipulate in hoping to resolve the problem.

    The problem being that there are a series of merged cells that include a series of multiple choice answers (A., B., C., and D.) but on his PC in Excel 2010, B. and C. are missing - only A. and D. are shown.

    When I open the Excel workbook in Excel 2013 on my PC, it displays everything fine. I've attached two screenshots - one of the data showing correctly in Excel 2013 and one of the data not being shown in Excel 2010.

    Others at his workplace utilizing Excel 2010 do not have this issue and they spent several hours yesterday working on it but seem to think it may be an issue with his PC as they are not experiencing the issue.
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Excel 2010 Not Showing Formatting/Data in a Merged Cell

    Pictures aren't much use in an Excel forum...

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    12-30-2014
    Location
    Colorado, USA
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Excel 2010 Not Showing Formatting/Data in a Merged Cell

    Further research has revealed that the missing data is not actually text at all - it is an image that was copied and pasted into the cells (uploaded to Google Sheets - this removed the password but revealed the image).

    Unable to create a sample or otherwise replicate as I have no idea what formatting was done previously - I didn't create the workbook nor do I have the password for the workbook. There isn't a process that I am attempting or trying to automate - I am simply trying to get it to display/print properly for my father in law.

    The screenshots were an attempt to show how it displays differently between Excel 2010 and Excel 2013.

+ 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. Excel 2010 - Showing multiple values per cell
    By mmccormick in forum Excel General
    Replies: 5
    Last Post: 07-31-2014, 08:30 PM
  2. Excel 2010 - Data and dates not showing in line chart.
    By TomMan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-08-2014, 07:31 AM
  3. Conditional Formatting in 2010 shared is not showing up in 2007
    By thuddleston11 in forum Excel General
    Replies: 0
    Last Post: 09-13-2012, 10:49 AM
  4. Move page break to top of merged cell with VBA Excel 2010
    By marek12886 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2011, 03:21 PM
  5. Excel 2010 filters not showing data labels
    By sangland in forum Excel General
    Replies: 0
    Last Post: 06-29-2010, 07:25 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