ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel Office 2007 (https://www.excelbanter.com/excel-worksheet-functions/230490-excel-office-2007-a.html)

pjsicon

Excel Office 2007
 
I have a spreadsheet I downloaded. On a select range of cells, when my cursor
is placed within this range, it displays a box with some text. I want to
delete this function. does anyone have an idea?

kassie

Excel Office 2007
 
Sounds like a comment attached to one of those cells?
Click on the cell where this comes up, then right click, and select Delete
Comment

--
HTH

Kassie

Replace xxx with hotmail


"pjsicon" wrote:

I have a spreadsheet I downloaded. On a select range of cells, when my cursor
is placed within this range, it displays a box with some text. I want to
delete this function. does anyone have an idea?


Rick Rothstein

Excel Office 2007
 
I'm guessing the "box with some text" is a Comment. Try this and see if it
solves your problem... select the range you are talking about, right click
the mouse and select "Delete Comment" from the popup menu that appears.

--
Rick (MVP - Excel)


"pjsicon" wrote in message
...
I have a spreadsheet I downloaded. On a select range of cells, when my
cursor
is placed within this range, it displays a box with some text. I want to
delete this function. does anyone have an idea?



Ken Wright

Excel Office 2007
 
If it's not a comment then it's likely to be the input message from a Data
Validation option.

Select the range, do Data / Validation and then clear the entry on the Input
Message tab

Regards
Ken.....................



"pjsicon" wrote in message
...
I have a spreadsheet I downloaded. On a select range of cells, when my
cursor
is placed within this range, it displays a box with some text. I want to
delete this function. does anyone have an idea?





All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com