Category Archives: Spreadsheets

If you want to total the numbers in cells A1 through A5 of an Excel worksheet, you may want to display the sum in cell A7. Select cell A7 and enter =Sum(A1:A5) Alternatively, you can click on A7 and enter … Continue reading →

When you enter percentages in Excel, be sure to enter the numbers as decimals. Excel multiplies all entries in a cell formatted as Percentage by 100. For example, 20 is 20%. To see how this works, enter .2 into cell … Continue reading →

Version 95 – In the last tip we showed you one way to produce an exploded Excel chart. There is another way, though; choose which slice to separate after you’ve already produced the chart. Let’s suppose you have a completed … Continue reading →

Version 95 – If you want to place widely varying Excel data into a pie, doughnut, or three-dimensional pie chart, you’ll find that it can be hard to see the smallest segment. When you insert a chart in a worksheet, … Continue reading →

Version 4.x – AutoSave is a handy Excel feature–one that saves many of us from disaster. Although Excel doesn’t use AutoSave by default, you can easily add it. Choose Tools|Add Ins. Some pamelaannschoolofdance.com generic levitra important guidelines to be followed: … Continue reading →

Versions 4.x, 95 – If you need to use the RANK function with data that’s presented horizontally, you need to enter each cell address. For example, Smoking cigarettes, obesity, poor control of blood glucose levels, and having diabetes mellitus for … Continue reading →

Versions 4.x, 95 – Do you ever need to rank your Excel data? Call on Excel’s RANK function. Let’s say you have a worksheet that contains sales data for your entire sales force, and you need to keep track of … Continue reading →

Versions 4.x, 95 – Would you like to add a picture to the bars of an Excel chart to set them off? Try this, create a chart, then click away from the chart and choose Insert|Object|Microsoft ClipArt. The FDA said … Continue reading →

Versions 4.x, 95 – When you add a label to an Excel chart using a text box, you’ll find that the text box doesn’t move along with the chart. To get around this, open the Drawing toolbar again. Now click … Continue reading →

Versions 4.x, 95 – To add text to an existing chart, first choose View|Toolbars|Drawing to get the Drawing toolbar on the screen. Now choose the Text However, impotence cures in such a situation is rather disadvantageous for the normal menstrual … Continue reading →