Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers: Simple Selection of Contents from Multiple Cells

Using Numbers 10.0

Im struggling to find a way to select text in multiple cells such that:

1) I can edit 'Bullets & Lists' as I can in a single cell as shown below



(selecting multiple cells causes the 'Bullets & Lists' toggle to disappear from the inspector. see below)



Id like to select an entire column and remove bullets from the text in each cell.

I tried to copy and paste into pages but it copies over the table and the same situation occurs.


I imagine I'm somehow missing something very obvious here. ☺️


Thanks !

🤞

MacBook Pro 15", macOS 10.15

Posted on May 3, 2020 12:14 AM

Reply
Question marked as Best reply

Posted on May 3, 2020 4:32 AM

Hi MonkeyMagic,


I see the problem. To show Bullets & Lists, the cursor must be inside a cell.

Since the cursor can not be in more that one cell at once, that is the gremlin.


The good news:

Insert another column (B in this example) in the table.

Click twice in cell B2 to insert the cursor and bring up Bullets & Lists just to check.


Column B has Bullets & Lists > None.

All is good.


Select and copy column A, select column B and Menu > Edit > Paste and Match Style:


Delete column A

Done!

Regards,

Ian.


P.S. If, perchance, the new column adopts the style of the bulleted column, you may want to insert a new table and Paste and Match Style into the new table. The new table will be "clean".

Ian.

Similar questions

6 replies
Question marked as Best reply

May 3, 2020 4:32 AM in response to MonkeyMagic420

Hi MonkeyMagic,


I see the problem. To show Bullets & Lists, the cursor must be inside a cell.

Since the cursor can not be in more that one cell at once, that is the gremlin.


The good news:

Insert another column (B in this example) in the table.

Click twice in cell B2 to insert the cursor and bring up Bullets & Lists just to check.


Column B has Bullets & Lists > None.

All is good.


Select and copy column A, select column B and Menu > Edit > Paste and Match Style:


Delete column A

Done!

Regards,

Ian.


P.S. If, perchance, the new column adopts the style of the bulleted column, you may want to insert a new table and Paste and Match Style into the new table. The new table will be "clean".

Ian.

May 3, 2020 8:45 AM in response to Yellowbox

See Edit at bottom for what may be the easiest method that shouldn't work but does for me.


Clever. Adding onto it, it appears that this alternate method also works:


  1. Change the style of the first one to remove the bullet.
  2. Select all of them
  3. Copy
  4. Paste & Match Style (back to the same cells that are still selected).


Alternate #2 that should not work:

  1. Select and copy all of them
  2. Paste and Match Style back to the same selected cells without doing anything else first


That shouldn't work but the bullets are disappearing for me.

May 3, 2020 3:49 PM in response to Yellowbox

Thanks, this worked.

Interestingly; I found that regardless of the 'Bullet & Lists' style selected in column B; it'll clear the style being pasted with "Paste and Match Style"

i.e If I select "Bullet & Lists: Lettered" in B2 it'll still simply clear all styles.


I guess that part of the inspector is meant for text boxes.


Thanks for your solution.

Numbers: Simple Selection of Contents from Multiple Cells

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.