Free Microsoft Excel 2013 Quick Reference

How do I multiply a unit measurement?

For example: 156 SQFT x $10.00. Where 156 SQFT is all in a single cell.
Is there a way to ignore the alpha characters and only look at the numerical
characters in the formula? (Excell 2000)

Thanks,


How do I format a cell to display measurement units with symbols in Excel 2000?
(ie. " for inch, etc.)

Thanks,

Mandy

How do I format a cell to display measurement units with symbols in Excel 2000?
(ie. " for inch, etc.)

Thanks,

Mandy

doing a project spread sheet using custom format hh:mm to record volunteer
hours.
Problem 1 - volunteers who have contributed > 24 hours return the wrong
answer when hours totalled )i.e. seems to go back to zero when 24 hours
reached)
problem 2 how do I multiply the totla individual hours by the individual
hourly rates to obtain a total value?

Using Excel, how do I multiply Column G Totals by a number and display the
results (sum) in Column H?
Thank you for the help

I have a large worksheet that needs to be changed. I have payroll numbers
from last year that need to be changed. Last years payroll numbers need to
be multiplied by a 1.015 and replace last years #'s. How do I muliply the
whole column by 1.015 and have this show as the new numbers?

doing a project spread sheet using custom format hh:mm to record volunteer
hours.
Problem 1 - volunteers who have contributed > 24 hours return the wrong
answer when hours totalled )i.e. seems to go back to zero when 24 hours
reached)
problem 2 how do I multiply the totla individual hours by the individual
hourly rates to obtain a total value?

i would like to know, how i multiply a cell by %?

ex: 8.41% x $134.70? ( i want to use a formula)

How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min or 99 seconds
in order to multiply the duration with an amount or rate to give me a cost?

I have 4 columns of data ( #of units, old work price, new work price, &
total). How do I multiply number of units by either old work price, or new
work price, based on column where data is entered?

How do i add a combo box to and excel spreadsheet through code?

I know i can insert one through the control tool box but i dont want to do that i want to insert a combobox onto my spreadsheet when a button is clicked? How do i do this and if so how do i get a control of where it is put... please help its urgent!

Hi,

I would like to save my all assigned macros in a New Menu in an Excel toolbar. In stead of saving the macros
under Level 1 menu, I would like to save them under a Level 3 menu.

How do I create a level 3 Menu in the toolbar ?

Appreciate any help on this matter.
Thanks in advance.

I have a spreadsheet where I want two command buttons: one that says "Print" and one that says "E-mail". I have the code that will make these actions possible. I just need to know how do I link the code with the command buttons. Example, if I hit the print command button, the macro for printing will run. Also, how do I create a command button?

Please Help!
Thanks!

How do I link a Workbook with 18 sheets to a Summary Page, allowing access to each sheet from the Summary and access from the Summary to the Sheet?

I have used the hyperlink but it reverts to the one last accessed!!

How do I use a command button to close a spreadsheet and exit Excel?

I'm sure this is simple, but I can't seem to find the answer:

how do I insert a piece of text next to a formula result in the same cell?

Example:
I want to write "date of" in the cell but then have another word after that which is dependant on a VLOOKUP result, all in the one cell.

How do I keep a formula from changing?
Just as a primitive example:
In cell A1 is the formula =B1
In cell B1 I write the word cat.
Now A1 will show the word cat.
So far, so good.
However, if I insert a column between A and B
the formula in A1 now shows =C1.
I want the formula in cell A1 to stay and continue saying =B1 after I insert a column.
Is it possible to "freeze" a formula.

How do I assign a Range Name to the Current Selection with no hard coding of the cell address? I'm looking for a simple statement that looks something like:

selection.name="zebra"

Also, how would I Assign a Range Name to the active cell?

I see statements such as:
ActiveWorkbook.Names.Add Name:="zebra", RefersToR1C1:= _
"=Donations.tab!R3C100"

But that hard codes the address.

Poked around alot before posting this question.

Thanks.

How do I add a text box to show when a macro has been activated.

The macro is:
Sub Lockquote()
Worksheets("quote formula").EnableCalculation = False
' Lockquote Macro
' Macro recorded 8/24/2008 by Mike Frank
'

'
End Sub

To run the macro you click on a command button labeled " Lock this Quote"
Once the macro has been run I want a text box to apprear that shows "Quote is locked", than I want that text box to go away when I run the macro to unlock the quote.

"Only Microsoft can make me feel this stupid!"

I am creating an excel file for employees to enter their time. I want to have a formula set up that will automatically total the number of hours spent on specific project categories. For example, cell C6 is a drop down list having multiple categories to choose from. Cell D6 is the total number of hours spent on that project. Cell C7 is a drop down list and D7 is the total number of hours, etc... How do I create a formula that will total only the total number of hours for a specific category selected in the drop down list?

For Example:
Totals hours spent on administration: =D7 if C7 = administration

I don't know if this is possible, but I hope so! If I'm confusing, I apologize because I'm not well versed in computer terminology.

Thanks,

How do I convert a excel 2007 worksheet to a memory stream?
or

How do I convert a excel 2007 worksheet to an array of bytes?

Thanks in advance.

How do I call a Web Service from Excel 2007?

Does anyone has a sample Web Service call from Excel 2007?

Thanks in advance,
Mark

How do I save a sheet from the macro workbook to a new file?

My code runs, the last thing I want to do it to move sheet named "Summary" to another work book, save it as XLS in the same directory as the macro, with the name being "Pivot Table" &myStartDate& myEndDate&".xls"

I'm under what to put after...

Sheets("Summary").Select
Sheets("Summary").Move

Thanks!

How do I stop a macro in mid-flow?

Hi Guys, Using VBA, how do I find a value in a text string?

Lets say I have a text string consisting of "CASTLE HILL 2154 SYDNEY NSW AUSTRALIA", this can change, its position can change, sometimes it will not even exist.

How do I get just the 2154 from that string?

Thanks

Dan

How do I search a sheet for an asterisk? Excel seems to treat the * as a wild card. I want to search to find the * symbol.