Top 20
Microsoft Excel for PC - Page 4 Questions & Answers
How to protract a single row in excel 2007
1. First Select entire sheet -->Right click on any cell -->Cell formatting --> Protection -->Uncheck Lock
2. Now Select the desired row -->Right click -->cell formatting -->Protection -->Check Lock cell
3. Click review tab -->Select Protect Sheet --> Give Password twice
Excel cell replacement
To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)This will display N/A# if the number can't be found.
Learning how to do subtotal
Hi,for me to provide you with either screenshots or video or just text I need you to tell me your Excel version and Windows/Mac version.
What is microsoft excel and its use
Microsoft Excel is a spreadsheet tool capable of
performing calculations, analyzing data and
integrating information from different programs.
Microsoft Excel is comprised of organizational
units called workbooks.
IS THERE A PERCENTAGE FORMULA TO USE IN EXCEL
There isn't a function for this, but the formula should be something like this:A1: Number to increase / decreaseB1: % changeC1: 'INC' or 'DEC'D1: =IF(C1='INC', A1+(A1*B1), A1-(A1-B1))
I get an error when I tally cells that have errors because of dividing empty cell by empty cell.
Hi I dont really have much to do with Excel as I essentially build and repair and install, gosh I still type with two fingers!! Now below I have provided a link to Microsoft . Ways to count values in worksheets etc. If the problem persists try to update Office with what ever sercice packs are required and see if this helps. the link is http://office.microsoft.com/en-au/excel-help/ways-to-count-values-in-a-worksheet-HA010287849.aspx and I do hope it helps.Cheers
Not finding what you are looking for?