Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cannot select or move objects. Slash Circle appears.

Suddenly I'm unable to select any object to reposition it. A white circle
with a slash appears when I move over any object, preventing me from
clicking. I've not seen this before. I also noticed the title bar now has
[Group] added to the title of my document. I'm in the dark as to how to
ungroup, undo, ... and how I got here in the first place.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Cannot select or move objects. Slash Circle appears.

It sounds like your objects may be grouped together, which is why you are unable to select or move them individually. Here's how you can ungroup them:
  1. Click on the grouped object to select it.
  2. Look for the "Group" button in the "Arrange" section of the "Format" tab. It should be located towards the right side of the ribbon.
  3. Click on the "Group" button and select "Ungroup" from the drop-down menu.
  4. If the "Ungroup" option is grayed out, it means that the objects are not actually grouped together. In this case, try selecting the object and pressing the "Delete" key to remove it.
  5. Once the objects are ungrouped, you should be able to select and move them individually without the white circle with a slash appearing.

As for how you got here in the first place, it's possible that you accidentally grouped the objects together by selecting them all and clicking the "Group" button. Alternatively, if you copied and pasted the objects from another document, they may have been grouped together in that document and carried over to your current one.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Cannot select or move objects. Slash Circle appears.

If you have more than one sheet selected, you'll see [Group] in the
title bar.
Any changes you make, will affect all the selected sheets.
To ungroup, right-click on one of the selected sheet tabs
Choose Ungroup sheets.

Elementary Computer Lab wrote:
Suddenly I'm unable to select any object to reposition it. A white circle
with a slash appears when I move over any object, preventing me from
clicking. I've not seen this before. I also noticed the title bar now has
[Group] added to the title of my document. I'm in the dark as to how to
ungroup, undo, ... and how I got here in the first place.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I select all the even rows in a worksheet and move them. AM-James Excel Discussion (Misc queries) 1 June 8th 06 04:44 PM
How do I make excel hide columns when it says cannot move objects Dale Excel Discussion (Misc queries) 0 November 10th 05 02:44 PM
Warning - "Fixed objects will move" kbwgirl Excel Worksheet Functions 1 September 8th 05 06:45 PM
Move select data to another worksheet Annabelle Excel Discussion (Misc queries) 3 July 27th 05 06:01 PM
Cursor keys move active cell or scroll screen, how do I select whi Rob Croft Excel Discussion (Misc queries) 1 June 18th 05 11:51 PM


All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"