two columns percent in third in Excel New users    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Common Rock 2/1/2006 3:39 PM PST   Question   How do I do a 3rd column of percent of two other columns without entering =j1/k1, =j2/k2, etc? I can do the total percent in a box at the end, but I would like each row percent.     Was this post helpful to you?         Reply |   Top           Nick Hodge 2/1/2006 3:55 PM PST   Answer   Enter =J1/K1 in L1 and then with L1 highlighted, grab the 'fill handle' (small square in bottom right of cell), left click on it, hold the mouse down and drag as far as you want, Excel will look after the incrementing of the row numbers in the formula -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk "Common Rock" <Common Rock@discussions.microsoft.com> wrote in message news:762F3198-D732-4BB7-9FD2-F16A3027C0B4@microsoft.com... > How do I do a 3rd column of percent of two other columns without entering > =j1/k1, > =j2/k2, etc? I can do the total percent in a box at the end, but I would > like each row percent.     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies