MS Excel Notes - Neils Resource WebMS Excel Notes - Neils Resource WebMS Excel Notes - Technical - Neils Resource Web

Summary of Content
Here is a collection of MS Excel keyboard shortcuts and web site links to other useful Excel resources. Also tips & bits that I have used myself.
A double mouse click anywhere on the page (except when over hyperlinks) will take you back to the top of the page.

Open any links selected in a new window

All Sites have been found by me whilst browsing the web, they are not generating revenue (for me).
The Links displayed do not necessarily show the full URL, but should point to the correct Sites & should be fully operational.
Please let me know about Broken Links, better alternatives or other similar / useful sites.
Site / Page Link Description of linked Site / Page Useful tutorials
Excel Tips A stack of tips! Contrary to the link, the tips are from users Excel Tips Nice Excel tutorials

Microsoft Excel Keyboard Shortcuts
Alternate display cell values / display/ cell formulas CTRL+` (single left quotation mark)
Calculate all sheets in all open workbooks F9
Calculate the active worksheet SHIFT+F9
Create a chart that uses the current range F11 or ALT+F1
Display theFormat Cells dialog box CTRL+1
Display the dialog box F5
Fill the selected cell range with the current entry CTRL+ENTER
Insert the current time CTRL+:
Insert today's date CTRL+;
Move to the beginning of the worksheet CTRL+HOME
Move to the last cell on the worksheet CTRL+END
Paste CTRL+V
Paste a function into a formula SHIFT+F3
Print CTRL+P
Select all (when you are not entering or editing a formula) CTRL+A
Select the current row SHIFT+SPACEBAR
When you enter a formula, display the Formula Palette after you type a function name CTRL+A

Naming the worksheet tab from within the worksheet (macro)
Re-ordering worksheets (macro)
The following macro will sort all the worksheets in a workbook in ascending order, whether the worksheet names are text or numeric:

Sub SortWorksheets()
' sort worksheets in a workbook in ascending order
Dim sCount As Integer, i As Integer, j As Integer
    Application.ScreenUpdating = False
    sCount = Worksheets.Count
    If sCount = 1 Then Exit Sub
    For i = 1 To sCount - 1
        For j = i + 1 To sCount
            If Worksheets(j).Name < Worksheets(i).Name Then
                Worksheets(j).Move Before:=Worksheets(i)
            End If
        Next j
    Next i
End Sub
wwwThis Site

Last updated: 04/03/2008 - MS Excel Notes - Technical - Neils Resource Web

html 4.01 strict css 2.1 javascript 1.2