How many possible rows and cells are in a microsoft excel ws?
347074
256 columns, 65536 rows\n256 * 65536 = 16777216 total cells
348716
Can't do that in Excel. The best thing you can do is type your headings in row 1 in each column.
626155
Use a flat database file format. One unique value in one column and the rest is employee data. All the data in a contiguous range. This way you can use pivot tables, auto filters, etc. to analyze data.\n\nI would suggest you use the latest version of Excel. Excel 2000 has a limit of 65,536 rows and 256 columns but Excel 2006 (out later this year...MAYBE) has 1,000,000 rows and 16,0000 columns.
845021
MS Excel has limits.  Search help for "Character Limits" and then you'll see a subject: "Excel specifications and limits"\n\nIn there you will find this:\n\n"Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. "\n\nI also tested this myself.  I created 50 lines of text that are each 80 characters long.  (total 4000 characters.)  I was able to paste the entire 4000 characters into one cell.  It displays just fine and uses the line breaks that I want at the end of each 80-character line.\n\n\nI then took the same 4000 characters without line breaks and pasted it into a single cell.  No problem there either.  It wraps within cell just fine.\n\nSo I'm sorry sir, I don't know what limitation is that you've come across that's not wrapping properly.  I suspect you've got some line breaks in your text but not in all lines.\n\nHope this helps.\n\nKind Regards,\nQwertyKPH @ Yahoo!\n\nSample: 4000 characters:\n\n123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234
71941
In the Formula Bar, type:\n=MAX(First_cell:Last_cell)\n\nFor example:\n=MAX(A1:C255)
516121
How about this:\n\nhttp://support.microsoft.com/?scid=kb;en-us;285337&spid=2512&sid=1292\nhttp://office.microsoft.com/en-us/assistance/HP051985111033.aspx\nhttp://asp2.wlv.ac.uk/its/website/selfhelp/help/excel/MainDifferencesExcel2000andExcel2003.asp
242526
I don't have a real answer for you.\n\nBut you can either use formulas in each cell, or apply Visual Basic Macros. I have done a lot of VBA, but only with Word. VBA is pretty easy - except you need to know the names of the various objects. But sample macros are floating around and Microsoft is fairly good about having details on this sort of thing.\n\nIn fact, now that I think of it, you might be better off writing the whole thing in Visual Basic and skip Excel. (Which, of course, does you no good if you don't have VB.)
943817
[EDIT - DELETED A WHOLE BUNCH OF TEXT]\n\nthat kind of thing is complex to create in a macro form, normally the kind of thing that you'd pay someone to do because i'd imagine it's easily a couple of hours work to write all the code, test it, iron out bugs etc. there *may* be a built in function in excel to do something like this but i wouldn't have thought so - i'm happy to be proved wrong:\n\n----found on t'internet----\nA1:A10 (your list of values)\nB1:B10 (leave blank)\nC1: =A1*B1 (copy thist fomula down through to C10)\nC11: =SUM(C1:C10)\n\nNow to use Solver....\nTools>Solver\nSet Cell: C11\nEqual to the Value of: 1173.76\nBy Changing Cells: B1:B10\nSubject to the Constraints....\n(click the add button and constrain B1:B10 to Binary)\nClick [OK]\nClick [Solve]\n\nExcel will toggle cells B1:B10 between 1 and 0 until it comes up with a combination that sums to 1,173.76\n----end of instructions----\n\nit depends on the setup of your spreadsheet - if it's one huge page that's a jumble of undistinguishable invoices with no reference to who the invoices belong to, it means manually checking the results of the macro for the set of results that applies only to one 'customer'. ideally you'd want a seperate sheet for each customer and then the macro or above method can be ran on whichever sheet/customer the cheque is from.\n\ni dunno about other people on here but i wouldn't spend hours of my time creating such a thing for the sake of 10 points which aren't really worth anything - i CAN tell you that if the above method doesn't do the job that it'd mean creating a loop that will add up every possible combination of totals from the sheet then comparing it each time against the grand total until it gets a 'hit'.\n\ni can't imagine this kind of sorting being practical for huge amounts of figures, probably a list of 20 at most because you could get into some big big processing time otherwise.\n\ni would be interested in hearing anyone elses ideas about doing it?
295597
WS.. U mean Windows Work Station.. ???
359158
The cells double every 12 hours.  In three days (ie 72hrs), the cells will go through 6 doublings (72/12=6).  \n\n0 hr = 2 cells\n12hr = 4 cells\n24hr= 8 cells\n36hr = 16 cells\n48hr = 32 cells\n60hr = 64 cells\n72hr = 128 cells\n\nThus you will have 128 cells after 3 days.
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
529006
I use MS Excel.  I use each worksheet in a workbook for the different months of a calendar year.  I copy the previous month's rows into the current months and erase the amounts due, dues dates, etc, and put in the new ones, then add new rows as required.  I use a gray font color for rows that don't apply, and use a red font for unpaid items.  As I pay them, I convert them to green.  You can use summary cells to add stuff up.
90555
Click on the little grey cell in the upper left corner of the workbook.  This will select all columns and rows.\n\nControl-A does the same thing
1172805
I would use Data Validation and VLOOKUP in Excel to do this.\n\nType in the 2 lists (for convenience lets start in A1) then add a third column:\nSerial#1          Combo#1          =A1\nSerial#2          Combo#2          =A2\nSerial#3          Combo#3          =A3\n\nMake the lists as long as you need. We created the third column for later; it just copies the serial numbers over to simplify things for the VLOOKUP formula.\n\nNow that the data is input we will need to create a drop-down menu. Since the data is in columns A-C, click in E1 to select the cell and click Data | Validation… In the Allow box choose List and type the range for the combinations in the Source: field (in our example: A1:A3). Now, click on F1 and type this formula:\n=VLOOKUP(E1,A1:B3,2,FALSE)\nIn the parentheses you will have this data: \n-E1 is the criteria you will look up in the array.\n-A1:B3 is the array where the data resides (remember this is from the example, yours will be longer).\n-2 in our formula tells VLOOKUP to pull the data in the 2nd column that matches our criteria from the 1st column.\n-False tells VLOOKUP to look for an exact match.\n\nWe have now created the Serial Number lookup that returns the proper Combination. To lookup the Serial Number from the Combination, we just do the steps again.\n\nClick in E2, choose Data | Validation… Again, in the Allow field choose List, but this time we need the combinations in the drop-down (B1:B3); click OK. The formula for F2 is almost the same:\n=VLOOKUP(E2,B1:C3,2,FALSE)\nThe only differences is that the criteria and array are shifted; the criteria down one row and the array over one column.\n\nIf you wish to hide the rows that contain the array, just right-click on the column headings and choose hide.
521317
Doing this is a little tedious but can be done. The tedious part is the first part.\n\n1- Let's assume that each sheet has a name with no spaces (i.e. sheet1, sheet2, etc) AND each of the 134 sheets has the same number of rows and columns. Copy the data area from sheet1 into a new sheet and 'paste link'. You'll have to do a find/replace and change each column letter to have a $ before it (i.e. d to $d$). Add the second $ to take care of the rows at the same time.\n\nCopy the data area in this new sheet under itself so now you have two identical sets. Do the same copy paste under operation 134 times (or until you run out of rows).\n\nOnce you have this done, you are going to have to do 133 find/replace operations and you are searching for sheet1 and replacing with the next sheet. Make sure you highlight the areas of interest. For example, on your second find/replace, highlight all the data under the first section. On your third, select all areas under the thinrd section. That way you aren't replacing the stuff you already did. example, your first set ends at row 100. Highlight row 101 to row 65,536, replace sheet1 with sheet2. Third set, also 100 rows. Highlight row 201 to 65,536 find/replace sheet2 with sheet3, etc.\n\nTedious & time consuming but if you aren't willing or don't know how to code in VBA, the easiest way to do it.
33456
lotus is an older program. excel is best. but annoying when it comes to formulas.
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.