Microsoft Excel Shortcuts

It is so much easier to use keyboard shortcuts than using mouse for every command. So for excel, if the shortcut keys are known it will be so much helpful. So here are the list of the shortcuts that are used in excel.

F1: Opens a help task pane

F1 + Ctrl: Opens or closes the help window

F2: To edit the text in the active cell

F2 + Shift: To write a comment in the active cell

F2 + Alt: Opens the save as dialog box

F3 + Shift: opens the insert dialog box
F3 + Ctrl: Opens the define name dialog box
F3 + Shift + Ctrl: Opens the create name dialog box
F4: To redo the last command
F4 + Ctrl: To close the workbook window
F4 + Alt: To close the excel program
F5: Opens the Goto dialog box
F5 + Ctrl: brings back to the first level of workbook
F6: To shift between help taskbar and the excel window
F6 + Shift: To goto the previous square in the open worksheet
F6 + Ctrl: If more than one workbook is open to switch between them
F7: To open spelling correction window
F7 + Ctrl: When workbook window is not maximised it will move the window
F8: To activate / deactivate extended mode
F9: Will calculate all the worksheets in all open workbooks
F9 + Shift: Will calculate the active worksheet
F9 + Ctrl: To Minimise the workbook window
F10: Will select the menu bar
F10 + Ctrl: To open minimised window
F11: Will create a chart using the current range
F11 + Shift: To select a new worksheet
F11 + Alt: To switch between visual basic editor and the worksheet
F11 + Alt + Shift: Opens microsoft script editor
F12: Opens save as dialog box
F12 + Shift: Saves the active workbook
F12 + Ctrl: To open the Open dialog box
F12 + Ctrl + Shift: Opens the print dialog box

Solving the 'Failed to load JVM DLL\bin\server\jvm.dll' Error in Android Studio and PyCharm: Easy Tips and Tricks

Are you experiencing the dreaded 'Failed to load JVM DLL\bin\server\jvm.dll' error when trying to launch Android Studio or PyCharm? Don't worry, you're not alone. This common issue can be caused by a variety of factors, but there are a few simple tips and tricks you can try to resolve it. First, make sure that you have the latest version of Java installed on your computer. If you're unsure, you can download the latest version from the official Java website. Next, try reinstalling the JDK (Java Development Kit). This can often fix issues with the JVM DLL. Another solution is to add the JDK path to your system environment variables. This can be done by going to the 'Advanced system settings' on your computer and then 'Environment Variables'. If none of these solutions work, another thing you can try is using the '-Xint' command line option when launching Android Studio or PyCharm. This will run the JVM in interpreted-only mode, which can help r...

Minecraft - Pocket Edition - $4.91 game for free

Mine Craft, a widely known game name worldwide. It is one of the most favorite games in the world. This game is now available for android mobile. Mine craft - pocket edition is all about building and surviving. This game is mostly created based on graphical blocks. Google play store has this game up for $4.91. ETT is giving away the game absolutely for free. Download Minecraft - Pocket Edition from the bellow link. Minecraft - Pocket Edition

Download Apple Mac Theme for Windows

Most of the computer users in the world use clone PCs other than apple mac. So none of them gets the feeling of using an apple mac operating system. There is no easy way to use apple mac OS in the general clone PCs, but the user interface can be made like apple just by using this apple mac theme. This apple mac theme is very easy to install and use. It can be installed normally.

Easy Tricks And Tips

Search This Blog