software

Hi everyone!

I've been using excel al lot for accounting work lately and the
following has been annoying the hell out of me:

If you copy the content of a cell with ctrl-c, then type something
elsewhere, then paste using ctrl-v: it does nothing.

Why the hell should typing something clear the clipboard?!?
Tried this on Excel XP and 2003.

Another question: Is there any way to store custom cell formats
permanetly?Thanks a lot.
Martin--
Sphere
------------------------------------------------------------------------
Sphere's Profile: www.excelforum.com/member.php...oamp;userid=33609
View this thread: www.excelforum.com/showthread...hreadid=533880It's the nature of the beast. If you paste first then type, it'd be easier.
However, you can still access the clipboard by Ctrl/F1, then can paste what
you copied by selecting it from the clipboard taskpane.
You can store custom cell formats by saving the workbook with those formats
in a template. Once you create the format, clear all cells so you have an
empty workbook, then save it as file type Template, name it quot;book.xltquot;, abd
store it in the XLSTART directory. Now, every new workbook will be a copy of
this one and you have the formats.

quot;Spherequot; gt; wrote in
message ...
gt;
gt; Hi everyone!
gt;
gt; I've been using excel al lot for accounting work lately and the
gt; following has been annoying the hell out of me:
gt;
gt; If you copy the content of a cell with ctrl-c, then type something
gt; elsewhere, then paste using ctrl-v: it does nothing.
gt;
gt; Why the hell should typing something clear the clipboard?!?
gt; Tried this on Excel XP and 2003.
gt;
gt; Another question: Is there any way to store custom cell formats
gt; permanetly?
gt;
gt;
gt; Thanks a lot.
gt; Martin
gt;
gt;
gt; --
gt; Sphere
gt; ------------------------------------------------------------------------
gt; Sphere's Profile:
www.excelforum.com/member.php...oamp;userid=33609
gt; View this thread: www.excelforum.com/showthread...hreadid=533880
gt;
gt; Why the hell should typing something
gt; clear the clipboard?

Beats me, but it's worked like that since I first used Excel on a Mac
in the 1980s.

gt; Is there any way to store custom cel
gt; formats permanetly?

If you mean as a library, you could create a workbook and format
various cells the way you wish. Then use the Format Painter to copy
the ones you need to new workbooks.
Thanks guys

gt; Beats me, but it's worked like that since I first used Excel on a Mac
gt; in the 1980s.

I think I know why they didn't change it: They hanged the guy who wrote
the code and could not fix it without him.--
Sphere
------------------------------------------------------------------------
Sphere's Profile: www.excelforum.com/member.php...oamp;userid=33609
View this thread: www.excelforum.com/showthread...hreadid=533880If it's something you do every day, maybe recording a macro when you do it once
would help. You could always just replay that macro when you needed to.

Sphere wrote:
gt;
gt; Thanks guys
gt;
gt; gt; Beats me, but it's worked like that since I first used Excel on a Mac
gt; gt; in the 1980s.
gt;
gt; I think I know why they didn't change it: They hanged the guy who wrote
gt; the code and could not fix it without him.
gt;
gt; --
gt; Sphere
gt; ------------------------------------------------------------------------
gt; Sphere's Profile: www.excelforum.com/member.php...oamp;userid=33609
gt; View this thread: www.excelforum.com/showthread...hreadid=533880

--

Dave Peterson