+ Reply to Thread
Results 1 to 4 of 4

Black strings (lines) over corner of cells

  1. #1
    Registered User
    Join Date
    09-20-2018
    Location
    Derbyshire, England
    MS-Off Ver
    2013
    Posts
    2

    Black strings (lines) over corner of cells

    Can anyone tell me what these black strings (lines) are please? They appear in several places throughout a spreadsheet I've received. I'd like to remove them. Thanks in advance
    Attached Images Attached Images
    Last edited by grouseuk; 09-20-2018 at 11:59 AM.

  2. #2
    Forum Contributor
    Join Date
    09-19-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    208

    Re: Black strings (lines) over corner of cells

    Can you click/select them as objects? If so, you can delete them. If there are many, you can press F5, click Special, select Objects, click OK. That will select all objects in the worksheet, at which point you can press Delete.

    Note: This will delete ALL objects in the worksheet.

  3. #3
    Registered User
    Join Date
    09-20-2018
    Location
    Derbyshire, England
    MS-Off Ver
    2013
    Posts
    2

    Re: Black strings (lines) over corner of cells

    Answered my own question. These are turned on/off with the 'Show Ink' button on the 'Review' tab.
    Attached Images Attached Images

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Black strings (lines) over corner of cells

    FYI:

    "Ink annotations are a functionality that is only available on tablet PCs, with a specific version of Windows for Tablets. It enables the user to write notes with a stylus (stylist, ey, shg!) straight onto the screen, where the system will grab it and save it with the file as a kind of hand-written note.

    On a regular desktop or laptop, the feature is meaningless, unless you receive a file that has been ink annotated on a Tablet PC."

    Source: Post #2 here
    https://www.excelforum.com/excel-gen...nts-group.html

+ 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] Formula to look for certain text strings and return results without skipping lines
    By katiedee1625 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2018, 08:59 AM
  2. Black lines showing up on workbook
    By c_hopps in forum Excel General
    Replies: 5
    Last Post: 09-07-2017, 04:15 PM
  3. Replies: 0
    Last Post: 01-21-2015, 12:05 PM
  4. [SOLVED] delete only black text from cells containing both blue & black text
    By london.cl.2012 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-21-2012, 10:15 PM
  5. Replies: 7
    Last Post: 02-19-2012, 09:13 PM
  6. RE: insert 2 colours in a single cell,corner to corner
    By Toppers in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-23-2006, 03:50 AM
  7. [SOLVED] Gray vs Black Lines
    By Aurora in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2006, 03: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