How to Clear autoshapes out of a cell

[Guest]

I have a cell that has 10 autoshape squares in it. how can i just clear the
cell of them?

its part of about 100 other cells full of these shapes. the squares are tiny
and to click on each one to delete or to group them and then delete is too
time consuming. is there a better way? deleting the cell causes issues with
the rest of the form, with me having to insert a new cell in its place..

I also have another Q if your a cell making wizard!

this is basically an inventory worksheet for bunch of toys we use as decor.
the stock on hand changes daily

its set up as follows

Item number: item name : Quantity: currently on hand:

those are 4 cells
say quantity is 6.
so in the "currently on hand" cell there would be 6 squares each numberd 6 5
4 3 2 1

so they can check them off as they are used. its easier to see at a glance
this way.

is there a way to set up a reference so that if i put a 9 in quantity excell
can automatically create 9 tiny boxes in the "currently on hand" cell? or
perhaps refrence a cell and place it therE?

right now i have made 17 cells tha thave 1 to 17 boxes in them. i just paste
them to the appropriate area..

any help would be apreciated!

 

[Glen Mettler]

You could use a very elaborate nested IF statement. However, my curriosity
is peaked. Why are you using squares to represent quantity? Why not the
number/quantity itself and then when on gets used, it decrements????
Glen

 

[Debra Dalgleish]

Instead of using AutoShape squares, you could type a lower case "o" into
the cell (as many as required. (for a solid square, type "n")

Then, format the cell with Wingdings or Monotype Sorts font, and a
square will replace each o.

To delete them, select the cell and press the Delete key.

Or, you can use the REPT function to create squares --
In a cell (cell C2 in this example), type the number of squares required
In an adjacent cell, type a REPT formula, , e.g.: =REPT("o",C2)

 

[Dave Peterson]

Another couple of options:

=rept("|",a1)

But for something neater, try this:

=REPT(REPT(CHAR(134),4)&" ",INT(A1/5))&REPT("|",MOD(A1,5))