Results 1 to 4 of 4

Thread: Why do I see green ribbon on top left corner of a cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2019
    Location
    Win 10, Office Professional Plus 2016
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Why do I see green ribbon on top left corner of a cell

    When I paste data onto a spreadsheet.
    For columns formatted as General which has numbers in it, it says Number stored as Text with an option to Convert to numbers.

    Why do I see this despite the formatting being general?
    Even when I highlight the entire column and format the column cells to Number, the green ribbon is still there.

  2. #2
    Board Regular Kenneth Hobson's Avatar
    Join Date
    Feb 2007
    Location
    Tecumseh, OK
    Posts
    3,079
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Why do I see green ribbon on top left corner of a cell

    Unless you pasted just values, text formats might have passed. e.g. Type 21 in Word and bold it. When you paste to Excel, it pastes all formats. Use Paste Special and paste as text when then pastes just the number and not other formatting.
    Last edited by Kenneth Hobson; Jul 22nd, 2019 at 10:48 PM.

  3. #3
    Board Regular
    Join Date
    Jul 2019
    Location
    Win 10, Office Professional Plus 2016
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Why do I see green ribbon on top left corner of a cell

    I will have to play around with it to understand. I think it might be causing my workbook to lag somehow.

    Another question, when I paste data with 1000 rows and then delete it, I am still able to scroll down to the 1000th row with the scroll column on the side, how do I make it limit to the rows with data on screen after I have deleted everything on that sheet?

  4. #4
    Board Regular Kenneth Hobson's Avatar
    Join Date
    Feb 2007
    Location
    Tecumseh, OK
    Posts
    3,079
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Why do I see green ribbon on top left corner of a cell

    There is an arrow at bottom of Paste button. Click it and then the Paste Special. Or, add Paste Special from the Popular Commands when you Customize the ribbon.

    As for delete, if you mean delete with a key press of delete key, that does not clear all of the formats. Select the Clear, Clear All to do that or delete/remove the whole row.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •