Is it possible to freeze panes without a line being drawn right accross the
whole page?

I am recording a Macro which uses a VLookup to fill in values in column
A from another file.  Where a match is not found it displays #N/A.  I
can use AutoFilter to filter out all the #N/A's and then delete these
rows.  The problem is that the orginal file is downloaded on a regular

I need help in importing a directory name into excel. More specifically,
just like GetOpenFileName opens up a window where one can choose files to
open, I need to do the same but only list directories and not files. When I
click on a directory, that directory name should be ...

I just accessed a worksheet which Im trying to add a column to...
I highlight the column which i want the new column inserted ...and when
i try to insert a column it doesnt work! A warning message comes up
stating that a column cannot be inserted until blank cells are removed

I am trying to import some data from a website where the data 'pops up' in a
window and does not give you the web page address, so I can't use  Data /
Import External Data / New Web Query to obtain it.
I tried a simple copy and paste but all I get is an annoying bitmap icon in

I have a table of time interval values that range from a few seconds
to 200 days. I would like to define a custom format that will use a
"hh:mm:ss" format if the number if < 1 and a "0.00" format if the
number is >=1. I thought I saw a way to do that in the help, but now I

Hi! I am new to the forum, and I love playing with Excel so I might be
frequent visitor here, I dont know. :)
I have this nifty Excel problem that I cannot solve. I need a formul
that calculates the following for a roleplaying generator:

Is it possible to have an IF statement that if YES it changes the colour of
the cell to red ?
Pete

I cannot figure out how to have totals from one sheet to be recorded in a
cell on a different sheet in the same workbook

I need to be list some stats symbols within a work book but can't find
them in the available symbol lists
Am trying to enter Xbar (X with a line above), Rbar (as x bar) and
Xbarbar (X with 2 lines above) etc.

A colleague runs the car-park lottery for our organisation. She uses an
Excel spreadsheet witha round 1500 entries. The sheet identifies each staff
member by means of their exclusive payroll number. The lottery is run 4
times a year. However, she has a problem in that when a ...

I've made a pivot table that shows me the number of duplicate entries on
an address list.  Now I want to delete the duplicates.  When I drill
down, it puts the list onto a new sheet, and deleting the rows I don't
want does not effect my original data source.  Is there an easy way to

Looking for a formula to locate a score from a results table place it next
to the fixture list.
(backward sounding I know but from fixture list I can ascertain current
form, but I cant from a table)

Looking for a formula to locate a score from a results table place it next to the fixture list.
(backward sounding I know but from fixture list I can ascertain current form, but I cant from a table)
Created a fixture list  I.e.  Arsenal vs. Aston Villa is the first fixture. and I ...

I want to add the "+" symbol to text but when I type it and enter, I
lose the "+" symbol.
Example: +12 becomes just 12,  I want to show the "+" symbol, any
ideas?