On Excel, is it possible to replace the Column 'letters' in Gray (A,B,C..) with  column labels/names ?
145828
No. You can use "definitions".\nThere is a tool that is easy like that called Minitab.
663190
format-->cells-->custom \ntype in ##,##,##,##
991056
This can be done in MS Words using Fields:\n\nhttp://word.mvps.org/FAQs/Numbering/PageNumbering.htm\n\nbut I have never been able to do this in Excel. I have tried just about any character or word inside the brackets that I could come up with, but no luck. \n\nA couple of times when I thought I absolutely needed the numbering, I pasted my charts and data into a Word document.\n\nIt wasn't perfect, but with some tweaking it was at least presentable.
1118036
You want to use conditional formatting.  From the menu bar select Format then from the resulting menu select Conditional Formating.  You select the conditions for when you want the color to change.  You can set more than one condition.  Use the Format button to format the cell or range of cells to whatever color or font you would like them when that condition is met.\n\nOne thing to note, Excel will keep the conditional formating for that range of cells in place even if you manually try to color the cell.  Unless you remove the conditional formatting, it will keep the conditional formating in place.  To remove the conditional formating, select the cell or cells that you want to remove the conditional formating from and go to Conditional Formating again.  Click delete, then check the conditions that you want to delete.  Click OK to get out of the first window, then click OK again to get out of the second window.
991232
You can use a VBA sub with a very simple "Select Case" construct to define color depending on the value.\n\nAdd the following macro to your personal workbook (Alt-F11, right click the Personal Workbook in the VBA project window and select "add module" then paste the snippet of code in the main VBA window)\n\nWhen you want to implement the formatting, just select the range that needs to be conditionnaly formatted and execute the macro.\n\nAs it is, the macro evaluates a cell value and give to its immediate neighbour on the right the associated color. If you want to change the relative positions between evaluated cell and formatted cell, just change the values in all the Offset() of the code. The first argument is the row difference and the second the column difference.\n\nThere is no limit in the number of conditions you can use, just add more "Case" statements mimicking the syntax used here to increase the granularity of your conditionnal formatting.\n\n\n\n\nSub ColorCoding()\n\nDim rngCell As Range\n\nFor Each rngCell In Selection\n\nrngCell.Offset(0, 1).Interior.ColorIndex = xlNone\n\nIf IsNumeric(rngCell.Value) And Len(rngCell) > 0 Then\n    Select Case rngCell.Value\n        Case Is > 4\n            rngCell.Offset(0, 1).Interior.Color = vbBlue\n        Case 3 To 4\n            rngCell.Offset(0, 1).Interior.Color = vbRed\n        Case 2 To 3\n            rngCell.Offset(0, 1).Interior.Color = vbYellow\n        Case 0 To 2\n            rngCell.Offset(0, 1).Interior.Color = RGB(255, 140, 0)\n    End Select\n\nEnd If\n\nNext rngCell\n\nEnd Sub
115616
1. Open Microsoft Word\n2. Right Click on Toolbar\n3. Select CUSTOMIZE\n4. Select COMMANDS tab.\n5. Select FORMAT from left Column\n6. Drag SuperScript from Right Colum and drop it to Toolbar\n7. Drag SubScript from Right Column and drop it to Toolbar
138024
Letter C should be capital in column\nLetter A should be capital in add\n\nTry this\ndatagrid1.Column.Add(column);
834986
Use conditional formatting\n\nhttp://www.contextures.com/xlCondFormat01.html
252390
I'm going to e-mail you an Excel spreadsheet that will do it.   Don't change anything except the dates and the yellow cells and everything else will automatically calculate.
102604
I am assuming that you are using Excel.  Highlight your cells and click Format->Cells on menu bar.  Change from text to Number.
1183760
yaaaaaaa\ncalled a batch file name converter
249473
I've done this before. I have the spreadsheet at work, and I'll post an answer for you tomorrow. It fills in the right color for you even if you insert lines.\n\nOK. Here you go...\n\nOpen your spreadsheet and select the entire spreadsheet by clicking on the gray box between the A column and the 1 row in the top left-hand corner. Open the Format menu and select Conditional Formatting. Under Condition 1, select Formula Is and type "=MOD(ROW(),2)=0" (without the quote marks) into the empty box next to that. Click on the Format button and choose the formatting options that you want for your green rows. You can choose a color on the Patterns tab. Click OK and OK again. Now all of the even numbered rows should be green (or whatever color you chose). Email me if you're not sure what to do.
618625
It's not clear whether you want to do this manually or via a 'macro' (i.e., in Visual Basic), but anyway, here's the Visual Basic.\n\nTurn off gridlines and column and row headings:\n\nActiveSheet .PageSetup .PrintGridlines = False\nActiveSheet .PageSetup .PrintHeadings = False\n\nFormat headings using some text formatting:\n\nWith ActiveSheet .Range("A1:A5")\n  .RowHeight = 20\n  .Font.Bold = True\n  .Font.Size = 12\nEnd With\n\nSet borders around an area (e.g., summary):\n\nWith Worksheets("Sheet1") .Range("D3:F7") .Borders\n  .LineStyle = xlContinuous\n  .Weight = xlDouble\nEnd With
367950
word has a wizard for envelopes and labels. It knows many of the Avery labels by stock #. If one of them isn't right, you can customize it.
323204
First of all, make sure your lists in Excel have headings on the columns.  For example, line "A" needs to say First Name, Last Name, Street City, State, Zip, etc.  This tells Word what type of info it is looking at. Do this to the best of your ability, depending on how you set up your sheet.  If you combined some of it, don't worry and then follow the next steps...\n\nOk, go into Word and choose "Tools" "Letters and Mailings" and "Mail Merge."  When the mail merge wizard opens on the right, choose "labels."  Click "next"  Then choose label options.  Go in and tell it what type of labels you are using, etc.  You should be able to choose the Avery Label and # so it knows what it is printing on.  Then click "next" It should open up a page of blank labels and your next step should be choosing recipients.\n\nClick the "browse" link under "existing list" in the "select recipients" page.  Go through the browse and open your Excel mailing list.  Once you select that, you click "next" to arrange your labels.   There will be a group of options such as "address block" "greeting line" etc. on the right. Set up your "address block" on your labels by clicking the link then positioning it on the label where you want it.\n\nThen, choose the "more" link under the "address block" "greeting line" etc. and a window will pop up.  There will be a button it it that says "Match Fields."  Yours may work a little differently, but you need to find the "Match Fields" in case you need to tell Word which columns in your spreadsheet conatain what info.  For example, if you put the city, state, and zip in one column, you can go in and tell it to use that column for that part of the address.  This is where you tell Word which info to use for the labels.\n\nOnce you get all that meshed correctly, you should be able to preview your labels and all should be well.  If not, check back into the arrange labels part and fix what you need to fix.\n\nI hope that helps!
1086038
In macro you can change the print area to what ever you want.\nI did it several times and I have the line that you want.\nI just store it in my home computer.\nSo, If you send me your e-mail address and mark me as best answer, I will be happy to send it over\n\nRead my profile, I am the XLMan
596850
Do these words have only numbers? or do they have extra letters?\nIf the numbers you need to convert are in the beggining of the cell, use the Value function\n=value(A1)\nassuming that the cell you want to convert is in A1\n\notherwise\nsend me you e-mail address , and I will be happy to help\n\nI am the XLMan