How to remove a "sticky".

[Slice'N'Dice]

Sorry, I don't know what the proper term for this is called, but when entering data into a spreadsheet (that someone else has made), when I click in a certain box, a little square pop-up box appears on the screen with instructions on what to write etc, like a post-it note .

Anyways, I can drag this box around the screen to move it out of the way, but is there any way of actually disabling this from happening (to stop the notes popping up)?

 

[Zack Barresse]

Hi Slive'N'Dice!

Not sure what type of object it is that you are referring to. If it is a comment box, go to Tools --> Options --> View. Check out the comment tag options there.

 

[Slice'N'Dice]

Hi .

It may actually be a comment box, I'm not too sure though, I will have to check it out tomorrow morning & get back to you. Thanks for the solution!

Oh, I have another question, sorry to be a pain, but, say if I had two spreadsheets open, for simplicity, Spreadsheet A & B. If I copy a formula from spreadsheet A to spreadsheet B, when I click paste, all references get pasted into the formula bar. What I mean is that, the tab name, spreadsheet title etc all get pasted in along with the formula.

If you have understood what I'm trying to say there, is there anyway to stop that from happening? I.e, just copy & paste the formula?

 

[Zack Barresse]

Are you using PasteSpecial --> Link?

 

[Slice'N'Dice]

Are you using PasteSpecial --> Link?

Sorry? What is PasteSpecial?

 

[Zack Barresse]

When you copy something, and go to the edit menu, there is a paste special below Paste. This allows you to specify different attributes to paste from the copied cell(s)/region(s). You can use it to paste only the values, the formulas, the formats, the comments, the column widths, validation, etc. .. and links to the cell being copies.

If you are only wanting the values, after you copy (Ctrl + C) use Alt + E, S, V. If not, describe the exact steps you take, start to finish, to get the results you are describing.

 

[Slice'N'Dice]

When you copy something, and go to the edit menu, there is a paste special below Paste. This allows you to specify different attributes to paste from the copied cell(s)/region(s). You can use it to paste only the values, the formulas, the formats, the comments, the column widths, validation, etc.

If you are only wanting the values, after you copy (Ctrl + C) use Alt + E, S, V. If not, describe the exact steps you take, start to finish, to get the results you are describing.

Oh! Yes thats perfect. Many thanks for your help. I really appreciate it!