Excel - Want cell height to expand automatically with number of lines of text?
963464
Yes they do.  Go to Format, then Cell, Click on the Allignment tab and put a check in the box next to "Wrap text".\n\nAfter you have entered your text, put your mouse at the line between the cell you are working in and the one above.  You will get 2 arrows (one pointing up and one point down) double click there and the cell height will expand automaticly.
1104463
yes sort\nyou have to highlight it and\nin excel \nData --> Sort --> Assending order\n\nin word\nTable --> Sort
1084302
go to the "view" menu and go to "text size"
538540
format>paragraph>look for line spacing and select double
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.)
432934
In excel all the cells are numbered - A1, A2, A3 as you go down the page or A1, B1, C1 etc as you go across the page.\n\nIf you have a list of numbers in cells A1 to A10 for example then to add them together you would enter =(sum A1:A10) in a different cell (lets say A11).  The result that was displayed in A11 would be the sum of the numbers in cells A1 to A10.  Note that only numbers can be added so if one of your cells contained an unrecognized format (e.g. a date or text) then it wouldn't be included in the calculations.\n\nYou can add up blocks of cells simply by changing the range.  If you look at your Excel spreadsheet and imagine date in each of the first 4 rows of the first 4 columns then the formula to total up these 16 cells would be =(sum a1:d4).\n\nYou can also use the method described above by clicking the cells you want included in the total - particulalrly useful if the values to be added are scattered across different rows and columns.\n\n------------------------------------\n\nAs regards inserting a page number you need to click on File > Page Set Up > Header / Footer and then either Custom Header or Custom Footer depending if you want the page number at the top of bottom of the page.\n\nDecide whether you want the page number on the left, center or right of the page by positioning your mouse pointer in the corresponding box and then click on the second of the 2 icons - it has a symbol like this on it... #\n\nYou can add text before and after the page number so that your sheets could, for example, read 'Page 1 of 7' 'Page 2 of 7' etc.
71941
In the Formula Bar, type:\n=MAX(First_cell:Last_cell)\n\nFor example:\n=MAX(A1:C255)
397563
go to view, then text size
452391
When you create a chart, do not specify the data range with a range of cells, use a dynamic range. The range will expand automatically when data is loaded, at the top or bottom. See the Source link for several examples.
397825
In Excel, you have to split it by adding another column.
785958
It's possible, but the list will be generated either by formulas or by code... XL2003 allows 255 columns and 65,536 rows per worksheet, so a maximum of 16711680 individual cells are allowed, so it can cope with the volume of data you are talking about.
705798
Use data validation.  \nSelect the column, choose Data / Validation...., \nchoose "Allow" = "Text length",\n "Data" = "Less than or Equal To", and "Maximum" = 30\nIf you want fo find out how many characters you have in cell:\n=Len(Cell)    i.e., =Len(B1)
776480
click on view, then text size...
1130468
This add-in may be what you need.\n\nhttp://www.cpearson.com/excel/RowLiner.htm
87429
view, columns, checkmark next to size
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.
1177830
You have to put this if condition\n\ngoto b1 cell and put this formula =if(a1="ON",1,if(a1="OFF",0,"EMPTY"))\n\nif you can't read full formula please move your mouse pointer over it. then it will be displayed full.\n\nso when you put ON in a1 cell, that will display 1 and when you put OFF b1 cell will display   0   if a1 cell remains empty, then b1 will display "EMPTY"