deleting 100's of pictures, keep data
 

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

Try this

press F5
special
select objects
OK
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

I could kiss you. But, I'm a guy and I'm not gay, ...who cares I could still
kiss you. You saved me days of work because there are about 15 worksheets
like this.
--
me


"Ron de Bruin" wrote:

Try this

press F5
special
select objects
OK
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

You are welcome

I could kiss you. But, I'm a guy and I'm not gay
Do you have a nice girlfriend<vbg


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
I could kiss you. But, I'm a guy and I'm not gay, ...who cares I could still
kiss you. You saved me days of work because there are about 15 worksheets
like this.
--
me


"Ron de Bruin" wrote:

Try this

press F5
special
select objects
OK
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

Happily married since September 7, 2002
--
me


"Ron de Bruin" wrote:

You are welcome

I could kiss you. But, I'm a guy and I'm not gay
Do you have a nice girlfriend<vbg


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
I could kiss you. But, I'm a guy and I'm not gay, ...who cares I could still
kiss you. You saved me days of work because there are about 15 worksheets
like this.
--
me


"Ron de Bruin" wrote:

Try this

press F5
special
select objects
OK
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

I win

Happily married since November 9, 1990

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Happily married since September 7, 2002
--
me


"Ron de Bruin" wrote:

You are welcome

I could kiss you. But, I'm a guy and I'm not gay
Do you have a nice girlfriend<vbg


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
I could kiss you. But, I'm a guy and I'm not gay, ...who cares I could still
kiss you. You saved me days of work because there are about 15 worksheets
like this.
--
me


"Ron de Bruin" wrote:

Try this

press F5
special
select objects
OK
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

No, I win. This is my second marriage. LOL

"Ron de Bruin" wrote:

I win

Happily married since November 9, 1990

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Happily married since September 7, 2002
--
me


"Ron de Bruin" wrote:

You are welcome

I could kiss you. But, I'm a guy and I'm not gay
Do you have a nice girlfriend<vbg


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
I could kiss you. But, I'm a guy and I'm not gay, ...who cares I could still
kiss you. You saved me days of work because there are about 15 worksheets
like this.
--
me


"Ron de Bruin" wrote:

Try this

press F5
special
select objects
OK
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me

LOL

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
No, I win. This is my second marriage. LOL

"Ron de Bruin" wrote:

I win

Happily married since November 9, 1990

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Happily married since September 7, 2002
--
me


"Ron de Bruin" wrote:

You are welcome

I could kiss you. But, I'm a guy and I'm not gay
Do you have a nice girlfriend<vbg


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
I could kiss you. But, I'm a guy and I'm not gay, ...who cares I could still
kiss you. You saved me days of work because there are about 15 worksheets
like this.
--
me


"Ron de Bruin" wrote:

Try this

press F5
special
select objects
OK
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jsc3489" wrote in message ...
Tried that, it copied everything
--



"Manish Bajpai" wrote:

Highlight the entire sheet, copy and paste it on another sheet ...this will
copy only the data....then simply delete the old sheet with 2000 small
pictures !!!

Thanks,

Manish Bajpai

"jsc3489" wrote:

I have a task. I just started working in an office and I've been instructed
to remove about 2000 little pics from an excel sheet that have been copy and
pasted numurous times. Is there a way to delete them all (other than one at a
time) without losing the data
--
me