Excel Shortcuts : The Basics Explained

This is a fast paced society which continually longs for infinite data and time. Organizing figures and numbers is why Microsoft Excel was designed. It allows people to create helpful tables and spreadsheets which can be used for many programs and business purposes. Making presentations which involve numbers and figures is made easy.

For people who are familiar with Microsoft Excel, it offers many great features for individuals and businesses, but it is also a complicated program. It can become very time consuming to constantly move things from one cell to another, flip back and forth between worksheets, and manually insert dates and equations. Bearing that in mind, Microsoft Excel has designed many great shortcuts to save you time when designing spreadsheets.

Microsoft Excel works well to simplify the process of designing spreadsheets with a multitude of useful shortcuts. If you are trying to move forward from one worksheet to the next, instead of scrolling down and clicking on them individually, you can click ctrl + page up. Conversely if you need to go back, you can click ctrl + page down. This short cut is very handy for those who are working with more than one worksheet and are showing of facets of each comparatively.

If you are viewing your worksheet and need to minimize it, you can click ctrl + F9 to do so. Once it is minimized, if you want to bring it back to the full sheet size, you can click ctrl + F10. Other shortcuts which are useful in Microsoft Excel include bringing up a backstage view of a worksheet in order to print it. You can click ctrl + P for this option.

If you are adding information to a cell, you can click ctrl + shift + semicolon to insert the time into a cell. If you want to insert the date, you can simple click ctrl + semicolon. If you need to add up all the number values which are in the cells of a particular column, assuming there are no gaps in the column, you can click alt + =. You can add a hyperlink into a cell by clicking on the cell and then pressing ctrl + K.

You can also find short cuts associated with the help pane. For displaying the help pane or hiding the help pane ribbon once it has been displayed you can click ctrl + F1. If you want to place a chart into a selected range, you can press alt + F1. With these shortcuts you can save time for yourself or your company when constructing your worksheets.

Now try – Excel Training