I'm curious if there is a way to keep the comments of a cell even when pasting new data into that cell. It seems like when a paste the comments are wiped out. I'm looking for a way to provide instructions on an excel sheet and still be able to paste into all cells (Crtl-A - Copy from one sheet, Ctrl-A - Paste in another).
2007-12-28 03:41:35 · 2 answers · asked by tysonlee19 1 in Computers & Internet ➔ Software
this is a strange faiult that often occurs - if you check excel help - all will be revieled
2007-12-28 03:49:08 · answer #1 · answered by Anonymous · 0⤊ 1⤋
i didnt check the help file, but i will take a guess.
when you ctrl-A to choose all, you get all.
you can try right clicking on your new sheet and paste special...
then choose formulas to reset the formulas
then do it again except this time choose formatting to reset any formatting.
there may be a faster way.
2007-12-28 22:06:36 · answer #2 · answered by expletive_xom 7 · 1⤊ 0⤋