|
|
Automatic Row and column sizing by
-Bryan[_2_]
I have created a form that I would like to easily add more sheets that are
exactly like the main form, so that I can quickly adjust the form to fit the
size...
|
|
0 |
108 |
|
|
Changing font color when goal is reached by
-Bryan[_2_]
I have created a form to track moisture content in a material. Depending upon
the material, a different standard is set, and when the moisture content...
|
|
5 |
125 |
|
|
Reference for formulas and arguments by
-Bryan[_2_]
Is there a reference on the web about formulas and arguments? Possibly that
can help with a little more complex formulas, tables, charts, arguments,
etc.?...
|
|
2 |
193 |
|
|
Arrowing through cells... by
-Carlos
Somehow it got turned off. When I hit the arrows on my laptop, instead of
moving from cell to cell, the entire table moves left, right, up, or down.
Does...
|
|
1 |
97 |
|
|
|
|
0 |
112 |
|
|
find and replace for date format by
-D-
I need to reformat dates within two columns. Currently, I have dates
formatted like this:
1/22-1/28 (a starting and ending date)
I've broken this date out...
|
January 23rd, 2007 06:32 PM
by -D-
|
0 |
132 |
|
|
Get to Combo Box without mouse by
-debi-[_2_]
Good Day,
Is there a way to get to a Combo Box without using the mouse? The user
wants to enter data, but use the tab or enter key to move through the sheet...
|
|
0 |
126 |
|
|
|
December 5th, 2007 07:18 PM
by Bob I
|
1 |
87 |
|
|
Should be easy...Auto Date Fill by
-emma-
Hey,
This should be easy but I have been struggling with it for a while
now.
A1 = A Validation List with the options "Y" or "N".
A2 = The date (dd/mm/yyyy)...
|
|
5 |
88 |
|
|
|
October 31st, 2006 01:16 PM
by Jim May
|
4 |
97 |
|
|
Formula Help by
-Julie[_2_]
I need help creating a formula, please. If column a contains today() and
column b contains dates and column c contains a number, I want the formula to
look...
|
June 11th, 2009 07:03 PM
by Max
|
3 |
104 |
|
|
create price list from excel sheet by
-keevill-
I have been using Excel 2003 to manage a list of approximately 200 items.
This is a very simple list comprising of four or five fields one of which is
the...
|
|
1 |
102 |
|
|
|
|
3 |
115 |
|
|
sort name records according to criteria by
-keevill-[_3_]
I have sheet of names and addresses but some of the rows do not have the
name title ( Mr / Mrs ) . i.e they only have the name J. Doe instead of Mr
J. Doe
I...
|
July 20th, 2008 02:02 PM
by Wigi
|
3 |
164 |
|
|
beginner question re =PROPER(A1) command by
-keevill-[_3_]
I have a list of names and addresses in columns and have used the
=PROPER(A1) command to change the allcaps columns to be correctly
capitalised words...
|
|
5 |
177 |
|
|
getting address labels into Excel by
-keevill-[_3_]
My task is to get a bunch of address labels which are already printed, into
an excel sheet .
I have scanned a number A4 sheets each of which contain name and...
|
|
0 |
105 |
|
|
removing incomplete entries in Excel sheet by
-keevill-[_3_]
I have an excel sheet containing rows of names and addresses .
How can I filter and remove the entries which are incomplete such as ones
with a forename...
|
|
3 |
170 |
|
|
|
|
2 |
117 |
|
|
Unhiding multiple sheets at a time by
-maverick-
We can possibly hide several worksheets at a time, but is it also possible to
select several hidden worksheets and unhide them all at the same time?
|
|
1 |
94 |
|
|
Excel 2000 Chart Y-Axis Scale break by
-PJ
I have a mixed bar/line chart where most of the data is in lower numbers
(none higher than 55,000) but one set of data goes up to 110,000. This one
set causes...
|
|
1 |
153 |