|
How do I move the page breaks in Excel 2007
Please see Subject Question...
|
2 |
14.08.2006 13:08:02 |
|
|
Mileage Claim Formula
Hi,
Having a spot of bother here with a formula, what I need if any one can
help is the following
Sum of a number of fields and IF that SUM is > than 10000 then * by
0.25
This a mileage workout and it's pulling my hair out.
Thanks in Advance
John
--
johndavies
------------------------------------------------------------------------
johndavies's Profile: http://www.excelforum....
|
5 |
14.08.2006 08:24:26 |
|
|
How do I delete words I have added to CUSTOM.DIC?
Two questions:-
(1) I have no problem adding words to the custom dictionary. But I don't
know how to find them and delete them afterwards. I tried tools>options
etc. No luck.
(2) What is an alternative method of adding words to custom.dic other than
typing the word in a cell and click spelling to invoke the spelling dialogue
box. Tool>options>spelling won't give me the dia...
|
5 |
14.08.2006 01:40:19 |
|
|
Roster / Staff Allocation
Hey All
Just wondering if on ur travel's if you have come across, a template
that could be used when rostering and allocating staff within either a
retail (Checkout operators) or a aged care facility.
Any assistanced would be greatful.
Thanks
Aaron
--
KingAaron
------------------------------------------------------------------------
KingAaron's Profile: http://www.excelforum.com/me...
|
5 |
14.08.2006 01:38:01 |
|
|
allow me to copy and paste in a protected worksheet
I have a password-protected worksheet. How could I copy and paste
within the same worksheet without unprotected it? Any help will be
highly appreciated! Thanks,
...
|
4 |
13.08.2006 19:11:18 |
|
|
Preventing Info From Scrolling ... Possible ??
Hi, I'm just curious to know if it is possible to have a Text Box or
other information
Not Scroll (Stay Stationary) when scrolling horizontal or vertical?
I do know about the Freeze Pane Feature but they are very limited to
Top Row
and maybe the first column which doesn't help my situation.
Is there any other method of freezing Data not to scroll without using
the Freeze Features?
Than...
|
5 |
13.08.2006 10:44:01 |
|
|
Hidden rarely used menu items
I am not sure if this is a configurable setting, or if it is whether it is
done within Excel or at a Windows level, but I want to set my Excel program
so that when I click on the menu bar all items are permanently on display,
where currently it hides rarely used items. I know that I can temporarily
view rarely used items by clicking on the down-arrow/chevron at the bottom
of the popup m...
|
3 |
13.08.2006 08:58:14 |
|
|
XL2003 and tab colours
I have started using XL2003 after some years' experience with earlier
versions. On the latest version the background colour of the worksheet tabs
is white in the case of selected (or grouped) sheets, but very very very
light grey in the case of unselected sheets. This makes it hard to see
which worksheets are selected or included in the group. Is there a way to
customise this, please?...
|
6 |
13.08.2006 07:57:31 |
|
|
Moving Shapes with the mouse
I have placed shapes on a spread sheet. I would like to write some code so
that when one or more shapes are selected and moved with the mouse, the
direction that the shape(s) can be moved is controled. For instance, the
shape(s) can only moved up and down but never left or right. Can some one
help me?...
|
1 |
13.08.2006 05:35:01 |
|
|
Counting Different Names in A Column... Formula?
Just wanted to know if there is a Formula that can count DIFFERENT
names
in a Column?
eg.
There may be more than 1 same name, but I dont want it counted twice:
James
Edward
Max
John
David
James
James
Lisa
Total should = 6 (Since James is 1 person)
Is there a formula to solve this type of count? Thanks for any help
on this..
--
Mhz
-----------------------------------...
|
3 |
13.08.2006 01:04:09 |
|
|
check marks
Is there a way to put a check in the spreadsheet?...
|
5 |
12.08.2006 21:06:01 |
|
|
How to Create a Macro to Edit a Variable Amount of Information
Hi,
I have an Excel table full of information for a certain number of
individuals. I've created a macro to reorganize, transpose, and arrange the
data that works beautifully for information for two individuals. However,
the number of individuals whose information is in the table will vary, so I
need to be able to set the macro to do these tasks regardless of the amount
of informatio...
|
5 |
12.08.2006 21:05:01 |
|
|
How to diffrentiate Text & number from a single cell????
Hi ther guyz............i a have small problem with the execl
sheets...........
my problem is e.g. i have alot of cells with a number and some text in
it........and they both are in one/single cell (e.g. "878 queen st" in
A1)....now what i want is to remove let's say "queen st" from each cell
so that there is only number left in it.....................i cannot
figure out any formula........if th...
|
3 |
12.08.2006 20:55:08 |
|
|
Carriage Return in a Concatenation
I have a serveral lines of VB that I need to Concatate, I have them in
seperate columns b/c a few aspects will change. Currently my
Concatenation looks like =H2&I2&J2&K2, I need a carriage return between
&, I can get this result by putting each row colum on a seperate row,
but that is not really feasiable, I know that there has to be a better
way, any suggestions?
...
|
5 |
12.08.2006 16:12:39 |
|
|
how to set up a worksheet for unlimited entries?
I need to set up an excel worksheet where the data in the "Cost" column
is added up to show "Total Cost" at the bottom of the column. I can do
this very easily for a static range but the "cost" column is not
static, it will keep on growing. How do I write a formula for "Total
Cost" which will be aware of how many entries exist in the column so
they can be added up. Also, I was going to have "tota...
|
3 |
12.08.2006 15:16:20 |
|
|
Save options
Do anybody know all the available save options in Excel.If not I
recommend this post
http://xlmaster.blogspot.com
...
|
1 |
12.08.2006 12:30:29 |
|
|
Why must the table for Vlookup be sorted in ascending order?
Is it true that under all circumstances I must sort the array table in
**ascending** order so that VLOOKUP will return the proper values? Is it
only necessary when I deal with ranges, say minimum score and a grade?
Appreciate explanation.
I have a column of scores and a corresponding column of grades. e.g. 90 A
80 B 70 C 60 D
I am surprised that if the table is in **descending** o...
|
4 |
12.08.2006 07:04:17 |
|
|
What are the shortcut keys for "0.00"
How do I apply the general number format "0.00" to the selection using
shortcut keys?
Can't find it via the help feature.
Thanks.
Epinn
...
|
7 |
12.08.2006 02:13:52 |
|
|
How to format cells for uppercase entry
I need to format a column so that all cell force any text entry to
uppercase. I've looked into the UPPER() function, but that is something that
would actually take the value from some otther location and display it in
uppercase where the fuction is located, which will not work.
What I'm looking for is something similar to Format->Cells->Numbers, which
allows you to define a format...
|
4 |
12.08.2006 02:05:14 |
|
|
Help with Excel
I am working on a song list with selection numbers and disc numbers ..When I
enter the selection number or disc number it changes to a DATE!! How do I
change this. I'm new to excel
Thanks
Arlene...
|
3 |
11.08.2006 23:57:38 |
|
|
Centimeters to inches formula!
Is there a formula for converting centimeters into inches? I am really
new at excel so I do not know ? Any help would be appreciated. Thank
you.
--
rageon75
------------------------------------------------------------------------
rageon75's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31862
View this thread: http://www.excelforum.com/showthread.php?threadid=570955
...
|
7 |
11.08.2006 23:55:40 |
|
|
faster way of data entry
I would like to learn how to enter data on excel faster. I have a large
datasheet, my samples are in "rows" while the tests are in "columns". The
samples are arranged in numerical order but when I'm testing them, I group
them into fixed groups of around 90-100 members. The members of these groups
are randomly arranged. I get my result one group at a time. And I conduct
different tests on...
|
4 |
11.08.2006 23:17:51 |
|
|
how can I use the format painter??
when I try to used format painter it only copies the color of the cell,
However it does not copie the words, how can I do it?...
|
2 |
11.08.2006 22:56:31 |
|
|
Please Help
Hi there
I may have done a really stupid thing I have a job interview on
Wednesday where I will need to show that I can use excel. The main
problem with this is that I can't.
If anyone could help me I need to find out how to create an address
list in excel so I can transfer it into Microsoft Word to create a mail
merge. This is probably really easy and any help would be of much help
and pr...
|
3 |
11.08.2006 21:26:09 |
|
|
need help with invoicing
I do construction, and I have all my invoices on my computer in excel. Is
there a way to import the job totals and labor into another worksheet. from
all my invoices I have and will have in the future?...
|
2 |
11.08.2006 21:06:27 |