Microsoft Excel - excel question
Asked By maverock Rock
12-Oct-09 06:57 PM
hi im trying to add an extra $10 to all of my 15 employees from jan to dec without inputing $10 one by one. Is there a specific formular that i can add $10 to all of my employees wages at on time. Thank you
Jonathan VH replied to maverock Rock
Type 10 in any empty cell. Copy that cell. Select your range of wages cells, Right-Click, and choose Paste Special. On the Paste Special dialog box, click the Add radio button (in the Operation frame), and then the Okay button. Then clear the cell with the 10.
How can I change the predefined headers and footers in Excel? Excel How can I change the predefined headers and footers in Excel? Excel Miscellaneous Discussions Microsoft Excel (1) Excel (1) Generaland (1) Tate (1) Dec (1) Footers (1) You can make your own, just click custom. The only ones you
how to calculate multiple roots Excel Excel Worksheet Discussions Microsoft Excel (1) Dec (1) F06D93A070DA (1) Bliengme (1) Risto (1) Caps (1) For quadratic or cubic equations see us more AND use the white space to do so best wishes - - Bernard V Liengme Microsoft Excel MVP http: / / people.stfx.ca / bliengme remove caps from email The Nth root of a use = 27^(1 / 3) or in code use X = 27^(1 / 3) Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site
hide and unhide rows in excel Microsoft Excel Hi My data looks like this: There would be around 40 sales persons. Customer numbers the sheet as shown below. 12 months data Sales person Customer Numbers Jan Feb Mar … …. . …. . dec John 13943934 100 200 300 457 12320394 234 121 232 323 14350323 Peter 15323923 13232990 regards shekhar Microsoft Excel (1) Intersect (1) Worksheet (1) Trigger (1) Macros (1) Module (1) Bit (1) VBA (1 Then Call FilterList(Target, 4) End If End Sub Private Sub FilterList( ByVal Target As Excel.Range, ByVal intStart As Integer ) Dim arrData As Variant Dim lngLastRow As Long Dim lngCurrRow can be pasted directly into the blank space. There is nothing to do in the Excel GUI, Excel knows to trigger the worksheet_change event whenever a cell is changed. However, you
Quote Numbers in Excel Excel Hello All, I'm using Microsoft Excel 2000. Does anyone know if it's possible to create a document that has one way to go, so if you have any suggestions, I would appreciate them. Thank you. Excel Worksheet Discussions Microsoft Excel (1) Excel (1) Worksheet (1) Addin (1) Dec (1) Gsnu200762 (1) Kitten74 (1) Udfs (1) In any
CHANGE CASE COMMAND IN MICROSOFT EXCEL Excel Microsoft Word contains the command of CHANGE CASE which is very useful, but Microsoft Excel does not contain this command due to which its too much difficult as rewrite the whole content of a cell. Cant this command be available in Microsoft Excel too, I think its not hard for Microsoft Corporation. Or if this command is available