how do I insert column headings or labels without using a row?
"column headings" <column firstname.lastname@example.org> wrote in
You don't. Excel has plenty of rows - using just one isn't a problem!
Thanks.. But then the row numbering is "taken up" by the title and the
"first" row of data is numbered 2. Is there a way to avoid this? Also, how do
I designate this first row as a "Column Heading" so that it reprints on every
> "column headings" <column headings@discuss...how can i save mail a folder column view?
i have to open each mail address folder (using multiple email addresses and
sub folders) everytime i start outlook--how can i save a current folder view
as the default with all folders opened?
...filtering columns-left nav
I am trying to locate the functionality for the filtering of columns on the
left hand side of the screen within the nav area - that allows for totals to
be displayed and summed based on the set markers.
...Table relationships and lookups
Hi guys, I may be a little over my head, I've had some experience in
creating simple access db's. however this one will be extremely
complicated as far as I can tell. Some backround info - i've got an
excel spreadsheet currently that i would like to convert to Access.
The spreadsheet does multiple lookups and calucations.
This is for a Soccer club that i run to maintain roster information,
dollars, scheduling and stats. I'm currently working on the
scheduling pience. Here's what I have so far.
Club - Lists the teams in the club, home field name and ...Renaming columns #2
I'd like to rename the A B C D at the top to the name of my columns, o
at least leave the column headings at the top of my screen.
Does anyone know how
Message posted from http://www.ExcelForum.com
Tools>Options>View, uncheck "Row and column headers".
You can insert a row and a column with your own names, but they will not be
recognized in formulas the same way as "A1". But you can define row and
column names and use the intersection as an address in a formula. The
intersection operator is a space. So if you defined the name "Material" for
column ...Invoice lookup by paid check number
I frequently have vendors call me asking for information about what invoices
were paid by a check number. Is ther an easy way to look this information up?
You could go to Inquiry>Purchasing>Transactions by Document, put your check
number in the 'from' and 'to' fields. Once the document is displayed in the
scrolling window zoom back on the 'Unapplied Amount' field. Viola! the
documents paid by the selected payment are listed. Unfortunately there isn't
a print icon on this inquiry window, but I think it's the information you
&quo...Catagorize Column Data by Name
I have a portfolio spreadsheet with approx 100-200 rows where each row
depicts a unique project and each column depicts a calendar week. The cells
in each row are color coordinated to illustrate the phases of the project.
(For instance, I could have 3 consecutive tan cells illustrating analysis, 5
consecutive "no fill" cells depicting development, and 4 gray cells
indicating testing. It is actually a bit more colorful but I will keep it
simple for now!) In each cell there is a numeric value describing how many
projected resource hours are to be applied to that phase for th...Lookup
Q102 Q202 Q302 Q402 Q103 Q203
How can I lookup the Q103 in the row above and then have
it pull the number to the right one cell (Q203)? thanks
If I understand correctly
where q103 is in a1
and q102-q203 is in a2-f2
>Q102 Q202 Q302 Q402 Q103 Q203
>How can I lookup the Q103 in the row above and then have
>it pull the number to the right one cell (Q203)? thanks
> Q102 Q202 Q302 Q402 Q...Help with LOOKUP function
This function is in a workbook with 2 sheets. It _almost_ works
perfectly. These "C" columns in two different sheets
'2005-2006'!C:C,'2004-2005'!C:C, contain names of people. The D column
in one of the sheets - '2004-2005'!D:D - contains a date associated
with the person's name from the C column of 2004-2005 sheet.
This formula is in the "D" column of Sheet 2005-2006.
The concept is for the formula to lookup the value (person's name) in
column C of 2005-2006 a...rows & columns height & width
Is there a way of forcing the row height and column width to be equal , and
to remain equal, so that all cells are square ?
Here are a few of the results from a Google search with "Excel square cells"
A Google with 'free graph paper' also gets some useful results
Microsoft Excel MVP
"KRK" <...how to stop repeating a number in worksheet(e.g. cell A1 is 6655 .
I want to to know I can stop a number to repeat in excel worksheet. (e.g.
cell A1 is 6655 so 6655 should not repeat inwhere in the worksheet of even if
it appears there could be a pop up massage says number repeated in cell# A1)
You can use data validation to prevent duplicates. There are
And to include a message, add an error alert or input message:
Mushtaque Parker wrote:
> I want to to know I can stop a number to repeat in excel worksheet. (e.g.
> cell A1 is 6655 s...Sum a column that meets two criteria
I need to sum a column of numbers if it matches two different criteria.
I can set up the SUMIF easily for meeting one criteria, but I need to
also sum the column if it meets that criteria, and another. For
A B C
1 150 ABC MS1
2 200 DEF MS0
3 100 LMN MS0
4 125 ABC MS1
5 175 LMN MS1
6 225 DEF MS0
I need to have a formula that would say <<Sum column A IF column B =
"DEF" AND column C = "MS0">>. (and so forth for the other
I know there has to be a way to do this, probably using a combination
of an IF and SUMIF functions - but i keep...HELP! Worksheet Problem
I have a workbook containing 6 worksheets being Nov 01,
Feb 02, May 02, Aug 02, Nov 02 and Jan 03.
Each worksheet contains details of loans on these dates to
clients. Each client has a unique ID number and is in its
own row with columns A-I being ID, Prefix, First Name
through to post code etc and column J being the loan
The first worksheet (Nov 01) contains 76 clients, the
second (Feb 02) contains 189, (May 02) = 297, Aug 02 =
345, Nov 02 = 342 and the last (Jan 03) contains 350
I need a way to import all the details of the clients from
each worksheet to a ...A Lookup function does not work
Hi, This is my first posting.
I am using Exel 2000. I have 2 separate spreadsheets that have some
similar columns but not all of the data in the similar columns is the
What I want to do is take column A in spreadsheet#1 and find this same
value in Column B in Spreadsheet#2 and then insert into column 3 in
spreadsheet #1 a value from a different column in spreasheet #2 that
corresponds to the row in which the value was looked up in Column B in
What I am doing is comparing 2 different inventory files that have
stock codes in columns and quantities in another column, but n...return cell reference in a table based upon given lookup criteria
Is there a way to return the cell reference, or column/row coordinates,
of a cell within an array or table by providing lookup criteria?
Perhaps something like this:
For a table of value in A1:E10
F1: (the value to find)
Note: Commit that array formula by holding down the [Ctrl][Shift] keys and
That formula returns the address of the 1st cell containing the value in F1,
or #VALUE! if there is no match.
Am I on the right track here?
"Travis" ...Summing only values in visible columns, not in hidden columns
I need to write a SUM function that will add up several cells in a row (for
example, A4:S4) - but I only want it to add up the values in those columns
that are visible, not the values in those columns that are hidden. Is there
any way to add only values in the visible columns and not the hidden ones?
see your other post
"BW" <BW@discussions.microsoft.com> schrieb im Newsbeitrag
> I need to write a SUM function that will add up several cells in a
Is there any way to make an advanced lookup the default lookup? so you don't
have to always choose that option when doing a lookup?
Thanks for any help.
Advanced lookups ARE the default unless you've done something to make it now
so. There isn't any way to "choose" the option when doing a lookup that I
know of unless you have some type of customization (easy to do) that would
give the user an option.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tracey D" <...How to make a single column grow?
How do I make a single column, for grading, that grows from zero to one
hundred as the student enters the grade they achieved on each assignment?
...Controlling hyphenated words in columns.
Is there a way to set up linked columns so that words don't hyphenate? I
have tried spacing, reducing font by a half point and adjusting the size of
the column but it seems like a lot of work to set it up, then when printing
sometimes the layout changes again.
Tools, language, hyphenation.
Or if you want the hyphenation turned off for this and all future publications,
tools, options, edit tab.
Mary Sauer MSFT MVP
"misskitty" <email@example.com> wrote in message
ne...How to migrate the data from one server to another server
I wants to transfer all the data, setting from one CRM server to another CRM
Both versions are CRM 3.0
How can I do so ?
Microsoft CRM Redeployment is the best option.
It is located in the CRM Server CD folder: \RedeploymentTool
It also contains good instructions.
Frank Lee, Microsoft CRM MVP
"Hughs Man" wrote:
> I wants to transfer all the data, setting from one CRM server to another CRM
> Both versions are CRM 3.0
> How can I do so ?
Just keep in mind that with the ...how do i move columns on one sheet to columns on another sheet
I have sheet one which is column "A" student's name columns "B thru K" are a
point system in each column (by 3 points either a score of 1, 2 or 3).
Column "L" is the total points summed across "B" thru "K". (a total of no
more than 30).
Sheet 2 is 5 columns with each column being worth 6 points. Column "A" is
25 thru 30 points, column "B" is 19 thru 24 points, column "C" is 13 thru 18
points, column "D" is 7 thru 12 points and column "E" is 0 thru 6 ponts.
I need column ...Calling employee lookup from button through VBA code
Can anyone show me how to call an existing GP employee lookup from a button
of a modified form through VBA code.
Thanks in advance.
If I'm understanding the question - you need to add the lookup button to
your project and make sure your project provides that it runs on the modified
> Dear All,
> Can anyone show me how to call an existing GP employee lookup from a button
> of a modified form through VBA code.
> Thanks in advance.
As per...Limiting a column to certain values
I have a table that contains PLSS information and want to restrict the
columns to certain values. Since there is a pattern in what they are
restricted to, I wonder if there would be an easier way than to create a
lookup table and use a constraint.
For instance, my values for one field is limited to 3 characters: from
01-49, with the third character always an 'E' or 'W'
Would this be easier done in a query or stored procedure or function than to
create a lookup table?
Thanks for your help.
In the case you describe you can use a CHECK constraint:
CR...Getting Sheets Copied From One Workbook to Another Without ....?
Hello, I have a situation where I want to move 3 sheets from on
workbook to another. The Problem is that the sheets appears to carr
their File Path with them creating a Problem for my formulas within th
Is there a way to keep the Formulas in tact to represent th
The Workbooks have the same Data, but 3 sheets from the source workboo
need to be inserted in the destination workbook without paths in th
formulas leading back to the source workbook (file).
Source workbook sheet1 A1 Reads:
When it is copied ...spliting a column of data into multiple columns
I am trying to split up some data into multiple columns with part of the data
in each column... ie: 02-34-5-M is currently in one column... i need it
split into 4 columns as the following....
02 34 5 M
01 256 0 Q
7 45 4 T
This needs to be done so I can sort by using the 2nd set of numbers.
Currently, this is an Excel file.
Thanks in advance for your help.
"CiceroCF" <CiceroCF@discussions.microsoft.com> wrote in message