Using a Text Box
Summary: There are times when you want to add a note to a cell. It is easy to do this with a Text Box. Here is how to do this:
- On the Insert Ribbon select Text Box.
- Draw a rectangle in your worksheet about the size and shape that you want your text to fill.
- Paste or type in you text.
- Select the text in the text box and use the Mini Toolbar to format the text to an appropriate font size.
- Right click in the text box and select Format Shape. On the Line Color category, select No Line. In the Text Box category you, you can specify the number of columns you would like in the Text Box.
Sorting Protected Worksheets
Back to top
Summary: When you protect a worksheet a number of useful functions are turned off. This includes preventing you from sorting the worksheet. If you do need to sort a protected worksheet you need to change a setting. Here is how to do this:
When you protect a worksheet, Excel prevents users from performing a wide variety of tasks on the data in the worksheet. This includes being no longer able to sort data. However, there may be times when you will want to be able to sort data, but still keep the sheet protected.
There are settings in Excel that allow you to specify what users can and cannot do with a protected worksheet. If you display the Review tab of the ribbon and click Protect Sheet in the Changes group, Excel displays the Protect Sheet dialog box. This dialog box contains a list of check boxes. This enable you to define what the user can do with the worksheet. One of the options is Sort and if you select this option, then users can sort protected data.
Select a cell that contains the text you want to translate.
Summary: Since we live in a global world it is sometimes useful to be able to translate text in Excel to another language. Excel now has a translation tool that will do just that in most of the major languages. Here is how to do this.
- In the Review tab click on Translate.
- The research panel will appear on the left hand side of the window.
- Select the From and To languages.
Excel will then send the phrase out to WorldLingo.com and return a translation of the phrase.
Be Selective with How You Select
Summary: There are numerous shortcuts for selecting text in Microsoft Word. Here are two little known ones that will enhance your productivity.
If you just want to select a single sentence, hold down Ctrl and click on any word. To select an entire table, hold down Alt and double-click.
Back to top
Summary: Here are a series of composing tips to help you prepare a professional PowerPoint presentation.
- Don't copy & paste slides from different sources.
- Keep the design very basic and simple. It shall not distract.
- Pick an easy to read font face.
- Carefully select font sizes for headers and text.
- Leave room for highlights, such as images or take home messages.
- Decorate scarcely but well.
- Restrict the room your design takes up and don't ever let the design restrict your message.
Remember that your slides are only there to support, not to replace your talk! You'll want to tell a story, describe your data or explain circumstances, and only provide keywords through your slides. If you read your slides and if you do it slow and badly, the audience will get bored and stop listening.
Back to top