|
|
scroll function speed by
David McRitchie
Hi Carrera,
Try holding the shift key while dragging the scroll bar, it will be
more consistent in speed.
Another way to get to a location is to type the...
|
|
0 |
1,076 |
|
|
conditonal formating by
Zoef
hi,
I have a sheet like a calendar and I would like to highlight the row
coresponding of the current date.
I only manage to highlight the date itself with...
|
|
3 |
1,267 |
|
|
field highlight by
djranks
i have an account spreadsheet. with a column heading reading status.
How can i tell excel to highlight all cells containing status "I" for
inactive in red, and...
|
|
3 |
1,093 |
|
|
numbering rows by
jane
Is there a way to number each row in Excel so that when
it prints out the rows all have numbers? I couldn't find
it in Msft online Help but I guess that's no...
|
|
2 |
1,028 |
|
|
Changing a group of entries by
Peter
Hello,
I am using Excel 97. I am not an advance user by any means.
If I have a spreadsheet with numeric entries, is it possible to apply a same
mathematical...
|
April 24th, 2004 03:25 AM
by Peter
|
2 |
1,283 |
|
|
strange recurring problem by
steven
When I save a file in Excel or for that matter Word, I am
unable to open the file(s). I get a prompt saying that 'my
virus scanner has detected a problem with...
|
|
1 |
1,126 |
|
|
rounding by
tjtjjtjt
If you are always rounding down, you might check FLOOR as well. It's syntax is, in my opinion, easier to work with than ROUNDDOWN.
tj
|
|
0 |
1,025 |
|
|
Leading Zeroes by
alex robkin
if you create the csv file with ="00300",This will display initial zeros!!!
include the equal signs surrounded by quotes....
|
|
5 |
1,222 |
|
|
Total calculation out by .2 by
S Findlay
Hi, having trouble have one column of figures produced by formula when I total up at the bottom of the sheet they are out by .02 do not know how to solve this...
|
April 24th, 2004 07:23 PM
by RagDyeR
|
4 |
1,279 |
|
|
|
|
1 |
1,185 |
|
|
|
April 26th, 2004 02:08 AM
by Ray
|
0 |
1,277 |
|
|
add sheets by
-----Original Message-----
ho do i add more sheets to the "CURRENT" workbook,, not
new workbook
.
Click first on Insert then click worksheet.
BEST...
|
April 26th, 2004 03:25 AM
by
|
0 |
1,053 |
|
|
Lock group of rows for printing purposes by
Benjamin
I'm setting up a grid with client names, addresses, phone numbers, etc. Some of the information for each client takes up two rows, others three or four. If I...
|
|
2 |
1,111 |
|
|
|
|
2 |
1,267 |
|
|
creating a resource appendix by
Trainee
Hi, I'm trying to create an appendix for a lot of resource
information. Having trouble with the text and alligning
the columns. Also, I want the grid lines to...
|
|
1 |
1,052 |
|
|
|
|
0 |
1,107 |
|
|
how to make a budget by
spazpup02
:( My husband owns a propane business and wants me to build a budget for
our customers. Can anyone tell me how to go about doing this?? I was
told Excel...
|
April 26th, 2004 09:53 PM
by gls858
|
1 |
1,250 |
|
|
Circular reference error by
Linda
Hi Guys,
Using Excel 2000. I have a workbook that is already saved. When I open the
workbook I get this error.
MS Excel cannot calculate a formula. There...
|
April 27th, 2004 04:09 AM
by Linda
|
3 |
1,293 |
|
|
Finding maximum value by
Ruan
Hello,
I want to find the maximum value in a column, but I want to ignore the
negative and positive part of the value. Basically, the maximum difference
from...
|
|
3 |
805 |
|
|
Find & Replace in XP by
Jane
XP now has the ability to do a find & replace based on
formatting, but i ran across an issue. If I type the word
accountant in cell A1 and "accountants are...
|
|
3 |
810 |