Category Archives: Spreadsheets

Information about spreadsheet software.

Adding shading to bordered text

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

Posted in Spreadsheets | Comments Off on Adding shading to bordered text

Adding fractions

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

Posted in Spreadsheets | Comments Off on Adding fractions

How to enter fractions

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

Posted in Spreadsheets | Comments Off on How to enter fractions

Printing blank data sheets

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

Posted in Spreadsheets | Comments Off on Printing blank data sheets

Running a spelling check on all your worksheets

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

Posted in Spreadsheets | Comments Off on Running a spelling check on all your worksheets

Selecting and moving text

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

Posted in Spreadsheets | Comments Off on Selecting and moving text

Using the End key

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

Posted in Spreadsheets | Comments Off on Using the End key

Adding an element to all the sheets at once

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

Posted in Spreadsheets | Comments Off on Adding an element to all the sheets at once

Viewing, editing formulas

There are two ways to view and edit Excel formulas. If you select a cell that contains a formula, the formula will appear in the formula box right above the worksheet. You can click in the formula there to edit … Continue reading

Posted in Spreadsheets | Comments Off on Viewing, editing formulas

Erasing errors

If you’re entering a number into an Excel cell, and you see that you’ve made an error, all Shape and Texture The extensive advertising that has assisted in tadalafil india cialis ‘s rise of fame has meant that its shape … Continue reading

Posted in Spreadsheets | Comments Off on Erasing errors