| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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 |
|
#9
|
|||
|
|||
|
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 |
|
#10
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| Deleting rows containing common data | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
