Finished working on
an Excel workbook and want to move onto the next thing? Close it
quickly and easily with CTRL+W – and if you’ve not saved it yet,
Excel will ask you if you want to.
But don’t use the mouse – just
press Enter to save!
Showing posts with label excel keyboard shortcuts. Show all posts
Showing posts with label excel keyboard shortcuts. Show all posts
Thursday, 16 January 2020
Thursday, 5 December 2019
Keyboard shortcuts 3: Selecting rows & columns
Following
on from the last tip about selecting cells using the keyboard, did
you know you can also select entire rows (shift + space) and columns
(ctrl + space).
So
tell me… are you beginning to think about ditching the mouse yet?
Comments below...
Friday, 25 October 2019
Embracing Excel's keyboard shortcuts
As subscribers to my Excel e-tips mailing list will know, I’m a big fan of keyboard shortcuts – they save a lot of time in Excel compared to using the mouse. In fact, there are two types of shortcut:
These are accessed by pressing CTRL + another key. For example, press CTRL+X and you’ll cut the info from a cell; CTRL+V will paste.
Indirect shortcuts
These are accessed by a combination of keys pressed in sequence (rather than at the same time). For example, Alt>H>A>C will centre-align the content of a cell.
Over the next few weeks, my challenge to myself is to persuade you to put down the mouse, embrace both types of keyboard shortcut, and make the journey towards working more efficiently in Excel.
To keep up with this series, add your email to the "follow by email" box on the right to subscribe to the blog, or sign up to Naturally Spreadsheets' Excel e-tips mailing list to get the tips delivered straight to your inbox every 2 weeks.
- Direct shortcuts
- Indirect shortcuts
These are accessed by pressing CTRL + another key. For example, press CTRL+X and you’ll cut the info from a cell; CTRL+V will paste.
Indirect shortcuts
These are accessed by a combination of keys pressed in sequence (rather than at the same time). For example, Alt>H>A>C will centre-align the content of a cell.
Over the next few weeks, my challenge to myself is to persuade you to put down the mouse, embrace both types of keyboard shortcut, and make the journey towards working more efficiently in Excel.
To keep up with this series, add your email to the "follow by email" box on the right to subscribe to the blog, or sign up to Naturally Spreadsheets' Excel e-tips mailing list to get the tips delivered straight to your inbox every 2 weeks.
Wednesday, 17 January 2018
Keyboard shortcuts
By Neil Shorney.
To achieve things more quickly, keyboard shortcuts are an alternative to clicking the mouse. You might know that you can use Enter to move down a cell, and Tab to move to the right. Did you also know that Shift+Enter will move your selection up and Shift+Tab will move it left.
We look at this in more detail in Introduction to Microsoft Excel in the classroom, or Excel Level 1 - The Basics online.
To achieve things more quickly, keyboard shortcuts are an alternative to clicking the mouse. You might know that you can use Enter to move down a cell, and Tab to move to the right. Did you also know that Shift+Enter will move your selection up and Shift+Tab will move it left.
We look at this in more detail in Introduction to Microsoft Excel in the classroom, or Excel Level 1 - The Basics online.
Subscribe to:
Posts (Atom)