Daily Archives: March 2, 1998

Apply headers to all sheets

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

Posted in Spreadsheets | Comments Off on Apply headers to all sheets

Keep your hands off my numbers and formulas, too

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

Posted in Spreadsheets | Comments Off on Keep your hands off my numbers and formulas, too

Find and Replace features

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

Posted in Spreadsheets | Comments Off on Find and Replace features