columns #3

How do I re-name the columns for A, B, C, etc... to what I want-  I am trying 
to make a guest list and need to change the column names. 

Please help me 
0
Melisa (3)
4/27/2007 9:16:01 PM
excel.newusers 15348 articles. 2 followers. Follow

3 Replies
849 Views

Similar Articles

[PageSpeed] 37

That ability does not exist in XL.

In article <ECC6FF32-BFA6-4722-8AA3-8897B1BDE3E3@microsoft.com>,
 Melisa <Melisa@discussions.microsoft.com> wrote:

> How do I re-name the columns for A, B, C, etc... to what I want-  I am trying 
> to make a guest list and need to change the column names. 
> 
> Please help me
0
jemcgimpsey (6723)
4/27/2007 9:21:26 PM
A workaround since you cannot change the letters as JE points out.

Use row 1 for your titles then select A2 and Window>Freeze Panes so row 1 is
always in view.

Tools>Options>View.  Uncheck Row and Column Headers if you don't want to see
them.


Gord Dibben  MS Excel MVP

On Fri, 27 Apr 2007 14:16:01 -0700, Melisa <Melisa@discussions.microsoft.com>
wrote:

>How do I re-name the columns for A, B, C, etc... to what I want-  I am trying 
>to make a guest list and need to change the column names. 
>
>Please help me 

0
Gord
4/27/2007 9:37:06 PM
Place your Column Names in Row 1, then start your data in Row 2.  The (A, B, 
C...) names cannot be customized.

HTH,
Elkar


"Melisa" wrote:

> How do I re-name the columns for A, B, C, etc... to what I want-  I am trying 
> to make a guest list and need to change the column names. 
> 
> Please help me 
0
Elkar (111)
4/27/2007 9:38:01 PM
Reply:

Similar Artilces:

Autofit Row Height #3
Hello, I have a column on sheet 1 that is set to wrap text so that the row height increases and decreases as more text is entered into the cell. This works fine. Users enter a number on sheet two where there is a lookup function that returns the appropriate text from sheet 1. The problem is that when the text is returned by the function, the row height does not adjust to fully display all of the text in the cell. Is there a way of automating this? Any help would be appreciated. -- Thanks, MarkN ...

RMS Troubleshooting and Basic Set up v4/3/2005
http://www.simonajewelry.com/rms.aspx I have decided to post the information on the net because ms newsgroup does not have a long message retention. Natt ...

Converting Crystal report from MSCRM 1.2
I have a client who has upgraded to V3.0 for CRM. They want to continue using Crystal for their reporting engine because they have 40 custom reports. Does anyone know how to easily accomplish this? I have created a new connection to the new CRM Views in SQL, but I can't seem to figure out how to easily replace all the fields that are currently in the report using the SSO connection to my new connection. Any help would be greatly appreciated. Thanks, Amy many of the services such as rpttosql.com say they will only convert so far. some even say they will only get the general lay...

columns in RMSSO
Hi There, Is it possible to change the columns on the forms ?? For example: Receiving po contains: Type, Item Lookup Code, Reorder Number, Description, OtyOrd, QtyRTD, QtyRcv, Cost, Price, NewPrice, Extended We need: Item Lookup Code, Description, MPQ, Price, BinLocation We need to modify few other forms as well. I think I've seen that in one of the add-ons while ago, but I cant remember which one was it and I'm not 100% sure if I really did. Thanks, Arthur ...

Reference column question
Setting up a tabulation speadsheet,has 40 rows and 10 columns.Question is when I do my formula which is a subtraction for each column,I want to use a refernce # from the first row of each column =Sum(F1-D3)=SUM (G1-D3)and so to=Sum(P1-D3)Rather than enter each manually,because cut and paste adds 1 to each column how can I get to use f1 as reference for that column G1 for that column.Thanx If I understand correctly, try putting a $ in front of the row reference. Also, sum is not necessary for what you are doing. =F$1-D3 as you copy that down it becomes =F$1-D4 copied across to the ri...

