Category Archives: Spreadsheets

Months ago, perhaps, we told you that if you need a Toolbar that Excel isn’t currently displaying, you can simply right-click in a blank area of the menu bar, and choose a Toolbar from the list that appears. Well, that … Continue reading →

Let’s say you’re just working away on a multiple-sheet workbook. You suddenly realize that you really should have a sheet between Sheet 1 and Sheet 2. All is not lost. You don’t have to start all over. However, people levitra … Continue reading →

If you’ve heard it once, you’ve heard it a thousand times: YOU SHOULD GET IN THE HABIT OF SAVING YOUR WORKSHEETS. So why don’t you save regularly? Maybe it’s because you need more specific instructions. Press Ctrl + S at … Continue reading →

Welcome to the third in our three-part series on worksheet protection (if you sat through the first two, you deserve this). Let’s say that you WANT other users to change the NUMBERS in a worksheet, but NOT the formulas, so … Continue reading →

When you need to work with multiple sheets in Excel, you may want to make the headers the same on all the sheets. Here’s a little trick that works very well. Hold down the Ctrl key and click the name … Continue reading →

Last time, we explained how you can keep other users from altering charts and pictures in your Excel workbook. This was a fine tip for the artistically minded, but the number-crunchers among you were probably pulling out your hair, screaming … Continue reading →

You can use Excel’s Find and Replace utilities in much the same way you would Word’s. Let’s say that you’d like to find the cell that contains the number $21,987.23. You know it’s in there, but you just don’t know … Continue reading →

Excel offers two ways to calculate the power of a number. Let’s look at both.Click in cell A1 to select it. Enter =22^3 and press Enter. Excel will perform the calculation and report that 22 to the third power is … Continue reading →

If you’re working with a Word document and you run across a need for a small spreadsheet, you can use Excel and then insert the worksheet into the Word document. But if the spreadsheet requirements are minimal, why not use … Continue reading →

In Microsoft Excel, entering a time with more than 60 minutes into a cell may change the cell to the General number format and give you a decimal. If you type 5:62, for example, the cell will pop up with … Continue reading →