98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses london - Shortcuts in Excel
excel vba courses london - Shortcuts in Excel
Resolved · Low Priority · Version Standard
Alex has attended:
Excel Intermediate course
Shortcuts in Excel
What are the best shortcuts to use in excel?
RE: shortcuts
Hi Alex
Thanks for your question.
Here are some of my favourites:
Ctrl Page Up, Ctrl Page Down moves between sheets
Ctrl + : enters the date (stays static)
Ctrl + Shift + : enters the time (stays static)
Ctrl and rolling the scroll wheel in the middle of the mouse zooms in and out of the spreadsheet
Alt + = enters the Sum function for you (instead of clicking autosum)
If you enter something into a cell and highlight a range, then press Ctrl + Enter the cell entry will be copied into the selected range.
Ctrl + End or Ctrl + Home to move to the end or beginning of a continuous range
All our trainers enter Excel hints and tips on our web site which are accessible from here:
https://www.stl-training.co.uk/hints-tips-excel-4.html
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Make a quick copy of a worksheetHold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too. |