Protection Problem #3
I have a 3 sheet excel file with protection on all 3 sheets (let's call them A, B and C). These 3 pages have formulas that link to each other. Sheet A has a few checkboxes that link to sheet C. The problem is that when I try to check any of the check boxes on sheet A an error box pops up that says "The cell or chart you are trying to change is protected and therefore read only". Is there a way to protect a sheet while being able to check a box off that is linked to another sheet? What protection options would allow me to do this? Thanks in advance. Dave -- Dave123 ----------...

Wild curser #3
DNA Wrote: > Your scroll lock isn't on ... is it? No, it isn't- thanks! I've tried putting it on and off a few times just to double check. -- Jo3 ...

All Columns are not to move
How can I stop the columns from moving to the left of the Table? -- Roger On Sun, 3 Feb 2008 17:28:39 -0800, Roger <Roger@discussions.microsoft.com> wrote: >How can I stop the columns from moving to the left of the Table? You'll have to explain what on Earth you're talking about, Roger. What columns are "moving"? How? John W. Vinson [MVP] Good evening John, I found my own answer:by bringing the cursor to the first cell, the first column will not scroll to the left anymore; however, when I bring the cursor to any other cell and scroll to the rig...

sending attachments #3
I downloaded all the security updates for Outlook 2000. Now Outlook can't send attachments. The attachments appear in the "send" directory, but the receiver of the email gets no attachments. Hi Stu, The Outlook security feature blocks attachments that are potentially unsafe. This security feature provides an additional level of protection against malicious messages. Although Outlook 2000 SR-1 or Outlook 2000 SR-1a blocks access to the attachment, the attachment still exists in the message. For more information on resolving this issue, please refer to Knowledge Base art...

Synchonization with SFO 3.0 performance
Hello everyone, I would like to know if the syncronization of the Sales for Outlook has better performance in release 3.0 ?? Is there a place i can find information on the way the new SFO is working ? Thank you, -- Marie-C I was meaning 'Is there a place i can find information on the way the new SFO is built' . Does it still use Cassini ? Thank you -- MC "MC" wrote: > > Hello everyone, > > I would like to know if the syncronization of the Sales for Outlook has > better performance in release 3.0 ?? > > Is there a place i can find in...

Text-To-Columns Fixed Width
When using Text-To-Columns, Excel "recognizes" that the data fits the Fixed Width criteria and PRE-assigns the width. In most of the cases I work with Excel is wrong 99% of the time. Is there a way to force Excel to NOT pre-assign the width (leave everything blank)? On the first panel of the wizard click Delimited, then on the second panel click space as the delimiter. Hope this helps. Pete On Feb 4, 12:50=A0am, TP <T...@discussions.microsoft.com> wrote: > When using Text-To-Columns, Excel "recognizes" that the data fits the Fix= ed > Width ...

How to get total "conditional sum of cells" in a column?
Hi all, I have dollar amounts in one col, and status in another. I want the sum of those dollar amounts where the corresponding status cell is empty (blank). How do I do this? Thanks for any hints, cdj Status in Column A and dollar amounts in Column B: =SUMPRODUCT((A2:A100="")*B2:B100) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk "sherifffruitfly" <sherifffruitfly@gmail.com> wrote in message news:bc08584b-1338-4b3f-8ab3-cc3e1602e581@n1g2000prb.go...

Publisher help #3
I created a website and i am able to upload it and view it in firefox but not in any version of IE. Not exactly what i did wrong. But any help would be appreciated. Thanks Astro Repost this question in microsoft.public.publisher.webdesign newsgroup and add the URL to your problem website. -- ~~~~~~~~~~~~~~~~~~ Rob Giordano Microsoft MVP Expression "Astroda" <Astroda@discussions.microsoft.com> wrote in message news:2ADC0F87-CD62-421D-8088-61541AD6117B@microsoft.com... > I created a website and i am able to upload it and view it in firefox but > not > in a...

Delivery Status Notification (Delay) #3
I have been receiveing several message stateing thet my message has been delayed. Why is this happening and is there a way to configure this so that the message does not become delayed? below is a copy of the message that i receive; This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. bsetten@microsoft.com ...

Sort column with first and last name by last name
Hello, I have a mailing list with 10,000 names. The first cell has first an last name in the same cell. First name is listed first. Is there formula to sort and/or separate text in a cell. I would like to sort o separate the first name from the last in the cell to allow for a mai merge by name. Using Excel 2002. Thank you -- Message posted from http://www.ExcelForum.com If you have just first and last names separated by a space, Data>Text to Columns would be the easiest method to split into two columns. If more than that, like names with van or von or de etc. you may need a different m...

Integration GP 8.0 with CRM 3.0
Hi. i'm newbie in GP but i have been know CRM 3.0, i want to do integration between GP and CRM using Microsoft Dynamics CRM Connector for Microsoft Dynamics GP. After all installation and configuration, the integration was work. I add an account in CRM then the account which i was added is display in GP (as customer). But why the order between GP and CRM can't integrate? I was follow the instruction in the integration guide. The guide book says that the tax details, tax schedules, shipping methods, payment terms, unit of measure, unit of measure schedules, price groups, price le...

Multiple e-mail addresses #3
When a Contact has multiple e-mail addresses, how do I set one of them as a default? Now, emails are going to ALL of their addresses. Thanks-Rose ...

Finding unique numbers in a column
Is there any way to find the number of unique values among a set o values in a column in an excel sheet. I would also like to know th number of times each value appears in the column. Thank -- coolkid39 ----------------------------------------------------------------------- coolkid397's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2431 View this thread: http://www.excelforum.com/showthread.php?threadid=37924 There was also a similar thread under Excel Worksheet functions titled "Delete duplicates". Solution provided was to use: Data>Filter&g...

POP 3
I installed SBS with sr 1 server service pack and SBS sr1 service pack and Exchange Sr2. On the same server I can browse the mailbox with internet explorer on Outlook web access when i created the same account in Outlook express on the same server when i do F5 it dose send and receive mail but it dosenot downloade messages in Outlook Express . In news:9307571B-4E3D-4535-A7D3-655ECBD94434@microsoft.com, Sarosh Tafti <SaroshTafti@discussions.microsoft.com> typed: > I installed SBS with sr 1 server service pack and SBS sr1 service > pack and Exchange Sr2. > On the same server ...

Multiple IF Functions #3
I'm new at this and am trying to put several different, unrelated IF formulas into a single cell but am having trouble with it. How do you differentiate between one formula and the next, but still have it in the same cell Is there a limit to the number of IF formulas you can put in one cell? If so, how many? Hi There is a limit of 7 nested IFs in a cell. A simple multiple IF scenario could be: =IF(A1<5,"under 5",IF(A1>5,"over 5","5")) This checks the value in A1 and gives the result in text. If the first IF returns FALSE, it continues into the next IF ...

Circular Reference Warning #3
When I open my exel file .. this pop-up open .. circular reference warning one or more formulas contain a circular reference and may not calculate correctly. circular references are any references within a formula that depend upon the results of that same formula. for example, a cell that refers to its own value or a cell that refers to another cell which depends on the original cell's value both contain circular references. for more information about understanding, finding, and removing circular references, click ok. if you wnat to create a circular reference, click cencel to cont...

Stacking columns!!!
I have columns with headings like: NAME - AGE - EXPERIENCE. I have many sheets like this and I have to import all of them into on sheet -- where all the entries are stacked one below the other. There was already an enquiry about this in this forum -- but there wa no reply. If any has a solution, it would be appreciated. thanks. Subbu :confused -- kmsubb ----------------------------------------------------------------------- kmsubbu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=844 View this thread: http://www.excelforum.com/showthread.php?threadid=276...

Help with column
I have a datafeed that comes to me everyday i need to format one column of around 1000 rows so it multiples the total column but a 1000 so getting rid of the decimal point i.e =A3100.00 becoming 10000 , i also need to do this using a macro. can anyone help=20 Regards=20 Paul Dim iLastRow As Long Dim i As Long iLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To iLastRow Cells(i, "A").Value = Cells(i, "A").Value * 100 Next i -- HTH Bob Phillips "lennymos123" <paul@palo.co.uk> wrote in message news:1115651206....

Column and Row reference
How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top and right hand side references Dave Tools>Options>View. Uncheck "row and column headers". Good idea to spend a few minutes browsing through the various Tools>Options tabs to see what else is available to toggle on/off. Gord Dibben Excel MVP On Mon, 19 Jul 2004 15:53:02 -0700, "Dave" <Dave@discussions.microsoft.com> wrote: >How do i hide the column and row reference number in a sheet, when viewing the worksheet i do not to show the top an...

Sending Email #3
I am able to receive but not send email, with the following error message: "553 authentication required" "check email properties". I can send sometimes if I go in and re-enter my password but once I close outlook and re-open, it will not send. Its unpredicable and causing large problems for my business. You can set up the required authentication on the "Outgoing Server" tab in your e-mail account properties. -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- please reply only to the newsgroup to preserve t...