In an Excel worksheet, how are labels different from names?
552698
you have to be exact what you mean by names\n\nb-cuz a label is a name but than the names can be info in the chart, table or/and graph
78303
this is actually a problem of linking more than 1 excel worksheet, say if you have book1.xls, book2.xls and book3.xls, the master for printing report is book1, the data are in book2 and book3, in them you have a1 and b1 cell filled with numbers, to show it in book1 transposed you want a1 to a2 is for book2'data and b1 to b2 is for book3's data, here's is what you should put down.\n\n"___________A_____________B"\n1    =[Book2]Sheet1!$A$1     =[Book3]Sheet1!$A$1           "\n2    =[Book2]Sheet1!$B$1     =[Book3]Sheet1!$B$1           "\n3\n\nhope this will help.
817438
1. Select the cells you want to include in  a range.\n2. Click on the name box.\n3. Type the name for the range.\nthat's it.\n\nClicking the drop down button on the name box will list all the range names that has been created.
399337
Highlight B5 in the formula and press F4.\n\nThis will turin it into an absolute formula $B$5 and will remain fixed.\n\nThe other thing you can do is give the cell reference a name (e.g.B5VALUE) and this can be encorporated in formulaes on any worksheet.  This is an example of a named cell reference.\n\nSee source for more details.\n\nHope this helps
1105719
In Excel, functions and macros only can do this. Try the functions PROPER, UPPER and LOWER.\n\nCtrl+Shift+A is another Word keystroke for changing case, it doesn't work in Excel.\n\nCheck out:\nhttp://www.mvps.org/dmcritchie/excel/proper.htm#upper
653602
Do you have Excel, if you do, then Excel can do that.  I think the formulas are self explanatory but if it isn't obvious to you, a Google search should turn up on how to do this in Excel.
687364
In spread sheet 1 I created the following\nSorry but the formatting is not to good.\nColumn A\n1\n2\n3\n\nColumn B\nhello\nhi\nhowdie\n\nIn spreadsheet 2 I created this\nColumn A\n1\n2\n3\n\nColumn B\n=LOOKUP(A1,Sheet1!A1:B3)\n=LOOKUP(A2,Sheet1!A1:B3)\n=LOOKUP(A3,Sheet1!A1:B3)
348716
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
102604
I am assuming that you are using Excel.  Highlight your cells and click Format->Cells on menu bar.  Change from text to Number.
162424
Insert --> Chart --> Pie\n\nHit next\n\nDrag your mouse across the data boxes in excel to specify how large it should be, then click on the Series tab, remove all those that are in that list box, click add, set Name equal to what the Pie Chart's name is, then enter all your values in between the ={}, with commas separating your entries. The 3rd step should be self-explanatory with titles and stuff, and from there you're set.
745516
I'm not sure what kind of formatting you want to do, but In my experience the conditional formatting is set based on the result (value) of the formula, not the cell formula syntax (as it would if you set the cell format to be text, thus displaying the formula syntax instead of the result.  If you like, click my screenname and send me a message with more details and I will try to help.
661261
You could use conditional formatting on the cells where you are entering your data.  But you actually don't need to do conditional formatting, it's just that you can get smoother more interesting effects if you do.  An easier way might be a simple formula.\n\nIt sounds like you are entering data that uses Case numbers, but if you have already entered a case, you don't want to do it again.  Obviously you could just search the case number column to see if it already exists and if so, then skip entering it.  But a more automated way would be easier.\n\nThe essence of what you need to do is use a formula to tell you if what you just entered already exists in the rows above. (To use your example, does case 24 exist already in the rows above A27?)\n\nYou could insert a (temporary) column to the left of what you are typing in.  In that column you would enter a formula to count the number of instances where the case number you just entered already exists above.  Usually the result would be 1, sometimes 2.\n\nLets say you are on row 27 and your case numbers are in column B, and your counting column is column A.  Lets assume your data starts on row 2 at the top of the spreadsheet.  Your formula for cell A27 would be:\n=IF(COUNTIF($B$2:B27,B27)>1, "Exists Already!", "")\n\nNotice the $ signs in the Countif formula.  The formula range will adjust as appropriately as you copy it around.  You want to get this formula on every line next to every case number so that it can alert you if it seen there is more than once instance.\n\n(Actually the Data Validation mentioned below is a better solution because it will prohibit you from entering the data.  But it's all the same principle. Just more elegant because you don't need to insert a new column.)
709713
You can simply use an "IF" statement.\n \nLet's say in A column some cells have values & some don't - for the one that has a value (non-blank), you'd like put the number "2" next to it (in the B column), here the formula -\n\n=IF(A1<>="",2,"")\nThis means if A1 is not blank, then put 2 in B1, otherwise leave it blank.
220750
I think you're trying to do this:\n\n1) Open a new Excel file\n\n2) Click Insert > Object \n\n3) Select the Create from file tab\n\n4) Click browse and browse to the Word doc.\n\nAlternatively, a copy and edit>paste special would probably  also do what you're wanting.\n\n>\n\nAre all 13 pages the same labels?  If so, then just copy everything on the first page of the Excel worksheet (CTRL-C) and paste it normally into 12 more pages with CTRL-V.\n\nIf not, then unfortunately you're probably going to have to copy each page of the Word doc and paste special into Excel.  \n\nAlso, when you paste into Excel, you might look at the paste options by clicking on the paste options button that comes up right next to the cell that you pasted the information.  There is a wizard in there that might make the labels look better than otherwise.
708608
Here's a macro for what you want (you can replace the periods with spaces, I only put them there for appearance)\n\nSub Swap2Cells() \nIf Selection.Count <> 2 Then \n.....MsgBox "Select 2 cells only." \n.....Exit Sub \nEnd If \nSet trange = Selection \nIf trange.Areas.Count = 2 Then \n.....temp = trange.Areas(2) \n.....trange.Areas(2) = trange.Areas(1) \n.....trange.Areas(1) = temp \nElse \n.....temp = trange(1) \n.....trange(1) = trange(2) \n.....trange(2) = temp \nEnd If \nEnd Sub
550410
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
489379
All that usually means is that you have entered a number value, and the column width is too small for Excel to display it.\nIncrease the column width and the spreadsheet will display your numerical value properly.