+ Reply to Thread
Results 1 to 4 of 4

Cant click into cells - drawing rectangles appear !!

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    1

    Cant click into cells - drawing rectangles appear !!

    Hi,

    I have a problem with an excel sheet in which, when I try to click in a cell, I get a drawing object (rectangle2) appear over or near the selected cell.
    I cant do anything with it. When I click on certain cells I am fine and I am also fine if I tab from cell to cell.


    I attach an example

    Any help would be greatly appreciated
    Thanks
    Howard
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,697

    Re: Cant click into cells - drawing rectangles appear !!

    the only place I see "rectangle 78" (that is what I get when I open it) is the embedded object that says "May 2014" which you can move around as you want or delete.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,697

    Re: Cant click into cells - drawing rectangles appear !!

    Now I see the other ones you are referring to. they are embedded objects. if you click in it and it highlights the object, just hit delete if you want it gone. you can also drag them anywhere you want them by grabbing a border and dragging it elsewhere.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,697

    Re: Cant click into cells - drawing rectangles appear !!

    see if this link helps you...
    http://www.extendoffice.com/document...to-shapes.html

    EDIT: I followed the instructions at the top using the F5 or Ctrl+G, then Special, then clicking on objects then OK then hitting the backspace button and it removed All the drawings.
    Caution, if you want the May 2014 to remain you may have to put that on another sheet as that will be removed too.
    Last edited by Sam Capricci; 05-21-2014 at 12:22 PM.

+ 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] Drawing rectangles from x-y pairs in a table
    By MAA in forum Excel General
    Replies: 2
    Last Post: 04-19-2012, 07:24 PM
  2. Click to select cell under drawing object
    By tschroeder250 in forum Excel General
    Replies: 2
    Last Post: 06-26-2007, 10:50 PM
  3. [SOLVED] loop through rectangles on worksheet
    By jeichhold via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2006, 09:45 AM
  4. [SOLVED] Clearing rectangles
    By Andrew B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2006, 07:50 PM
  5. How to insert small colored dots or rectangles in cells of excel
    By George A. Yorks in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 04:06 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