SIZ Approved Course ||IT-Tech|| Shortcut key's Uses ||Lecture 02||20% payout to @siz-official || by @cryptokethor 17-10-2021
Asslam-o-alekum
"Hello my All Steemian's"
How are you guys, i hope you are all well and me also fine allhamdulillah....
First of all I would like to thank this @siz-official community. And specially thank to community @cryptokraz , Who those built such a platform. In which all the people are moving towards progress with success.
Everyone showing their potential. We are moving towards development within this community. That's not just about maintaining your potential. Rather that includes all members within this community. And especially the @owners and @members of this community, everything is possible with their support. And hopefully in the future all the members will continue to show their efforts and progress with their support.
Being part of this community, I introduced my tutorial within this community. In which, I am extremely grateful to this community. Those who liked his first post ie the first lecture, ranked second among the top five posts. I am once again very grateful to this community, and to the honor of this community, who loved my first lecture.
Before moving on to today's second lecture, I would like to share with you my first lecture.
"So let's start"
Lecture No. 2:
The Shortcut key's Uses procedure
What:
A list of useful keyboard shortcuts that are not menu-basedWhy: Learning the Keyboard shortcuts will drastically improve your efficiency when working in excel.
Note:
Not all keyboard shortcuts will work in precisely the same way on Excel for Mac. In general, the "Apple key" replaces the "Control" key for most commands.
General Key's
| New file | Ctrl + N |
|---|---|
| Open file | Ctrl + O |
| Save file | Ctrl + S |
| Move between open workbooks | Ctrl + F6 |
| Close file | Ctrl + F4 |
| Save as | F12 |
| Display the print menu | Ctrl + P |
| Select whole spreadsheet | Ctrl + A |
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Undo last action | Ctrl + Z |
| Redo last action | Ctrl + Y |
| Exit Excel | Alt + F4 |
| Spell Check | F7 |
| Cut | Ctrl + X |
| Copy | Ctrl + C |
| Paste | Ctrl + V |
| Find text | Ctrl + F |
| Recalculate | F9 |
First of all if you draw a table use shor key's..
Alt+H+B+A OR T, for border bold...
I would like to share with you one snapshot for reference....
Copy, past and cut situation..
Navigating key's
| Move to next cell in row | Tab |
|---|---|
| Move to previous cell in row | Shift + Tab |
| Up one screen | Page Up |
| Down one screen | Page Down |
| Move to next worksheet | Ctrl + Page Down |
| Move to previous worksheet | Ctrl + Page Up |
| Go to first cell in data region | Ctrl + Home |
| Go to last cell in data region | Ctrl + End |
| Data Region Left | Ctrl + Left Arrow |
| Data Region Right | Ctrl + Right Arrow |
| Data Region Down | Ctrl + Down Arrow |
| Data Region Up | Ctrl + Up Arrow |
| Select Whole Data Region | Ctrl + Shift + 8 |
| Move to Next Sheet | Ctrl + Page Down |
| Move to Prior Sheet | Ctrl + Page Up |
| Access Drop down menu | Alt + Down/Up Arrow |
| Zoom in / out | Ctrl + mouse scroll |
|---|
Formatting Text In Worksheet
| Bold toggle for selection | Ctrl + B |
|---|---|
| Italic toggle for selection | Ctrl + I |
| Underline toggle for selection | Ctrl + U |
| Strikethrough for selection | Ctrl + 5 |
| Change the font | Ctrl + Shift + F |
| Change the font size | Ctrl + Shift + P |
| Apply outline borders | Ctrl + Shift + 7 |
| Remove all borders | Ctrl + Shift + Underline |
| Wrap text in same cell | Alt + Enter |
If you add one Row and coulm's of this sheet just use "ctrl & +" then open the one window bar sheet and see below procedure...
Formatting Cells
| Format cells | Ctrl + 1 |
|---|---|
| Select font | Ctrl + Shift + F |
| Select font size | Ctrl + Shift + P |
| Format as number | Ctrl + Shift + 1 |
| Format as date | Ctrl + Shift + 3 |
| Format as currency | Ctrl + Shift + 4 |
| Format as percentage | Ctrl + Shift + 5 |
Editing/Deleting Text
| Delete one character to right | Delete |
|---|---|
| Delete one character to left | Backspace |
| Edit active cell | F2 |
| Cancel cell entry | Escape Key |
Highlighting Cells
| Select entire worksheet | Ctrl + A |
|---|---|
| Select entire row | Shift + Spacebar |
Select entire column Ctrl + Spacebar
Manual select |Shift + Arrow Key
Inserting Text Automatically
| Autosum a range of cells | Alt + Equals Sign |
|---|---|
| Insert the date | Ctrl + ; (semi-colon) |
| Insert the time | Ctrl + Shift + ; (semi-colon) |
| Insert columns/rows | Ctrl + Shift + + (plus sign) |
| Insert a new worksheet | Shift + F11 |
Thanks for Visiting My Post If You Want To Know More About Me Follow This Link Below:
Special Thanks to...
@cryptokraze
@vvarishayy
@suboohi
@arie.steem
Regards @cryptokethor
You should only use the #club5050 tag when your power-ups at least equal, or better exceed, your cash-outs and transfers away over the past 7 days.
cc @cryptokraze @vvarishayy
Noted.
We are looking for the powerups We will keep a deeper look over the powerups and cash out of the members and will try to encourage them to do more and more power ups. Thank you.
Noted.
We will make sure that majority of the SIZ Community members will join #club5050 and we are working on structure to provide special support to member following club5050 rules.
Thank you for highlighting this case, we will check others as well and instruct them accordingly.
SIZ is fully committed to #club5050 initiative.
@steemcurator01 As far as I understood from the @steemitblog post, the club 5050 starts in November. Now authors are writing posts in large quantities and put this tag. So all the same, is the start in November or is the club 5050 program already in operation? I would like to clarify how best to increase strength: with a larger amount, but less often, or every seven days and the amount of the increase does not matter? Many authors do not withdraw funds at all, but increase the strength. I don't increase strength often, but a lot. That is why I am interested. Thank you in advance.
#Club5050 started last week. But for the November Community of the Month selections, participation in #club5050 will be a key element in which communities are chosen.
Ок, thank you.
Congratulations you have been selected in the best picks of the day.
#club5050
Thanks a lot for appreciate and selected me.... Jazakallah
Good post dear friend keep it up bro.