Shortcut Keys for Google Sheets - Part 2
Hello Friends,
This is Amey Kulkarni from Amey Knowledge Hub.
In this Blog I will Share Common Keyboard Short cut for Google Sheets. Google Sheets are the another version of Excel. These sheets automatically gets saved in Google Drive of your Google Account.
So Let's begin...
Format cells |
|
Bold |
Ctrl + b |
Underline |
Ctrl + u |
Italic |
Ctrl + i |
Strikethrough |
Alt + Shift + 5 |
Center align |
Ctrl + Shift + e |
Left align |
Ctrl + Shift + l |
Right align |
Ctrl + Shift + r |
Apply top border |
Alt + Shift + 1 |
Apply right border |
Alt + Shift + 2 |
Apply bottom border |
Alt + Shift + 3 |
Apply left border |
Alt + Shift + 4 |
Remove borders |
Alt + Shift + 6 |
Apply outer border |
Alt + Shift + 7 |
Ctrl + Shift + 7 |
|
Insert link |
Ctrl + k |
Insert time |
Ctrl + Shift + ; |
Insert date |
Ctrl + ; |
Insert date and time |
Ctrl + Alt + Shift + ; |
Format as decimal |
Ctrl + Shift + 1 |
Format as time |
Ctrl + Shift + 2 |
Format as date |
Ctrl + Shift + 3 |
Format as currency |
Ctrl + Shift + 4 |
Format as percentage |
Ctrl + Shift + 5 |
Format as exponent |
Ctrl + Shift + 6 |
Clear formatting |
Ctrl + \ |
Comments
Post a Comment
If you have any doubts, please let me know in comment below