Monthly Archives: September 1997

Version 4.x, 95 – If you want to really make your bordered text stand out, you can add some shading. Let’s say you already have some bordered text. Click inside the border and choose Format|Borders and Shading. When the dialog … Continue reading →

Version 4.x, 95 – Although Excel converts fractions to decimals in order to calculate them, it will report results as the nearest fraction. To check this, enter into cell A1 the fraction 0 3/32 In cell A2, enter 0 2/16 … Continue reading →

Version 4.x, 95 – You can enter fractions into an Excel cell and use them in your calculations. The only problem is that you have to be careful about how you enter fractions. For example, if you enter 5/6 and … Continue reading →

Version 4.x, 95 – If you need to print a blank sheet between two or more worksheets that contain your data, you’ll find that Excel ordinarily declines to print a data-free worksheet. However, if you select a group of empty … Continue reading →

Version 4.x, 95 – When you run a spelling check in Excel, you check only the current page. If you’d like to check all the worksheets in a workbook, right-click on one of the Herbal cures are being used for … Continue reading →

Version 4.x, 95 – You’ve generated a rather long numbered list, and now you see that you’d like to organize the list a bit differently. So you select the text in one of the entries and then use the mouse … Continue reading →

Version 4.x, 95 – If you press the End key to get to the end of an Excel row, you’ll get a surprise instead. Pressing the End key simply turns on the End mode. To check out the End mode, … Continue reading →

Version 4.x, 95 – In the last tip, we told you how to check the spelling in all the sheets of a workbook (Right-click on a tab, choose Select All Sheets, and choose Tools|Spelling.) We also said that you need … Continue reading →