Excel Copy Annoyance

[Sphere]

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

 

[Bob Umlas]

It'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 "book.xlt", abd
store it in the XLSTART directory. Now, every new workbook will be a copy of
this one and you have the formats.

 

[Mark Lincoln]

Why the hell should typing something

clear the clipboard?

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

Is there any way to store custom cel
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.

 

[Sphere]

Thanks guys

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

I think I know why they didn't change it: They hanged the guy who wrot
the code and could not fix it without him

 

[Dave Peterson]

If 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.