how to fill 100 cells in excel?
482828
i just try it and tell u today
738866
Highlight the area that you want boxes, then pick CELLS from the FORMAT menu.   Click on BORDERS, then set the borders that you need TURNED ON.\n\nGood luck and Happy Computing!
102604
I am assuming that you are using Excel.  Highlight your cells and click Format->Cells on menu bar.  Change from text to Number.
636777
=(cell number+cell number) \nYou just have to click on the cell that has what you want added, subtracted or multiplied. Simple, really. And you can use more cells than that. Have fun.\nAnother formula might be \n=A(cell number+cell number)
392220
1.  Mark the applicable column or cell.\n2.  Choose "Format" drop-down menu from the top menu.\n3.  Select "Cells"\n4.  On the TAB "Number" (first TAB), choose the option "Number" (the default is General)\n5.  Select the decimal places as "2"\n6.  Click on OK\n\nAll numbers in the selected cells will now be shown with two decimal places
332491
Try digdb excel add-in\n\nthis is the linke you need
331746
first of all you need to decide your frequency bins i.e. do u want to calculate frequency against each no from 1 to 100 or u want to have ranges i.e.\neither u want your output like\nPercentage                       Frequency\n       1%                \n       2%\n       .\n       .\n       .\n       100%\nOR\nPercentage                       Frequency\n    0% TO 10%                \n    11% TO 20%\n      .\n      .\n      .\n    90% TO 100%\nTo me the second set of output is more practical\n\nso whatever output u select , type the figures in a column (for second set of out put, simply type 10,20,30....  'coz 10 means 0-10, 20 means 11-20)\nIn the next column highlight all the rows against all the frequency bins\nSelect frequency function, enter data array which is the marks data in your sheet, enter bins array , which is the cells where u entered ur bins and press OK\nThis should give u a frequency fighure against the first bin only. press F2. Press Ctrl+Shift+Enter...   and u r done\n\nCheers\n\nif u still have problem, send me your sheet on, post your email address and I will send u the sheet
925219
Ok This what you do. Micorsoft Excel Can do it for you perfectly well. All you need is to simplify the fomular inwhich you want to use in making your calculations so that everytime you type in a number you will get the totals without craking your head too much. \n\nExcel is what you need. \n\nThanks
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
919760
Work in 24 hour times.\n\n10:18-16:23\n\n16-10 is 6 hours.\n23-18 is 5 minutes.\n\n6hr 5mins.\n\nFor an automatic way of doing it, visit: \nhttp://www.timeanddate.com/date/timeduration.html\n\nJust enter the hours and minutes, leave the days and months blank. It will accept 4pm or 16 as an entry for hours.\n\nYet another way, and good if you want to do them in batch. Use Microsoft Excel. Enter all the start times in 24 hours format in one column, and all the end times in 24 hour format in the next column. In a 3rd column, in the first cell type = then click the top cell in the 2nd column. now type - and click the top cell in the first column and hit enter. This calculates the first row. Now click on the result cell again, and you'll notice a box in the bottom right corner, hold and drag this (should get a + symbol) drag down to the bottom row, and it auto fills in all your formulas.
130036
1. Start Microsoft Excel\n\n2. Before you type fractions in cells, preformat the group of cells that need to be displayed as fractions. Select the cells where you want to enter fractions, and then select Cells from the Format menu.\n\n3. Click Fraction in the Category list, and then, from the list on the right, select the type of fraction that you would like to display. Click OK.\n\n4. Now you are ready to type fractions in these preformatted cells. To type fractions in cells, just type the numerator, followed by a slash (/), then followed by the denominator—do not type spaces.\n\na. For example, 1/2 would represent one-half, as would 4/8 (Excel reduces fractions to their lowest terms). If you need to type a whole number and a fraction in one cell, type the whole number followed by a space, and then type the fraction (numerator, slash, denominator).
572733
Please check out this site it gives averything you want on VBA.\n\nwww.functionx.com
221896
There's an easy way to do this. I've given you some very basic code.\n\nCopy and past this code into your VBA code under the same sheet as your data. (Press ALT-F11 to get to the VB editor and double click the sheet name of the tab you are working on).\n\nSub SortText()\n    LookRow = 2\n    PutRow = 2\n    txtCounter = 1\n    Do\n        txtColor = Cells(LookRow, 1)\n        If txtColor = "" Then Exit Do\n        txtSize = Cells(LookRow, 2)\n        txtRange = Cells(LookRow, 3)\n        Cells(PutRow, 5) = "Trial #" & txtCounter\n        Cells(PutRow + 1, 5) = "Color " & txtColor\n        Cells(PutRow + 2, 5) = "Size " & txtSize\n        Cells(PutRow + 3, 5) = "Range " & txtRange\n        PutRow = PutRow + 5\n        LookRow = LookRow + 1\n    Loop\nEnd Sub\n\n\nWhen you run the macro it will take the data and arrange it into the columns you wish. Be aware that it will paste the data into column E of the same page and will overwrite anything you have there, so backup your data first.\n\nYou can also assign this to a shortcut-key with Tools>Macro>Macros... You will need your security set to Medium for this to work.\n\nIf you wish the data to be saved on a seperate page, please email me at wabbitt1970 @ hotmail.com
233468
I've uploaded a simple spreadsheet to the link below.  Anything else and you should probably find someone in the office who knows Excel.
897335
You can do this in two ways:\nOne: Using Macro.\nTwo: Using functions\n\nI prefer using the option Two as a start.\nNow, I need you to focus with me...\n\n- Enter your two values "Default" and "1000" in two cells (Say Y1:Y2)\n- Create a Combo Box using "Forms Toolbar", that is go to View > Toolbars > Forms\n- The toolbar will show and you can create a combo box from it.\n- Right click on that combo box and go to Properties > Control, select two cells that have your values (Default and '1000') Y1:Y2 as the Input range, select a cell to link this combo box to (Say Z1).\n- Now click ok\n- Where ever you select a value from this combo box, Z1 cell will change to 1 or 2.\n- Your A1:E50 cells need to have this function, need to be changed. I have a question here (Do these cells have a numbers (A) or coming from a formulas (B) ?)\nA) If the A1:E50 cells have all constant numbers, I prefer you choose another range to put this formula in.\nSay G1:K50, put in G1 this formula and copy and paste to the others:\n= CHOOSE( $Z$1, A1, A1/1000)\nB) If they have a formula, just change it to this formula:\n= CHOOSE( $Z$1, [your old formula], [your old formula] /1000)\ndon't forget to change the value [your old formula] to your old formula on each cell.\n\nNeed more help? or would like to see the Macro section?\nmail me here\n\nEnjoy my profile, I am VBAXLMan
701899
In Photoshop go to File/Automate/Contact Sheet II.  Then select a folder where your bunch of photos is and proceed from there.  You can select how many rows and columns you want.
402884
Just go to D19 and hit Del button, the whole line will appear in full.\nReason is you got a spacebar entry in Cell D19, so its not showing on the formula bar and cutting the line start from A19 there.