+ Reply to Thread
Results 1 to 6 of 6

Strange Shrinking Text in one merged cell

  1. #1
    Registered User
    Join Date
    10-15-2017
    Location
    Sydney, Australia
    MS-Off Ver
    2016 Windows version
    Posts
    4

    Strange Shrinking Text in one merged cell

    I have been using the same basic spreadsheet for many years to quote for work.
    I have my business name in 36 font Cambria in merged cells 1A-1D that have each been altered in size.
    in the last week when I open any of the old files the font for this cell appears fine for a fraction of a second and then reduces to be visually about a size 9 font but states 36.
    It prints at about 9 also.
    If I alter the size it reverts back to normal and I can save to PDF or print but if I save it and reopen it does the same thing.
    I cannot find this anywhere on the net.
    Any suggestions on a cause &/or solution?

  2. #2
    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,946

    Re: Strange Shrinking Text in one merged cell

    It might help if we could see a CLEAN sample of your file, otherwise we are just guessing and working blind
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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

  3. #3
    Registered User
    Join Date
    10-15-2017
    Location
    Sydney, Australia
    MS-Off Ver
    2016 Windows version
    Posts
    4

    Re: Strange Shrinking Text in one merged cell

    Hi Ford,
    I apologise for being a novice at this.
    I believe that I am trying to find 'manage file' in the wrong location as I cannot locate it.
    Can you please lead me by the hand BEFORE your wording of 'click advanced' (next to quick post) as I am probably in the wrong location.

    Many thanks
    Grant

  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,946

    Re: Strange Shrinking Text in one merged cell

    No problem

    At the bottom right corner of "this" window (where you type your reply), there is a button that says "post quick reply". Well, right next to that is the "go advanced" button

  5. #5
    Registered User
    Join Date
    10-15-2017
    Location
    Sydney, Australia
    MS-Off Ver
    2016 Windows version
    Posts
    4

    Re: Strange Shrinking Text in one merged cell

    Hopefully the file is now attached.
    The problem is the Only Awnings in Blue & Red
    This is the area that shrinks when I open it.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-15-2017
    Location
    Sydney, Australia
    MS-Off Ver
    2016 Windows version
    Posts
    4

    Re: Strange Shrinking Text in one merged cell

    Interesting. When I open the above file after posting it to this site it does not shrink.
    If I open it on my PC it shrinks.

+ 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. Shrinking text on Excel 2007 command buttons, labels and textboxes
    By csipke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2012, 09:57 PM
  2. Shrinking text size-command button
    By chemi9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 07:21 PM
  3. rows of text in merged cell with wrap text
    By mark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2006, 01:45 AM
  4. [SOLVED] merged cells into one text cell, size varies dependant on text dat
    By Jazzylady825 in forum Excel General
    Replies: 0
    Last Post: 12-09-2005, 04:30 PM
  5. Strange Formating problem with text and formula in same cell
    By caliskier in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-06-2005, 07:05 PM
  6. [SOLVED] retrieve text from merged cells-How do i read the text in the merged cell?
    By Eric in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2005, 05:05 AM
  7. [SOLVED] Pasting text into merged cell
    By GeorgeB in forum Excel General
    Replies: 1
    Last Post: 05-17-2005, 12:06 PM
  8. Text in Buttons is shrinking with each Click. HELP!!!
    By Baxter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2005, 03:26 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