MS 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.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 |
| Computertips.com | Useful tutorials |
| Excel Tips | A stack of tips! |
| Microsoft.com | Contrary to the link, the tips are from users |
| Columbia.edu | Excel Tips |
| Baycongroup.com | 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 |
| Copy | CTRL+C |
| 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 |
| Open | CTRL+O |
| Paste | CTRL+V |
| Paste a function into a formula | SHIFT+F3 |
| CTRL+P | |
| Save | CTRL+S |
| Select all (when you are not entering or editing a formula) | CTRL+A |
| Select the current row | SHIFT+SPACEBAR |
| Undo | CTRL+Z |
| 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 |
Hyperlink titles have been abbreviated, (right click on the link and select properties for the full URL)
Double mouse click anywhere on the page to take you back to the top (except when over the links)
Last updated: 04/03/2008 - MS Excel Notes - Technical - Neils Resource Web
