What do you do if you want to extend the current active cells to another cell each side?
Say about Excel program system, allow user to manage it simply by using shortcut key. Now, If you are selecting whether how many active cell in the worksheet. It doesn’t matter you can extend them(active cells) more to the four sides, left, right, upper, lower of adjacent active cells.
Follow these steps:
[Strathmore 100% Pure Cotton Stationery Paper 97, Wove Finish Watermarked 24 lb, 8.5 x 11 Inch, 500 Sheets/Ream - Sold as 1 Ream,bright Ultimate White Shade (318003)-Power by Amazon.com]
Hope these shortcut ways help you a bit more organize your Excel spreadsheet workload.
Say about Excel program system, allow user to manage it simply by using shortcut key. Now, If you are selecting whether how many active cell in the worksheet. It doesn’t matter you can extend them(active cells) more to the four sides, left, right, upper, lower of adjacent active cells.
Follow these steps:
- Press the [Shift] [Left Arrow] to extend the selection to the adjacent cell on the left.
- Press the [Shift] [Right Arrow] to expand the selection to the adjacent cell on the right.
- Press the [Shift] [Up Arrow] to extend the selection to the adjacent cell above.
- Press the [Shift] [Down Arrow] expending the selection to another underneath cell.
[Strathmore 100% Pure Cotton Stationery Paper 97, Wove Finish Watermarked 24 lb, 8.5 x 11 Inch, 500 Sheets/Ream - Sold as 1 Ream,bright Ultimate White Shade (318003)-Power by Amazon.com]
- You can select the number of the cell beginning as many as you want. It is possible to select only one cell or more.
- Keep pressing the [Arrow Keys] continual again and again until meet the final cell you wanted, do this while pressing the [Shift] key first and hold it every time.
Function Key
|
Result Description
|
---|---|
[Shift] [Left Arrow]
| Expending the selection to the adjacent cell on the left. |
[Shift] [Right Arrow]
| To expand the selection to the adjacent cell on the right. |
[Shift] [Up Arrow]
| Extending the selection to the adjacent cell above |
[Shift] [Down Arrow]
| To extend the selection to another underneath cell. |
Hope these shortcut ways help you a bit more organize your Excel spreadsheet workload.
See more shortcut:
- [F12] Excel Shortcut Key Display The “Save As” Function Fastest Way
- [Ctrl]+[Shift]+[Page Down] Select The Current & Next Sheet In A Workbook
- Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard
- Excel Solving "This Workbook Contains Links To Other Data Sources"
- 2010 Version Excel Keyboard Shortcuts Begin With [ALT] + [Other Keys]
- Learn Thai Free Online [LTFO] | Michael Leng
- Just Sing Along Blog | Song Lyrics In English-Thai Language
- Book-Hub | Best Seller Book Review
- [C+] Cell Phone and Accessory Review
- [1English-1Thai] English – Thai Dictionary Learning Blog
Comments
Post a Comment