Control Office at your disposal

Office tips

Sometimes Microsoft 's Office suite is like a nice monster - like Godzilla. When you are on your side, it is a powerful ally. But also when it floated rage devastated all your files! Here's how to overpower the "beast" Office.

Past the Word CANVAS

Undoubtedly the most annoying new feature (introduced in Word 2002) is the Drawing Canvas, which denies the creativity of both newcomers and many years of experience. Whenever you use a tool in Word 2002 or 2003's Drawing toolbar (or press Insert.Picture.New Drawing), Word insists on creating a box - called "canvas" - to hold the image. That graphics. When you place drawings, lines, squares, ovals or a certain image into the canvas, Word will see them as a group, so you can move or resize them as a block or addition. quick connections between elements. However, Canvas is not convenient for redesign.

To remove the Drawing Canvas, click Tools, Options, General, and uncheck Automatically Create Drawing Canvas When Inserting AutoShapes. To move or scale drawings in a group, select these drawings by clicking and clicking on them, then select Draw.Group on the Drawing Toolbar. If you need to use quick connections, click Insert.Picture.New Drawing to place a large and rough Drawing Canvas inside your polished document.

Put it back in My Places Bar

Whenever you open a file in an Office XP or 2003 application by clicking File or Open or clicking -O, a list of icons also appears in the left pane.The My Places Bar utility lets you open folders with just one click;But despite being top ranked in terms of time savings, this feature has a rather bad interface.To add a folder to the My Places Bar, select that folder and click Tools.Add to "My Places".To display ten small folder icons on My Places Bar instead of the five large icons (Figure 1), right-click the bar and select Small Icons.You can rearrange folders in the bar by right-clicking a folder and selecting Move Up or Move Down, one step at a time.

The biggest problem with My Places is that it is full of errors. If you have removed some icons from the list, the Move Up and Move Down options will appear grayed out in the menu. When this happens, you want to rearrange the icons you have to go to the Registry to edit. Before doing so, back up the Registry (See April 2003, Review 2003, page 106 for detailed instructions).

When you're done backing up, click Start, Run, type regedit, and press. The control in the left pane goes to HKEY_CURRENT_USER SoftwareMicrosoftOffice11.0CommonOpen FindPlaces (in Office XP, the fifth key is 10.0, not 11.0). Under both the StandardPlaces and UserDefinedPlaces keys, you'll discover items for each My Places icon. Select the icon you want to appear first on the My Places Bar, double-click the Index item in the right pane, replace its 'Value data' with 1, and click OK. (If there is no Index item, right-click the right pane, select New.DWORD Value, type Index, and press). Repeat these steps for My Places icons, assign each one a different Index value (the value '0' will cause the icon to not appear, if all icons are set to '0' 'Desktop will appear.' The next time you open the Office with the My Places Bar is displayed, the icons will appear in the order that you specified in the Registry.

Assign Word a new font

You probably know how to use Word styles to simplify long document editing.However, the typeface is like a luxurious mound on the neck, and Word's default typefaces seem inappropriate: Type a line in the document, and select Heading 1 from the Style drop-down list (usually located on the left of the Formatting toolbar);Word will make that line of text with Arial type 16 bold.Select heading 2, the line will appear in bold italic - an easy format to anger the typographers in print.

Fortunately, Word built-in fonts are easy to customize. In Word XP or 2003, simply select format.Styles and Formatting, click on the down arrow that appears when you move the cursor on the font you want to change, and select Modify (or Modify Style). In Word 2000 and 97, click Format.Style, select that style immediately, and choose Modify. In all versions of Word, use the Formatting options to make the changes you want. Click the Format button in the bottom left corner of the Modify Style dialog box, and make further changes to that font or other typefaces; then click OK (see Figure 2). Check Add to Template and click OK again. From here on, all new documents will follow the format of the font you have chosen.

Redefine Word

The difficulty in setting the upper margin of a Word document is to make the first (header) and the first line of text appear where you want it, just as long as you used an IBM typewriter. Selectric II. Forget about estimating according to Microsoft documentation, here is a summary of the margin in Word.

Word leaves a blank space at the top of each page of the document to use for the head and space at the bottom of each page for the footer. When you click File.Page Setup, you can tell Word how much the top margin is, and how far away it is from the edge of the page (the position of the settings and the terms that define them vary depending on the session). Word version).

When formatting a page, Word translates it to a Header From Edge range (the page edge to the top). This Header From Edge range is usually 0.5 inches. Then the program will include any titles you have defined - text, image . If the last line of the header has Space After setting, for example 18 points, Word will reserve one. Approximately 18 points added at the end of the first part. Finally, Word begins to put the first line of text on the page. When the line is placed, Word checks to see if the distance from the first line to the top of the page is smaller than the Top Margin setting (in most cases, the default Top Margin is 1 inch.) ). If this distance is smaller than Top Margin, Word will translate the first line so that the Top Margin is left clear.

