|
|
|
Adding Text to an AutoShape (DG) |
|
Most people know that you can add textboxes to your worksheet, but don't realize that you can actually add text to any AutoShape. Just follow these steps: |
|
|
|
Using the Drawing toolbar, add your AutoShape as you normally would. |
|
|
|
Right-click the new AutoShape. Excel displays a Context menu. |
|
|
|
Choose Add Text from the Context menu. An insertion point appears within the body of the AutoShape. |
|
|
|
Type your desired text. |
|
|
|
Click somewhere outside the boundaries of the AutoShape, such as within a cell of the worksheet. |
|
|
|
If you later resize your AutoShape, then the text within it is reformatted to fit the new dimensions of the shape. (This behavior is the same that occurs if you resize a textbox that contains text.) |
|
|
|
Retrieve information from a Web page by creating a Web query |
|
Sue Crane, Big Bear Computer Club, CA |
|
|
|
To create a Web query, from the Data menu, rest your mouse on <Get External Data>, then click <New Web Query..>. |
|
|
|
In the New WEb Query Window chose either <Browse Web..> to search for the Web address you want or type in the Web address. |
|
|
|
While still in the New Web Query Window, decide what information you want. You can get all the information, only the tables on the page, or you can choose the tables you want. |
|
|
|
In the third section of the New Web Query Window, decide how much formatting you want to keep. Choose None, Rich Test or Full HTML Formatting. Click OK. |
|
|
|
The Returning External Data Window will open. Choose the cell location where you want to put the data. |
|
|
|
Click OK and, in your spreadsheet, you will see the Web site address and the words "Getting data..." Wait a second or two and the info that was on the Web page will be in your Excel spreadsheet. |
|
|
|
Moving Formulas From One Sheet to Another |
|
Yomar Cleary, Big Bear Computer Club, CA |
|
|
|
Microsoft Excel let’s you convert formula cells to values with a couple of mouse clicks. For example, suppose you want to copy your formula to a new worksheet in Excel or even Microsoft Word, to do so, follow these steps: |
|
|
|
1. Select the range of formulas |
|
2. Right-click, choose Copy |
|
3. Click on the location or worksheet where you want the values placed |
|
4. Open the Edit menu, choose Paste Special, choose Values, click OK |
|
The values are now pasted in the new location. |