Search This Blog

Showing posts with label MS OFFICE. Show all posts
Showing posts with label MS OFFICE. Show all posts

Sunday, May 3, 2009

How to Create your own Keyboard Shortcuts keys in MS Word?

Today tip will help you to create your own keyboard shortcuts keys in MS Word. Before reading this tip, may be you are using only the default shortcuts keys which are available in MS Word application. You can select any specific key combination that you want to use to perform a particular task.

If you are not an expert user then you can take many clicks and lot of menus navigations to perform a basic task. With shortcut keys, you can speed up your working pace without lifting your hands on the keys; otherwise require a conventional mouse to select menus and buttons options. You can create your own keyboard shortcuts for every word command. For example, if you are using Word Count feature constantly then you can assign any key combination like Alt+Z to run Word Count command.

Follow the given steps to create your own shortcuts keys for your favorite command

First click on Start button, go to Program then click on Microsoft Word to run the word page.

Now go to Tools menu and click on Customize option.

Here a small dialog box will appear with title Customize, now click on "Keyboard..." button.

Now again a small dialog box with title Customize Keyboard, the list of all the categories of commands with appear on the left side of the dialog box. You should click on the category that contains the command which you want to assign a shortcut keyboard.

Choose the command you want to assign a keyboard combination on the right side of the customize keyboard dialog box and then click the key you want to create shortcut.

Now click on Assign button to final the shortcuts key combination then close it.

In future whenever you type the keyboard combination, word will work according to that command you have assigned this shortcut.

How to preview the Word documents without opening?

In Microsoft Word, you can preview the document list within Word without having to open the document. This tip is very useful, if you have many word files and are not sure which file contain the information that you need. Almost all versions of Word support this feature to view all word file as preview one by one.

Follow the given steps to preview the word document without having to open the document:

First click on Start button, go to Program then click on Microsoft Word to run the word application.

Now go to File menu and click on Open option to open any word file. Here a small dialog will appear with title "Open".

Now on the right hand side of the toolbar click the down arrow on Views and choose Preview.

This will open the preview pane. Click on any file on the left hand side and preview what inside the file. When you find the file you need just click Open button to open the file.

How to Insert your Digital Signature into Word Documents?

As usual today I have brought a different and surprising tip for you. This tip will increase your knowledge in the field of Computer. In fact you can't do your signature or your official work without papers. But you will be surprised to read this tips how you can insert your Digital Signature into Word Documents. Most people don't give value that there is any technique to sign files electronically and then send via fax or email.

Follow the given steps to insert your signature electronically in Word documents:

First of all scan your signature page and then save image using (.GIF or .JPEG) extension. Now you have scanned image of you signature, save the image on your computer and note that file name where you save it.

Click on Start button, go to Program then click on Microsoft Word to run the word page.

Now go to Insert menu, click on Picture> From File then browses your scanned signature file and click Insert button to add this file in word.

If your signature is not looking so good and its size is wrong then you should rescan your signature then repeat all the steps to insert it again.

To save your signature for reuse in future documents, highlight the signature graphic, and then choose insert AutoText-New. Here a new Create Auto Text dialog box will appear. Name your signature and click ok.

Now just type the name the file of your signature and press Enter to insert your signature in the future or choose insert AutoText-Normal then click on signature name. There is no need of ink, Word jump down in your digital signature.

I think this will help you and soon I will come back with another useful tip for you.

Password-Protect an Excel Spreadsheet?

ere I will provide you some tips regarding how to make excel sheet password protected.

Any time you call the SaveAs method you can include password-protection as an optional parameter. To demonstrate, here’s a script that creates a new worksheet, writes the current date and time in cell A1, and then saves the worksheet as C:\Scripts\Test.xls. On top of that, it password-protects the spreadsheet, giving it the password %reTG54w:

Quote:Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.DisplayAlerts = FALSE

Set objWorkbook = objExcel.Workbooks.Add
Set objWorksheet = objWorkbook.Worksheets(1)

objWorksheet.Cells(1, 1).Value = Now
objWorkbook.SaveAs "C:\Scripts\Test.xls",,"%reTG54w"
objExcel.Quit 

If you’ve done any scripting with Microsoft Excel, this is about as simple a script as you’ll ever write. The only “gotcha” to be aware of occurs in this line of code, where you actually save the file and password-protect it:

Quote:objWorkbook.SaveAs "C:\Scripts\Test.xls",,"%reTG54w" 

Admittedly, there’s nothing fancy about this line of code; you just have to make sure the password (%reTG54w) is the third parameter passed to the SaveAs method. The first parameter is, of course, the file name. The second parameter is the file format. Because we’re using the default format, we don’t need to set a value for the second parameter; however, we do need to include a placeholder for that parameter. That’s what the back-to-back commas (,,) are for: they simply indicate that the value for the second parameter would go here if we actually had a value for the second parameter. By including this placeholder, the password becomes the third parameter, which is exactly what we want.

After you run this script, try to open the file C:\Scripts\Test.xls; you’ll be prompted to enter the password before the file will actually be opened. Incidentally, this will happen even if you try opening the file using a script. (Sorry, but using a script won’t allow you to bypass the password protection.) But can’t you specify the password when you open the file? Of course you can; that’s what happens with this script:

Quote:Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.DisplayAlerts = FALSE

Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\Test.xls",,,," %reTG54w") 

Note that when opening a spreadsheet the password has to be the fifth parameter; thus we have the file name, three placeholders, and then the password. This can be a little confusing, to say the least, but here’s a rule of thumb: just put in one more comma than you have placeholders. In this example, we have three placeholders, so we insert four commas. If we had nine placeholders, we’d insert ten commas. And so on.

But what if you decide later on to remove the password? No problem: simply open the file and set the value of the Password property to an empty string. Here’s a script that does just that: it opens the spreadsheet, removes the password, and then uses the SaveAs method to re-save the file. After running this script, try to open this spreadsheet from within Windows Explorer; you should be able to do so without being prompted for a password.

Quote:Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.DisplayAlerts = FALSE

Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\Test.xls",,,," %reTG54w")
Set objWorksheet = objWorkbook.Worksheets(1)

objWorkbook.Password = ""

objWorkbook.SaveAs "C:\Scripts\Test.xls"
objExcel.Quit 

What if you didn’t want to remove the password, but merely wanted to change it? In that case, just set the Password property to the new password rather than to an empty string. And before you ask, yes, we could have used the Save method here rather than SaveAs. We stuck with SaveAs simply to be consistent with the previous script. We’re also aware that “Consistency is the hobgoblin of little minds.”

Followers