General

How to delet browsed pages list from the insert hyperlink
How can I clear / delete the browsed pages list shown on the inser hyperlink dialque box ... 5 Jul 2008 10:28

How can I eliminate rows that contain the same data as the row
Is there a built-in function providing the same functionalities of Advanced filter providing the source list and the destination area for the select-distinct process? Thanks, Stefano "Peo Sjoblom" wrote: Use data>filter>advanced filter, select unique records only -- Regards, Peo S... 5 Jul 2008 08:26

formula help
hi i'm trying to calculate charges at different rates according to the criteria in various cells, but i'm not getting very far. example column A contains a stock figure column B contains stock to be received figure & column C contains type of stock to be received either a Y or a blank. what i need is if C conta... 8 Jul 2008 12:04

Excel 2007 slow changing between worksheets
I would be interested in knowing what it is that sometimes causes some worksheets in Excel to 'hang' briefly. For example, I have a workbook with several worksheets, two of which are largely similar, but when I select one of them it moves to it instantly, whereas the other one takes a few seconds to display. Addi... 5 Jul 2008 07:25

Reference to sheet name in another workbook
I want to link cells a worksheet to cells in a worksheet in another workbook based on the tab name of the sheet in the other workbook. I have a master workbook with sheets for each month named Jan2008 Feb2008 etc. I want to compile a summary worksheet for a single month - say Jun2008 - where I want to extract... 6 Jul 2008 09:55

restricted permission for worksheet
Can we provide restricted permission on various worksheet within an excel file. If yes, then How? ... 5 Jul 2008 10:28

FINDING TOP 20 (URGENT PLEASE)
Please help me in the following example: I have a list of 100 figures in B1:B100. I want to insert a formula in A1:A100 which results in showing the position of each number i.e. from 1 to 100 in the order of volume of corresponding figure in Column A. In the end I insert: 1 to 20 (in C1:C20) and =vlookup(C... 7 Jul 2008 05:19

Lookup value needed
I have a sheet which has 4 coloums A B C D Don 115 Don 50 Don 125 Mary 85 Mary 15 John 10 Phil 25 Phil 35 Using the formula I want to pull up the lowest value next to names value in Coloum "C" & "D" ... 5 Jul 2008 22:43

How do I add column headings to the single sheet.
When I imported a data base, Excel set up just fine. However, when I switched to form view, not all the headings were included. How do I get all the headings to show in the form view? ... 5 Jul 2008 00:19

Using merge cells in worksheet for Pivot Table
I am trying to use merge cells to establish a hierarchy in a worksheet that I will turn into a Pivot Table. By hierarchy, I mean something like a Dog has fleas, bones, chew toys so if I bring up Dog on the pivot table I should get fleas, bones, chew toys to appear. In one column I put Dog then in the column b... 5 Jul 2008 09:27