Tutorial Excel : Show Formulas Instead of Results

You can more easily review and troubleshoot a worksheet by changing its display to show the formulas in each cell instead of those formulas’ results. If you want to check the formula for a particular cell, you cannot examine the formula just by looking at the cell because Excel displays the result of the formula instead of the formula. You must click the cell so that Excel displays...

Read More!

Tutorial Excel : Paste a Formula’s Result

You can control the output that a copied formula displays by pasting the formula’s result rather than the actual formula. After you copy a formula that uses relative cell references, when you paste the formula, Excel automatically adjusts the cell references. For example, if the destination cell is one row down from the original cell, Excel adds 1 to the value of each row...

Read More!

Tips Excel : Create Custom Date and Time Formats

You can enhance your worksheet display of dates and times by creating your own custom date and time formatting. Date and time formats determine how Excel displays data values and time values in a range. For a date, the date format determines whether Excel displays the value with the year, month, date, or all three, and whether you see short values such as Fri or long values...

Read More!

Tips Excel : Create Custom Numeric Formats

You are not limited to predefined numeric formats in Excel; you can create a custom cell format that displays information just how you want it. The predefined numeric formats give you a lot of control over how your numbers are displayed, but they have their limitations. For example, no built-in format enables you to display a number such as 0.5 without the leading zero, or...

Read More!

Excel : Convert a Workbook to a PDF File

If you want to share an Excel workbook with another person who does not have Excel, you can save that workbook as a Portable Document Format (PDF) file. Microsoft Office is by far the most popular productivity suite, and Microsoft Excel is by far the most popular spreadsheet program. However, although this means that many people have Excel, it does not mean that everyone...

Read More!

Repair a Corrupted Workbook File Excel

If you have an Excel workbook that you can no longer open because the file has become corrupted, Excel offers a repair option that should enable you to fix the file. Excel workbooks rarely have problems and they generally open successfully. However, a hard disk error or memory error could create a problem that corrupts the file. When that happens and you try to open the workbook, Excel...

Read More!

Increase the Number of Recent Documents MS Excel 2010

You can make it easier to find the workbooks you use most often by increasing the number of files that Excel displays on its Recent list. When you click the File tab and then click Recent, Excel displays a list of the workbooks that you have used most recently, and clicking an item in the list opens that workbook. The Recent list is therefore a quick way to open a file, but...

Read More!

Export Ribbon Customizations to a File Ms Excel 2010

You can make it easy to apply Ribbon and Quick Access Toolbar customizations on another computer by exporting your own customizations to a file. Customizing the Ribbon or the Quick Access Toolbar is not a difficult process, but it can be time-consuming, particularly if you want to make a substantial number of changes. If you use Excel 2010 on another computer, it is likely...

Read More!

Customize the Ribbon Microsoft Excel 2010

You can improve your Excel productivity by customizing the Ribbon with extra commands that you use frequently. Keep in mind that you cannot modify any of the default tabs and groups in Excel, other than hiding tabs you do not use.  Instead, you customize the Ribbon by adding a new group to an existing tab, and then adding one or more commands to the new group. Alternatively,...

Read More!

Customize the Quick Access Toolbar Excel 2010

You can make Excel easier to use by customizing the Quick Access Toolbar to include the Excel commands you use most often. Because you launch Quick Access Toolbar buttons with a single click, adding your favorite commands to the toolbar saves you time. By default, the Quick Access Toolbar contains three buttons — Save, Undo, and Redo — but you can add any of hundreds of Excel commands. In...

Read More!