In Word's "word" distance, Header From Edge measurements are 'Exactly' (correct), and Top Margin is 'At Least'. Leg measurements are the same: Footer From Edge is 'Exactly', while Bottom Margin (bottom margin) is 'At Least'.

So if you can't find the reason why Word translates the first line of the page lower than the place you want to place, try reformatting the contents of the header.Don't try to minimize the Top Margin setting - it won't work.

BETTER DATA FORMAT IN EXCEL

One of the most embarrassing things for new Excel users is to format the data, often users have to look at each cell to reset the wrong format.Here are a few tips to help you "tame" Excel, forcing it to format data exactly as you want it from the moment you enter it.
• To enter a value with the currency format, type a dollar sign ($) in front of the value to enter.
• To enter a value in fraction format, type a 0 and a space before the fraction. For example, enter "0 1/2" instead of "1/2", Excel will understand the need to display the value in fractional format instead of the date format "01-Feb".
• To enter a value with a percentage format (percentage), type the% sign after your value (eg 70%).
• To enter a numeric string in text format (Text), type a sign 'in front of that string. This tip is especially useful because Excel is always "overly intelligent" when understanding full-digit strings is numeric and automatically formats them in numeric style. The first series of numbers with zero will be cut off all necessary zeroes. If you enter code 08053, Excel will format the number and display only 8053. To force Excel to format the string in text style, type '08053. (For numeric strings that are too long, Excel switches to the exponential display, for example the string 123456789012 will be converted to 1.23457E + 11).

"Fire fighting" measures
For Excel-formatted cells, even if you format them in a text style, their display remains unchanged. To avoid having to retype from the beginning, do the following (note that this method only helps you break the "itchy eye" hat format, but does not save the first 0 numbers that Excel has cut):
- Select (black out) the cell to be converted to text format; Select the Format / Cells menu, switch to the Number tab.
- Select the Text in the Category list and then click the OK button.
- Click the box to convert the format, press F2 and press ENTER.ÿ
Nguyen Anh Tuan
nguyen_anh_tuan@yahoo.com

Drifting shape in Word

To insert a drawing into your Word document, simply press Insert.Picture.From File, select the correct file, and the image appears.In most cases, you will get exactly what you want: a picture inserted in the text.Word creates interleaved images in the same way as creating large characters.If you type the character in front of the image, it will be pushed away like in the case of text.If you center a line with an insert image, it will appear in the middle of that line.You can even draw a box around it or under it, just as you would with a character.

However, sometimes you don't want your drawing to work like a character. Specifically, you may want the text to appear around the image. The simplest way for Word to arrange text around the image is to make the image float. When the image floats, Word takes it out of the text on the page, and places it in a virtual plane, often called the "drawing layer", located below or above the text.

To make the image float, right-click it and choose Format Picture. On the Layout tab, select 'Wrapping style' as Square or Tight, and click OK (see Figure 3). Word will paste the image in a drawing layer and wrap the text around it. When moving images in the drawing layer of a document, Word will obey the order to rearrange the text, creating space for the image.

Automatically protect with Password

Do you often create password protected documents and spreadsheets? Or do you often forget to password protect?

There is a way to ensure that document protection is always done using Word and Excel templates. In this way, every new document or spreadsheet using this template is password protected.

To create a password protected template in Word or Excel, open a new document, click File, Save As, and select Document Template (in Excel only select Template) in the 'Save as type' dialog box near the bottom ( in Word 97 or 2000 is 'Files of Type'). Type a name for your new template, then click OK. To install a password in version 97 and 2000 of Word and Excel, click Tools. Options.Save; In XP and 2003 versions, click Tools, Options, Security (Figure 4). Enter the password to open this file (and if you prefer, enter another password for modifying it); then click OK.

The next time you want to create a new and password-protected document or spreadsheet, click Files.Open and select your protected template. The new document will inherit the password of that template.

When you want to change the password of a document in Word 97 or 2000, click Tools.Options.Save and make changes in the password boxes. In Word XP or 2000, click Tools, Options, Security to access the settings.

Print the repeating header

Excel users often wonder how to set up multi-page printing to repeat column headings on each page.If the title you want to print is also a column header in the first row of the spreadsheet, it is easy to make them appear on each printed page.
First, make sure at least one row in your spreadsheet contains the title you want to print. Then click File.Page Setup.Sheet, and click the Collapse Dialog icon on the right of the 'Rows to repeat at top' box. Back in the spreadsheet, you will see your cursor has become an arrow pointing to the right. Click and drag the arrow on the rows containing the text you want to appear at the top of the printed pages. After selecting, click the Expand Dialog icon located to the right of the dialog box. Click Print Preview to make sure the headers are correct. If everything appears in the correct order (don't forget to check page 2), click Print.

Xuan Cuong