|
|
Autosizing labels in Excel 97 by
Striker475
Can you? And if so, how?
--
Striker475
------------------------------------------------------------------------
Striker475's Profile:...
|
|
5 |
142 |
|
|
|
|
3 |
137 |
|
|
Page Breaks by
Me2Ewe
Can someone tell me how I can get the page breaks to stay checked. Is there
a registry setting or group policy setting? I have searched but missed...
|
|
1 |
125 |
|
|
Protect cell formulae by
Harry Limey
Is it possible to prevent a cell from being written in? I want it to show
the results of data written elsewhere.
|
|
2 |
115 |
|
|
|
November 10th, 2005 01:39 PM
by bpeltzer
|
3 |
113 |
|
|
how to do % of cells with data by
matthewst
My sheet looks like this:
_ABCDEF____
1x_x_______
2x_x_______
3x_x_______
4x_x_______
5x_________
6x_________
7x_________
8x_________
|
|
6 |
130 |
|
|
How can I do this? by
flinee
Hi I am not a constant user of Excel. I had a need so I gave it a shot.
I just opened the program and started to mess around, then I read some,
then I started...
|
November 10th, 2005 04:26 AM
by Max
|
1 |
141 |
|
|
Data searching between sheets by
YJL
I want to make language libruary where I can retrieve all my past
entries in tow different sheets. When I type keywords into the
self-made searching box, the...
|
|
1 |
166 |
|
|
Dividing and Rounding by
puppypants
HELP!! I'm still kinda new to Excel and all the wonders of formulas...I
need to create a formula that will take the dollar value of one cell,
divide it by...
|
|
6 |
232 |
|
|
Convert weekno to a date by
Box666
I have a week no. (say week 2) in cell A4 and I want to convert that
to the Fiday of that week (in cell B7) in the format Fri 14th Jan 2005.
Could anybody...
|
|
1 |
112 |
|
|
|
|
2 |
134 |
|
|
VLOOKUP with PRODUCT functionality? by
J
i am wondering if it is possible to do a vlookup() type search for multiple
instances of something, and then multiply the results together. for example,
i...
|
November 9th, 2005 07:46 AM
by J
|
2 |
81 |
|
|
|
|
0 |
147 |
|
|
|
|
1 |
132 |
|
|
Restricted permissions by
Marc
I created documents in exel and now they are all shown with restricted
permission.
I don't know how it this happened how can I get rid of this.
|
November 8th, 2005 03:37 PM
by Mike
|
1 |
161 |
|
|
Counting different colums by
gadget
I am using this and it works perfectly:
=COUNTIF('Issues Registered'!(P:P,"yes")
But I want it to look in another column as well (Count "Yes" in column
P and...
|
|
1 |
98 |
|
|
Using mouse wheel in VB editor by
fullers
Just tried using the mouse wheel to scroll within visual basic editor in
excel but it wont let me. How can I turn this feature on. I am using...
|
|
2 |
242 |
|
|
Determine columns used by
Jane Wee
I have 100+ spreadsheets which i have to edit into a certain format. The
spreadsheets currently have 100 columns (from 1-100). From there i have to
reduce the...
|
November 8th, 2005 05:13 AM
by Max
|
3 |
201 |
|
|
Date vs h:mm:ss confusion by
Barry
I have a table of approx 120 cells which contain what is supposed to be a
number of hours:mins:secs but in the formula bar a date and time is shown.
Example -...
|
|
2 |
236 |
|
|
|
|
8 |
106 |