|
|
Show all formulae by
karrie
I just had a query on the show formula shortcut on excel. I'm trying to show
all the formulae for a sheet, but using the Ctrl + ` only seems to show me
the...
|
|
3 |
145 |
|
|
Excel 2003 cannot enter product key!! by
microsoft exchange server help![_2_]
The computer that i originally uploaded 2003 Office went kaput. I uploaded
it to my new cpu, which runs on vista, and am not able to enter my product
key. ...
|
|
3 |
193 |
|
|
Personal.xls Will Not Hide by
Trying to Understand
Has anyone ever heard of a personal.xls file that refuses to hide? I have a
user whose file will not stay hidden. It closes instead.
( 1 2)
|
|
10 |
309 |
|
|
Formatting a cell - remove a dash by
Shawna
Hello and please help. I need to know how to change the following number in
my cell from 1234-5678 to read as 12345678. Basically I want to remove the -...
|
October 7th, 2009 08:49 PM
by Shawna
|
4 |
194 |
|
|
Autofit single cell text by
Jay
I am trying to autofit rows, all of which one column has cells that contain
anywhere from 0 - 1500 characters. No cells are merged on the worksheet. Each
of...
|
|
3 |
148 |
|
|
|
|
1 |
146 |
|
|
|
|
1 |
149 |
|
|
copy outlined data in excel by
cathyh
in excel 2007 (or any version) - if i create an auto outline on a block of
data. then take it down to a level 2 both rows and columns. can i then copy
just...
|
October 7th, 2009 08:14 PM
by Eduardo
|
1 |
124 |
|
|
|
October 7th, 2009 08:12 PM
by Eduardo
|
1 |
131 |
|
|
Insert Rows vs SUM() and SUBTOTAL() by
TKS_Mark
Consider a column of numbers followed directly by a SUM() of those same
numbers. When you insert a new row between the last number and the sum()
cell, the...
|
|
0 |
165 |
|
|
|
October 7th, 2009 07:20 PM
by Mike H
|
1 |
148 |
|
|
draw shapes in excel using the keyboard by
abslv
I am trying to draw shapes in a worksheet without using the mouse. Use of
the keytips to get through the insertion of a shape (such as a rectangle)
work...
|
October 7th, 2009 06:54 PM
by Bob I
|
1 |
178 |
|
|
|
|
2 |
170 |
|
|
Worksheets by
Scandy
When I open my (excel 2007) spreadsheets, the file opens, but the page is
blank. The message I keep getting is:
"Windows cannot find blah, blah,...
|
|
1 |
134 |
|
|
operating over a range in an array by
ghengis_na'an
I have a two column array, let's call the values in these columns X and Y. I
want to perform a function (e.g. average, sum, etc.) on the Y values from a...
|
|
1 |
124 |
|
|
Postcode structure for data validation by
JohnG
Hi
I'm trying to apply data validation to a cell that is in line with common
postcode structures. I thought there was a way of dictating an entry had to
be a...
|
|
3 |
153 |
|
|
Complicated conditional formatting by
IanC
I have a complicated set of conditions I need conditional formatting for.
I have the following 2 sets of formulae which work independently
Set 1
Formula 1...
|
October 7th, 2009 05:52 PM
by IanC
|
0 |
188 |
|
|
Convert hours to minutes by
Emece
I have a column with the following format: 01:10:22 (hours, minutes,
seconds), and want to know to how much minutes this corresponds.
Which is the operation...
|
October 7th, 2009 05:25 PM
by Mike H
|
2 |
144 |
|
|
Variable Combinations by
S. Casey
Hi,
I have a set of engine run data for 4 engines. Different engines are on at
different times and I want to know a common value, say the blended oil temp
if...
|
|
1 |
119 |
|
|
how do I paste or import without parsing?? by
meltemi
I think I'm using Excel 2007, but I'm not sure because they hid the "Help
About" menu. There's a question mark icon at the upper right that leads to
online...
|
|
3 |
147 |