94. Excel: Complete list of Keyboard Shortcuts: Categorywise
This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands.
FREQUENTRLY USED SHORTCUTS
If you're new to…
93. Excel: General Keyboard Shortcuts
MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel.Ctrl + A − Selects all contents of…
92. Pivot Tables
A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers…
91. Data Tables
In Excel, a Data Table is a way to see different results by altering an input cell in your formula. Data tables are available in Data Tab » What-If analysis dropdown » Data table in MS Excel.Data Table with Example
Now, let us see…
90. Pivot Charts
A pivot chart is a graphical representation of a data summary, displayed in a pivot table. A pivot chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart at the same time, you can’t create a…
89. Simple Charts
A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets. Charts generated by early spreadsheet products were quite crude, but thy have improved significantly over the years.…
88. Securing Workbook
We can apply security to the workbook by the concept of protection available in the Review Tab of ribbon. MS Excel's protection-related features fall into three categories.Worksheet protection − Protecting a worksheet from being modified,…
87. Translating Worksheets
You can translate the text written in a different language, such as phrases or paragraphs, individual words (by using the Mini Translator), or translate your whole file with MS Excel 2010.Translation is available in the review tab of the…
86. Email Workbooks (Spreadsheets)
Excel allows you to email the workbook very easily. To email the workbook to anyone, follow the below mentioned steps.Choose File » Save and Send. It basically saves the document first and then the emails.Click on Send using…
85. Printing Worksheets
Quick Print
If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are two ways in which we can use this option.Choose File » Print (which displays the Print pane), and then click the…