Free Microsoft Excel 2013 Quick Reference

how do you cancel editing mode in excel

Can not insert new graph in powerpoint. get messaage to first close opening
box or cancel editing mode in excel.
Could you please help?
Thank you


Post your answer or comment

comments powered by Disqus
How do you attach a macro in excel 2003?

how do you open SPSS files in excel? Can you? thanks in advance...

The reply that was given did not work. Can someone please help!

Is this code right? Its supposed to return the ColorIndex value of a cell, and how do you insert it into a standard module in an Excel workbook.

Function ColorIndexOfCell(Rng As Range, _
Optional OfText As Boolean, _
Optional DefaultAsIndex As Boolean = True) As Integer

Dim C As Long
If OfText = True Then
C = Rng.Font.ColorIndex
Else
C = Rng.Interior.ColorIndex
End If

If (C < 0) And (DefaultAsIndex = True) Then
If OfText = True Then
C = GetBlack(Rng.Worksheet.Parent)
Else
C = GetWhite(Rng.Worksheet.Parent)
End If
End If

ColorIndexOfCell = C

End Function

Function GetWhite(WB As Workbook) As Long
Dim Ndx As Long
For Ndx = 1 To 56
If WB.Colors(Ndx) = &HFFFFFF Then
GetWhite = Ndx
Exit Function
End If
Next Ndx
GetWhite = 0
End Function

Function GetBlack(WB As Workbook) As Long
Dim Ndx As Long
For Ndx = 1 To 56
If WB.Colors(Ndx) = 0& Then
GetBlack = Ndx
Exit Function
End If
Next Ndx
GetBlack = 0
End Function

Mark > wrote in message
...
> In Excel -
> How do you get information typed in one cell to appear in another
> pre-choosen cell location.

You need to use the formula bar. Select the cell that you want to copy the
data into (say, A1). Then click on the " = " button on the formula bar.
(This means that the selected cell (A1) will show the result of a formula).
Then select the source cell (say, B1) and click enter (or click on the tick)
button. Whatever info is entered into B1 will also be displayed in A1.
Point to note: if you cut and paste cell B1 to any other cell, then the
info in cell A1 will be linked to the new address of cell B1. Ordinarily,
this is a good thing. However, it might not be what you want.

Regards
Kev

How do you prevent duplicate entries in an excel spreadsheet?

In Excel -
How do you get information typed in one cell to appear in another
pre-choosen cell location.

Hi

how do you use access macro from excel? see line marked ***

I want to run this VBA code which is in Access

Have the following code:

Code:
  Sub Import_Staff_alloc_xl()

'---------------------------------------------------------------------------
        'Open Access
'---------------------------------------------------------------------------



Dim AccessApp As Object

Dim strMsg As String

'Set the path on YOUR PC for Db

strDatabasePath = "c:Test.mdb"

'Create an instance of the Access application object.
Set AccessApp = CreateObject("Access.Application")

'Open the ct Db with Access.
    On Error Resume Next

    With AccessApp
        Application.DisplayAlerts = False
        .OpenCurrentDatabase strDatabasePath
        
       .DoCmd.MakeNewTable  '        

    End With

AccessApp.Visible = True
End Sub


If you have three excell documents that have common information, and you edit one of the columns information, how do you make the other two excel documents update automatically, so that you do not have to make the change to all three documents?

How do I change office assistant in Excell 2002. I want the cat instead of
the paper clip. Thank you.

I have a multipage worksheet and have deleted over 2/3rds of the data, but
the file size remains the same. How do you shrink it?

How do I insert a clock in excel worksheet?

How do I get traffic lights in excel that change colour depending on the
result returned in a variance cell?

Tools -> Options -> General
Then clear the R1C1 checkbox
--
Gary's Student

"Lostinexcel" wrote:

> How do I get the columns in Excel to go back to letter sequence. It was
> displaying a letter sequence on the columns. What happened.

How do I arrange worksheets alphabetically in Excel?

How do I create a formula in Excel that will countif or sum if before or
after a specific date? Whenever I put the actual date in the formula it
works, but when I reference to the cell the date is in it returns 0.

How do i enter negative times in Excel & how can they be 'fiddled with' to
allow SUM functions etc... to work correctly? When I try to enter a negative
time in time format [h]:mm an error message pops up saying put a ' in front
.. This does allow the negative time to be entered but when this cell is
incorporated in a SUM funtion it is ignored. There is probably a simple
solutionto this, but as an excel novice it has me stuck!

How do I fix column widths in Excel Pivot Tables so that width does not
change with each refresh?

How do I hide a worksheet in Excel and use a password to un-hide the worksheet?

How do i create Lorenz curve in Excel? I dont find it! I have Excel 97. Is it
possible that there isnt such option on this version? Or its there under
another name? I could find it under Chart wizard in another version. Please
help, i would need it urgently!

Thanks,
Judit

how do you create custom buttons in office 2007?

how do i report a bug in excel

How do I close a link in Excel 2000?

How do I get the columns in Excel to go back to letter sequence. It was
displaying a letter sequence on the columns. What happened.

How do I change a column in Excel from upper case to lower case?


No luck finding an answer? You could always try Google.