Skip to main content

Exciting keyboard shortcuts that you can try now

Save Your time with Shortcuts!

Useful shortcuts
Keyboard Shortcuts that will make you a PRO


Let's get started.


Ctrl + A - Select All


Ctrl + B - Bold


Ctrl + C - Copy


Ctrl + D - Fill


Ctrl + E - Align Center


Ctrl + F - Find


Ctrl + G - Go to a specific page or bookmark


Ctrl + H - Replace


Ctrl + I - Italic


Ctrl + K - Insert a hyperlink


Ctrl + N - New workbook


Ctrl + O - Open


Ctrl + P - Print


Ctrl + R - Nothing right


Ctrl + S - Save


Ctrl + U - Underlined


Ctrl + V - Paste


Ctrl + W - Close


Ctrl + X - Cut


Ctrl + Y - Repeat


Ctrl + Z - Cancel


F1 - Help


F2 - Edition


F3 - Paste the name


F4 - Repeat the last action


F4 - When entering a formula, switch between absolute / relative references


F5 - Goto


F6 - Next Pane


F7 - Spell Check


F8 - Extension of the mode


F9 - Recalculate all workbooks


F10 - Activate Menubar


F11 - New graph


F12 - Save As


Ctrl + : - Insert the current time


Ctrl + ; - Insert the current date


Ctrl + " - Copy the value of the cell above 


Ctrl + ' - Copy the formula from the cell above


Shift - Offset Adjustment for Additional Functions in the Excel Menu


Shift + F1 - What is it?


Shift + F2 - Edit cell comment


Shift + F3 - Paste the function into the formula


Shift + F4 - Search Next


Shift + F5 - Find


Shift + F6 - Previous Panel


Shift + F8 Add to the selection


Shift + F9 - Calculate the active worksheet


Shift + F10 - Popup menu display


Shift + F11 - New spreadsheet


Shift + F12 - Save


Ctrl + F3 - Set name


Ctrl + F4 - Close


Ctrl + F5 - XL, size of the restore window


Ctrl + F6 - Next Workbook Window


Shift + Ctrl + F6 - Previous Workbook Window


Ctrl + F7 - Move window


Ctrl + F8 - Resize Window


Ctrl + F9 - Minimize the workbook


Ctrl + F10 - Maximize or Restore Window 


Ctrl + F11 - Inset 4.0 Macro sheet


Ctrl + F1 - Open File


Alt + F1 - Insert a graph


Alt + F2 - Save As


Alt + F4 - Output


Alt + F8 - Macro dialog


Alt + F11 - Visual Basic Editor


Ctrl + Shift + F3 - Create a name using names of row and column labels


Ctrl + Shift + F6 - Previous Window


Ctrl + Shift + F12 - Printing


Alt + Shift + F1 - New spreadsheet


Alt + Shift + F2 - Save


Alt + = - AutoSum


Ctrl + ' - Toggle value / display of the formula


Ctrl + Shift + A - Insert the argument names in the formula


Alt + Down arrow - Automatic view list


Alt + ' - Format style dialog


Windows key + D - Show desktop

Comments

Post a Comment

Popular posts from this blog

5 Android tips and tricks that you didn't know about

We all are using smartphones. Smartphone is the thing that can do anything we want. There is also a saying that- There is always a best way of doing everything And in fact, here are a few Android tricks that you didn't know about. 5 cool Android tips and tricks that you didn't know about 1. Face unlock Now-a-days most smartphones have this feature. But you might be using the default settings of it. It actually stays on the lock screen even if your face matches. And you have to swipe it again to the home screen. To avoid this, there is an option in Face unlock "Stay on lock screen after unlocking". By default it will be activated. You can turn it off now. So that you can be directed to the home screen instantly after face recognition. Quite time saving, isn't it? 2. Schedule power on/off We use smartphones alot on daily basis. Upon regular usage your device might get slower. Also your battery performance will be slower. We can turn off/switch off our device for som
4 comments
Read more

5 Easy tricks to manage your smartphone's Internal storage like a PRO

The first ever smartphone was invented in the year 1992, by IBM and it was released for purchase in the year 1994. It was called as the Simon Personal Communicator(SPC). From the past till now, people are facing Storage issues in their smartphones. And they feel like Grrr. WHY this is happening always?! One fine day I was using my smartphone and I got a notification stating that "Storage running out! Delete unwanted files and free up some space". I was literally frustrated because I don't have any bigger files or videos in my phone. But still my Internal Storage was full. I didn't knew why! And now here I'll show you that how you can free up your Internal Storage without rooting or any other third party applications to get installed to your device. So let's get started.  First you all might be using WhatsApp. Right! So if you are using WhatsApp for a long time, you need to know this trick. So you can clear some bulky files from WhatsApp. Follow these steps...
2 comments
Read more