By Shivani Garg
Keyboard shortcuts allows you to work with keyboard.
Let's learn the Magical MS Excel shortcuts with examples
How To select the Entire Range & Worksheet
- Click on any cell of the Range you want to select. Press CTRL+A to select the entire range.Look at the below example:
- Double Press CTRL+A to select the entire worksheet. See the below example:
- To copy the Range, press CTRL+C
- To cut the Range, press CTRL+X
- Press CTRL+V to paste the range.
Look at the example below:
## The other way to select the entire worksheet is, just click on the corner button of the worksheet & all the data will be selected.
Look at the Example below:
Also read : MS Excel tutorials for you :)
How to Move in the Range
Let's learn with Example
>> Select cell A2
- To Move to the bottom of the range, hold CTRL and press ↓
- To Move to the Right of the Range, hold CTRL and press →
How to Select the Range
Let's learn with Example
- Select cell A1.
- To Select the cells while moving down, Hold Shift and press ↓
- Likewise you can move selection of cells to right. For this, hold down SHIFT and press →
Also read : MS Excel tutorials for you :)
Labels:
MS Excel
Shivani Garg