Removes the outline border from the selected cells.Īpplies the Currency format with two decimal places (negative numbers in parentheses).Īpplies the Percentage format with no decimal places.Īpplies the Exponential number format with two decimal places.Īpplies the Date format with the day, month, and the Time format with the hour and minute, and AM or PM.Īpplies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. Unhides any hidden columns within the selection.Īpplies the outline border to the selected cells. Unhides any hidden rows within the selection. Switches between worksheet tabs, from right-to-left. Switches between worksheet tabs, from left-to-right. Microsoft Excel Shortcut Keys List CTRL Combination Shortcut Keys In Excel: Key In this article, I will share the complete list of Microsoft Excel Shortcut Keys. And to do all of these at super speed pace, there are whole lot of MS Excel shortcuts keys that are worth knowing to increase the productivity from using Excel.

Other than that, you can also create pivot tables in Excel, solve optimization problem and make statistical analysisa and use VLOOKUP in Excel to make Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.

You can also create professional reports and dashboard. You can create tools, calculators and simulators with Excel. Many businesses, personal and institutional enterprises have embraced the use of Excel because of its utility and the ability to serve as a visual basic for different applications.Īs a student or as a Enterprenure, Excel is a valauable tools for your daily projects. Since then, it has played a vital role in performing formula based arithmetic and calculations, and other activities that may require mathematical calculations. Excel was first released in the year 1985. It is the most used spreadsheet program in many business activities, classwork and even personal data organisation. Microsoft Excel is one of the most poweerful computer programs because of the key role it plays in many sectors.

Excel shortcut keys in excel