|
|
R1C1 Referency Style Policy by
Jasper Recto
Is there a way to prevent the R1C1 reference policy from being used in excel
by using a group policy?
If not, how can I prevent it from being the default...
|
|
3 |
121 |
|
|
Protecting select cells by
Derrick
Is there a way to protect a sheet, and its formulas, but only for a few cells
- for the 2003 version?
for example: protected - f3 to f6, f8
...
|
|
2 |
102 |
|
|
Switching negative signs from back to front by
tracytracy123
Our system reports unfortunately have negative signs in back of numbers
instead of in front. When we export them to Excel, the negative numbers seem
to be...
|
|
4 |
127 |
|
|
|
June 23rd, 2009 03:37 PM
by RagDyeR
|
3 |
106 |
|
|
|
|
1 |
181 |
|
|
How to disable data source- pivot tables by
DUMMY
I would like to disable users from having the ability to change the data
source or connection in Excel 2007. Is there a setting somewhere that would
'dim'...
|
June 23rd, 2009 03:30 PM
by DUMMY
|
0 |
92 |
|
|
Pivot Table Total by
James
Hello
Does anyone know how to turn off "Totals" in Excel 2003. I can't find it and
it's driving me crazy!!
many thanks
--
James.
|
June 23rd, 2009 03:11 PM
by James
|
2 |
92 |
|
|
Auto file naming by
Jacquesvv
Hi There
Is it possible to automatically name a file based on two cell entries when
saving.
E.G
A1 B1
20090623 ...
|
|
1 |
80 |
|
|
Formulas by
Kim
I know this is probably a very basic question but hope someone can help. In
reference to copying formula... Lets say, for example that I have a number in
C1...
|
June 23rd, 2009 02:55 PM
by Kim
|
2 |
85 |
|
|
Excel Forms by
Trenchem
How do I increase the size of the checkmark in a form box without increasing
the size of the box?
|
|
0 |
79 |
|
|
|
|
1 |
87 |
|
|
|
|
1 |
83 |
|
|
Pasting objects in Excel by
Blacktom
I'm using lots of arrows in an Excel spreadsheet, so I'm copying and pasting
the same arrow over and over. Every time I paste the object, it appears in...
|
June 23rd, 2009 02:37 PM
by Joel
|
1 |
88 |
|
|
Text Searching in a Function by
malvis
Let's say I have one column with data like this: C012
But all I want to do is return all cells in that column that start with "C"
(there are many cells that...
|
June 23rd, 2009 02:23 PM
by TGV
|
3 |
126 |
|
|
year on year tracking by
Tony Chapman
I am trying to devise a spreadsheet so that i can track pupil progress from
year to year. I know their age and their assessed reading age and want to
track...
|
June 23rd, 2009 02:02 PM
by Luke M
|
1 |
101 |
|
|
Pivot tables calculated fields by
chastaink
I am using Excel 2003 SP3.
I can only work with the Pivot Table or Pivot Chart, not with the actual
source data (it is a "view," something I'm not really...
|
|
2 |
96 |
|
|
macro is not working? by
Derrick
I opened up my workbook this morning, and a security warning for my macro
showed up. now, my macros - the code i inserted into the sheet - is not
working. ...
|
June 23rd, 2009 01:51 PM
by Derrick
|
5 |
100 |
|
|
automatically deleting data, using macros by
Derrick
i have some code on the bottom of one of my sheets, something like this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B3"))...
|
June 23rd, 2009 01:41 PM
by Derrick
|
4 |
107 |
|
|
Max index / match question by
NBVC[_8_]
TRY:
Code:
--------------------
=INDEX($C$1:$C$5,MATCH(MAX(IF($B$1:$B$5=$D$1,$A$1:$A$5)),$A$1:$A$5,0))
--------------------
Confirmed with...
|
June 23rd, 2009 01:39 PM
by Eduardo
|
1 |
85 |
|
|
|
June 23rd, 2009 01:34 PM
by dhstein
|
2 |
108 |