Microsoft Excel

How to Display Formulas Instead of Results
When editing an Excel file with multiple formulas, it is sometimes useful to switch between Excel's normal display, which shows the results of the ...
Mon, 23 Jun, 2014 at 3:42 PM
How to Highlight All Cells Referenced by a Formula
When you're working on a worksheet that contains formulas, there is an easy way to quickly navigate through all the cells referenced in a formula: Highl...
Mon, 23 Jun, 2014 at 3:49 PM
Restricting access to an Excel document
Restricting access to an Excel document 1. Click on "File" and then go to "Save As". 2. Choose a location where the file...
Mon, 7 Dec, 2015 at 2:02 PM
Useful Keyboard Shortcuts
Like all other MS Office programs, Excel offers many convenient keyboard shortcuts to help make dealing with spreadsheets easier. Most people know about usi...
Mon, 23 Jun, 2014 at 4:00 PM
How to Create a Reusable Chart Template
When creating a series of charts for a project, such as an annual report, you will usually need to reuse the same basic format. Excel allows you to create...
Mon, 23 Jun, 2014 at 4:55 PM
How to Work With Non-Adjacent Data
Sometimes when working in Excel, you end up with your data not all in one region on the worksheet. Fortunately you can still work with it. When you want to ...
Mon, 23 Jun, 2014 at 5:05 PM
How to Create a Custom List in Excel
One useful feature of Excel is that it automatically fills a row with the names of months or weekdays when you type in the first few items in the row. To d...
Wed, 25 Jun, 2014 at 12:05 PM
How to Name Data Ranges
Sometimes formulas are not as clear as they could be. A formula that looks like '=C2*C5', for instance, is much harder to understand at a glance tha...
Wed, 25 Jun, 2014 at 12:09 PM
How to Automatically Round Large Numbers
Large numbers, such as thousands and millions, are often easier to work with as a rounded number than the exact value. You can set the cells containing larg...
Wed, 25 Jun, 2014 at 12:14 PM
How to Shade Alternate Lines
For a lengthy list, shading alternate rows can improve legibility. This is simple to do with Excel's Conditional Formatting feature, which allows you ...
Wed, 25 Jun, 2014 at 12:31 PM