On Sat, 02 Feb 2008 17:56:34 +0200 Dotan Cohen wrote: > On 02/02/2008, mike scott <[EMAIL PROTECTED]> wrote: > > I agree it's not clear whether 'cut' should remove background as > > well > > as content. > > > > However, it seems behaviour is different depending on whether "the > > cell" or "all cell content" is selected. Select a cell, and ^X > > removes everything; double-click on a cell and select the contents > > with ^A, and then ^X seems to remove just the content. > > Instead of double clicking, I hit F2. > > > Maybe another recorded macro?? >
Or use copy, followed by backspace to delete the text. Copy will copy everything, including the formatting, but your paste special solves that. But backspace key should not delete the formatting just the contents with luck. If that doesn't work how about replacing the contents with an empty string to leave the formatting intact. Macro:- Edit - Copy Space (or similar to empty the contents) -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
