|
|
|
|
3 |
120 |
|
|
Help goes to IExplorer by
Garich
Using Vista & Office 2007
I get a couple 'normal' help screens until I get down to a specific help.
At that point, a pop-up box titled "File Download" asks...
|
October 6th, 2009 05:44 PM
by Garich
|
0 |
128 |
|
|
Formula help by
Confusicous
d1= ln(B6/B7)+ / (B9) (SQRT B10)
This is supposed to be Black-Scholes Option Pricing Model. I tried my best
to show the formula on here and I entered the...
|
|
4 |
185 |
|
|
Link to Named Range in External File by
Jason
Hi,
I have to workbooks, workbook1 and workbook2.
I have a named range in workbook2.
In workbook1 I used the get external data feature to link to the named...
|
October 6th, 2009 05:42 PM
by Jason
|
0 |
105 |
|
|
|
October 6th, 2009 05:40 PM
by Bob I
|
11 |
164 |
|
|
|
October 6th, 2009 05:17 PM
by dbagby
|
0 |
122 |
|
|
Linking Formulae Across a Workbook by
Mikki Shaw
I have created a workbook in Excel 2003, there are lots of worksheets within
this workbook. Basically I am trying to monitor an accumulative balance. My...
|
|
2 |
102 |
|
|
displaying specific rows on screen by
johnsail
Hi
I would like to control which lines are displayed on screen.
For example:- when user gets down to line 35 I would like to display form
line 20 onwards....
|
|
1 |
94 |
|
|
Conditional Formatting Tab Locked by
WOODY
Hi All
I have formatted a spreadsheet I use daily using the conditional formatting
options and for some reason the tab is now greyed out so I can't get back...
|
|
2 |
121 |
|
|
macro deletes wrong columns by
Wanna Learn
Hello I have excel 2003 . Every day I receive a file and I have to delete
some columns. so I created a simple macro to delete the columns I do not
need. ...
|
|
4 |
103 |
|
|
Bypass Auto-Open Procedure by
QB
How can I bypass the auto_open procedure when I open a workbook?
Previously, holding down the SHIFT key worked beautifully (2003 and prior).
However, with...
|
October 6th, 2009 04:29 PM
by Bob I
|
1 |
128 |
|
|
Delete the clipboard icon in Excel 2007? by
Option Trader
How do I delete the clipboard icon in excel 2007. It follows me on the
worksheet whenever aI do a cut and paste. It is in the way an annoying.
|
|
0 |
95 |
|
|
overwritten files by
roseprince
i recently received an excel spreadsheet with an identical name to a newer
one i've been using and inadverdantly saved the older version over the new
one. is...
|
|
1 |
126 |
|
|
Make a word out of two cells by
Wombat
I have two columns of cells: one with a 3 digit number and the other with a
name.
How do I put the two together in a column so that it looks something like...
|
October 6th, 2009 04:23 PM
by Eduardo
|
3 |
96 |
|
|
Linking cells with changing format by
Wombat
Hello people
I was wondering if its possible to copy a cell (from one tab of a document
to another) and have them linked so that the format will change in...
|
October 6th, 2009 04:08 PM
by Wombat
|
3 |
130 |
|
|
Bypass a function in a Macro by
bevchapman
I am building a Macro that can run on a worksheet training matrix whether if
is filtered or not. It works beautifully as long as the file is filtered but...
|
|
3 |
109 |
|
|
Save as before do you want to save by
Levi
It's taking me a little time to get used to Office 2007, but one thing that
really really annoys me is that when I close a document - even if I don't
make...
|
October 6th, 2009 03:55 PM
by Levi
|
0 |
103 |
|
|
keeping format of a referenced cell by
Valeria
Dear experts,
I have a workbook where I reference cells from one worksheet to the other.
Ex. Cell A1 of Sheet2: "=Sheet1!A3"
My challenge is that I would like...
|
|
4 |
123 |
|
|
|
|
1 |
136 |
|
|
To find out % of profit by
pol[_2_]
Hi all,
Please help to write a formula for the following case
A1 cell conatin cost value 500
A2 Cell contaain sales value 700
In A3 cell I have to find...
|
October 6th, 2009 02:48 PM
by Stefi
|
4 |
100 |