I am doing a spread sheet on  Excel.. I am putting hyperlinks on the spread sheet.. Now when I click on the hyperlink option on the cell it brings up another box and says things like websites viewed.. How do I clear those out? There is like 1000 in there..
215064
right click on the taskbar, click properties, click on the start menue tab, click on customize, then advanced tab then clear list.\n\noh sorry, i just tried it, u need to clear ur history and temp files, from the control panel then internet options, click on delete cookies and delete files and clear the history.. that took care of it
601092
The easiest way to do this, that would not require very much programming knowledge at all would be to use the 'Publish as Webpage' feature in excel.\n\nYou can set it so that every time the spreadsheet is updated and saved, it also saves a file, readable by internet explorer, into a folder of your choice. This way you can reference the file in the rest of your site or in a frame or whatever.
94559
the above answer is quite wrong, that will temporaraly get rid of them, but not stop it compleatly. in Internet Explorer go to Tools>Internet Options>Content>AutoComplete then "uncheck" the "forms" and "web addresses" options, and click "clear forms" to get rid of current ones.
440130
It is the virus which my pc got infected recently.  This virus is deleting the Word and Excel files.  Until you remove it, do not open any folder that contains word or excel file. \n\nIf you try to delete the virus, it will recreate itself.  Appears to be residing in memory.  Every time you open a folder, a new copy of the virus is also created in that folder.  I tried NAV scan with latest update but it could not detect the virus.    \n\nAnyone can find any removal tool, please offer your advice.\n\nThanks,
615578
Yes, as the others said, go into the "Define Name" Dialog box (which you can access either through Insert>Name>Define or through the keyboard shortcut "Ctrl+F3"). In there you'll see all the named ranges defined and so you can see if they are in that worksheet or somewhere else.\n\nAnother possible solution is to use Edit>Go To and then select the named range you want to locate.\n\nAnother very neat feature is to use "zoom out"  and go below 40% (Ctrl+Mousewheel Down) and the named ranges will become apparent and labelled (as long as they're not dynamically defined ranges).\nThis is incredibly useful when you have lots of named ranges because you can see them all at once.\n\nYou might also want to check if your spreadsheet contains links to other worksheets, because if that's the case, it can create problems when you send that spreadsheet to other people that don't have access to the linked document.\n\nFor this, go into "Edit" Menu and choose "Links". If it's grayed out, it means there's no link, and you're clear.
172227
I think the problem is probably screen resolution. I know you said that you've tried adjusting your screen width, but maybe your monitor is too small for everything to fit on.\n\nYou see, in HTML (website programming), when you type something, and it reaches the end of a line, it jumps to the next. Likewise, if all the links can't fit on one line, one will jump to the next line.\n\nStill, it is strange that the link appears over a text box. Maybe it is something wrong with Yahoo's programming, but I doubt it. My searches are working fine.\n\nTry setting your text size by going to View -> Text size. Select a text smaller than the one currently selected. (This is for Internet Explorer)\n\nHope that could help...
627098
That list is your most recently used documents list and can't be edited easily.  You can't do anything with those names except to open them by clicking on them.  If you wanted to remove them, you'd have to find them on your computer via Explorer or Search and delete them that way.  As for getting rid of them on your list, your best bet is to open some other files - the ones you don't want will automatically drop off as you open more Word documents.\n\nIf you don't want that list to populate at all, you can always go to Tools-Options, then click on the General tab and uncheck the box next to Recently used file list (or you can simply reduce the number of files shown in your list).
429734
Here's some instruction for a UDF (User Defined Function) to do what you need.\n\nhttp://www.ozgrid.com/VBA/HyperlinkAddress.htm
525458
Tools > Clear Private Data.\n\nA popup box will appear and there will be checkboxes for you to indicate exactly what you want cleared.
324670
It depends on the form of your excel functions, if they're web page and showed as links on your \n\nmessages, you might loose them if the author of these pages change them. \nIf the messages are loaded on your pc, can be copy and paste, saved on your pc, then its yours.\nIf the messages can only be seen if you log in, then only a very slim chance the email provider has computer problem and your messages are non-recoverable.
193056
Top of web page tools internet options delete files delete cookies clear history Then click on content clear ssl state autocomplete clear forms.\n\nHope this helps.\n\nGood Luck.
28817
The way that I do is as follows....\nI click the tools button, then select internet options.  Then I click the Content Tab.  Then select Auto Complete.  There you can delete and check what you do and don't want.
643479
I have found this to be an intermittent glitch in the program. Not sure what or why. Most of the time, it works fine. Every now and then, after creating a new excel document, I run into this problem.\n\nMy get around on this is to take an existing .xls document that cooperates and modify then save. Make sure to rename the file as to not overwrite the original.
568127
If you type a ' before you paste it in, you should not have a problem.  \n\nThe ' will dissapear and your number will show up.  You may have to format the cell afterwords to get the commas back if you want them to remain.  To do this, right click on the cell and go to "format cell..."\n\nGood Luck!
320020
You could use conditional formatting on the cells where you are entering your data.  But you actually don't need to do conditional formatting, it's just that you can get smoother more interesting effects if you do.  An easier way might be a simple formula.\n\nIt sounds like you are entering data that uses Case numbers, but if you have already entered a case, you don't want to do it again.  Obviously you could just search the case number column to see if it already exists and if so, then skip entering it.  But a more automated way would be easier.\n\nThe essence of what you need to do is use a formula to tell you if what you just entered already exists in the rows above. (To use your example, does case 24 exist already in the rows above A27?)\n\nYou could insert a (temporary) column to the left of what you are typing in.  In that column you would enter a formula to count the number of instances where the case number you just entered already exists above.  Usually the result would be 1, sometimes 2.\n\nLets say you are on row 27 and your case numbers are in column B, and your counting column is column A.  Lets assume your data starts on row 2 at the top of the spreadsheet.  Your formula for cell A27 would be:\n=IF(COUNTIF($B$2:B27,B27)>1, "Exists Already!", "")\n\nNotice the $ signs in the Countif formula.  The formula range will adjust as appropriately as you copy it around.  You want to get this formula on every line next to every case number so that it can alert you if it seen there is more than once instance.\n\n(Actually the Data Validation mentioned below is a better solution because it will prohibit you from entering the data.  But it's all the same principle. Just more elegant because you don't need to insert a new column.)
421705
From where did you created this CheckBox\nIf you created it form Toolbars > Forms, then\n- Create a cell link for that checkbox (Right click on checkbox > Format Contol > Control > Cell Link)\n- Now, in this cell create the function that do your comparing, example (=A1 + B1 > 500)\nSo If you put 400 in A1 and 40 in B1 the Check box will be "Unchecked", if you changed B1 to 140, checkbox will be checked\n\nThis technique will work as long as you don't click on that checkbox, once you click it, the formula you made will be deleted.\nThis is because you are using this forms control.\n\nIf you don't like this, you will need to create the Checkbox from Toolbars > Control toolbox.\nThis will need you to use macros, you can mail me on this\n\nEnjoy my profile, I am the VBAXLMan
13153
I get lots of these lately too.  I don't even open them, just delete them.  THEY'RE SO ANNOYING!