|
|
Action button by
Davey
How do I insert an action button which will move me from one worksheet to the
next?
|
|
1 |
120 |
|
|
|
|
1 |
152 |
|
|
Nested IF statement by
WIJ
Hi all,
This is the first time I have posted on here.. I am trying to make up the
following nested IF staement (I am drawing alot of information from a...
|
October 27th, 2009 05:39 AM
by WIJ
|
3 |
150 |
|
|
|
|
1 |
120 |
|
|
|
|
2 |
161 |
|
|
Strikethough in cells? by
Bob Newman
Excel 2007
When I enter information (text or numbers) into some cells it enters with a
line down through it (like editing in Word). I don't know why this is...
|
|
4 |
182 |
|
|
Find the first letter in a cell by
Corne
In one column I have a text contaning numbers and letters e.g.:
10S1
143W1
1A9
etc.
I want a second column containing only the first letter of these text....
|
|
5 |
141 |
|
|
Excel 2007 AutoFilter problem by
Sarah H.
Hi, all,
I recently started using Excel 2007 after having used older versions for
many years.
I am having a baffling issue with AutoFilters. I turn on...
( 1 2)
|
|
16 |
314 |
|
|
First page number by
Betti Punnett
My first spreadsheet has 61 pages.
My second (with different heading) has 42 pages. I want my second spreadsheet to start at page 62. I follow all instructions...
|
|
2 |
156 |
|
|
|
|
3 |
109 |
|
|
=LOOKUP(100^10,D:D) by
Gilbert
Can someone explain the above formula please?
Thank you in advance
|
|
2 |
117 |
|
|
|
|
2 |
123 |
|
|
sum only certain figures in the column by
Jack B
Re Excel 97 --------
I want to SUM only the figures in J20:80 (put sum in J81) that do not have a
blank corresponding cell in K20:80, but I can't figure out...
|
|
2 |
125 |
|
|
Excel 2007 "Office Button" by
lucy_o
When I remote access my work computer fropm home, the "office Button" feature
will not work. Is there some kind of security setting that causes this to...
|
October 26th, 2009 11:10 PM
by lucy_o
|
0 |
115 |
|
|
Filter Question by
Vic
My filter is no longer showing total number of records in the left bottom
corner (excel 2003). What should be done to restore that function?
Thank you.
|
|
2 |
97 |
|
|
Check Register Balance by
Janet
How do I show a check register balance which changes with each entry in a
designated single cell so I can easily link it to another document?
--
Janet
|
|
8 |
146 |
|
|
Formual to have Max $ amount by
Carrie
Good Afternoon,
Currently I have this formula:
=SUM(B6:G6)*(0.173)
But I don't want the caluculation to exceed $711.03
Help
( 1 2)
|
|
14 |
200 |
|
|
Hyperlink from html to specific worksheet by
WayneO
We have html files with links in them that open an Excel document and goes to
a specific worksheet. Since upgrading to Office 2007 we now find that the
link...
|
October 26th, 2009 10:46 PM
by WayneO
|
0 |
110 |
|
|
Linking Zip codes and Cities by
Lycean
I'm trying to create a customer database. I want to be able to type the city
and have it auto-fill the next cell with the ZIP code. I don't know much
about...
|
|
4 |
111 |
|
|
Excel Column labels show as numbers by
mrudnet
I am working in Excel 2007 and suddenly the columns are showing as numbers
and not the usual letters (A, B, C...). How do I change this back? Thanks.
|
|
2 |
131 |