Showing posts with label Computer Tips. Show all posts
Showing posts with label Computer Tips. Show all posts

Tips to add Picture into Header/Footer in Excel?

Author: Tom4u // Category: , , , , , ,

In MS excel header and footer option is used to display the repeated graphics or text on the top or button of each pages in a document. You can insert a picture (company logo or other related picture) in the bottom or top margin of each page. For reference, you can add the data, time and path for where you saved excel file on your computer or on any network server. Both the header and the footer are displayed in print layout view and save your time to enter the same items in pages again and again. You can use the same header and footer throughout a document or change the header and footer for part of the document.

You can leave the header or footer for the first page and can also use different headers and footers on odd and even pages or for part of a document.

To apply header or footer, follow these steps.

Select "Header and Footer" from View menu, "Header and Footer" Floating Toolbar will appear. The header and footer sections of document are also activated.

Now under Header/Footer tab, click on Custom Footer button then select left section.

To insert the picture, click on Picture icon (the 2nd icon from the right side) to select the company logo that you want to add.

Select other options if required, for example you can add date, time file name and file path also.

Now click Ok button to finish the process.

If you face any kind of problems with you computer then go for Computer Repair

Comments (1 )

Acrobat Reader shortcut keys with detail

Author: Tom4u // Category: , , , ,
Function keys

F1 - Use to give the help of any windows panel
F3 - Use to Find next search result
F5 - Apply to select the document list panel
F6 - Use to open/close the document list panel
F8 - use to view/close main tools bar list
F9 -use to view/close main menu bar
F10 - Use to select the main menu bar
Ctrl+F4 - Use to close the current file
Ctrl+F6 - Move through next open document
Ctrl+Shift+F6 - Move back to open document
Shift+F3 - Use to Find previous search result
Shift+F6 - Select the previous open page
Shift+F8 - Use to select main tools bar list
Shift+F10 - Press keys to open context menu

Shortcut keys

Up Arrow Button - Scroll up the active document
Down Arrow button - Scroll down the active document
Ctrl+Hyphen - Use to Zoom out the active page
Ctrl+equal sign (=) - Use to Zoom in the active page
Alt+Right Arrow button - Use to Next view
Alt+Left Arrow button - Use to previous view
Right Arrow button - Move to next page in active document
Left Arrow button - Move to back page in active document
Page Up - Move to the previous screen
Page Down - Move to the next screen
Ctrl+Shift+W - Apply to close all open windows
Ctrl+Spacebar+click on active page - Zoom the active page for temporarily
Ctrl+Home - Go to home page of document
Ctrl+End - Go to last page of document
Ctrl+A - Use to select the all pages
Ctrl+Shift+A - Use to deselect the all pages
Enter - Scroll down the pages
Ctrl+0 - Use to adjust the document
Ctrl+1 - Use to view actual document size
Ctrl+Q - Quit the active document
Ctrl+L - To view the document in full view
Ctrl+Shift++ - Move the page clockwise
Ctrl+Shift+- - Move the page counter clockwise

If you face any kind of problems with you computer then go for Computer Repair

Comments (0 )

Print Envelopes and Labels in Word

Author: Tom4u // Category: , , , ,
Word provides a suitable way to print envelopes and labels. You can print mailing and return addresses on an envelope, or addresses on a mailing label.

To create and print an envelope, follow these steps.

1. Choose Envelopes and Labels from the Tools menu. The Envelopes and Labels dialog box will appear as shown below.
2. Click the Envelopes tab to display options of Envelopes.
3. Enter (or Edit) the mailing address in the Delivery address box.
4. Enter (or Edit) the return address in the Return address box Or select the Omit check box to omit a return address.
5. Click Options button to specify the envelope size, the type of paper and other options. Click "Add to Document" button to add or attach the envelope to the current document for later printing or editing.
6. Click Print button to print the envelope.

You can also add graphics to the return address of your envelope. To add graphic, follow these steps.

1. Select mailing address in the document.
2. Open the Envelopes and Labels dialog box.
3. Click Add to Document (or Change Document) button.
4. Click the Page Layout view icon in the Status bar.
5. Insert or create the graphic in the document.
6. Position the item on the envelope.

If you face any kind of problems with you computer then go for Computer Repair

Comments (0 )

Useful Microsoft Outlook Shortcut keys

Author: Tom4u // Category: , , , ,
Shortcut keys

Ctrl+A - Apply to select all
Ctrl+B - Apply/Remove bold formatting
Ctrl+C - Apply to copy the selected word
Ctrl+D - Apply to delete any active item
Ctrl+E - Move cursor to Look for box
Ctrl+F - Display the Find what /Forward selected email
Ctrl+G - Apply to run Go to dialog box under calendar view
Ctrl+I - Apply/Remove Italic formatting
Ctrl+J - Apply to open selected items
Ctrl+M - Press keys to create new message
Ctrl+N - Press keys to send new email message
Ctrl+O - Press Keys to open new file
Ctrl+P - Press Keys to display Print dialog box
Ctrl+Q - Apply to set email as read
Ctrl+R - Press Keys to replay selected message
Ctrl+S - Save the active file
Ctrl+U - Press Keys to apply/remove underline
Ctrl+V - Press Keys to paste the clipboard values
Ctrl+X - Press Keys to cut the selected word
Ctrl+Y - Press Keys to run Go to Folder
Ctrl+Z - Apply to undo the previous command
Ctrl+1 - Press keys go to Mail
Ctrl+2 - Press keys go to Calendar
Ctrl+3 - Press keys go to Contacts
Ctrl+4 - Press keys go to Tasks
Ctrl+5 - Press keys go to Notes
Ctrl+6 - Press keys go to Folder List
Ctrl+7 - Press keys go to Shortcuts
Ctrl+8 - Press keys go to Journal

Function keys

F1 - Use to open help of any windows panel
F3 - Move cursor to Look for box
F4 - Use to display Find dialog box
F6 - Apply to select item in active window
F7 - Use to check spelling in active window
F9 - Use to receive and send email
F10 - Use to select the main File menu bar
F11 - Apply to activate Find a Contact dialog box
F12 - Use to run Save As dialog box.

If you face any kind of problems with you computer then go for Computer Repair

Comments (0 )

Tips Indenting Left and Right Paragraph

Author: Tom4u // Category: , , , ,

The space or distance between the page margin and the text in a paragraph is called indent. These are applied to set the margins of selected paragraph.
In a document, margins determine the overall width of the main text area or in other words, the space between the text and the edge of the page. Indentation determines the distance of a paragraph from either left or right margins. There are six types of indents that can be used in a document. These are:

1. First line indent is the distance between the first line of the paragraph and the left margin.


2. Left indent is the distance between the start of each line of the paragraph and the left margin.


3. Right indent is the distance between the end of each line of the paragraph and the right margin.


4. In hanging indent, the first line of the paragraph is not indented and all other lines start at same distance from the left margin. The first line 'of the paragraph usually starts from the left margin.


To indent a paragraph, follow these steps:-


1. Select the Paragraph you want to indent.

2. Select the "Paragraph" command from "Format" drop down menu; "Paragraph" dialog box appears.

3. Specify values in Left and Right fields of indentation and click "Ok" button of dialog box.

If you face any kind of problems with you computer then go for Computer Repair

Comments (0 )

Top Tips for Protecting Document with Password

Author: Tom4u // Category: , , , , ,
You can protect your document by applying password so that unauthorized person can not display as well as modify your document. You can apply two types of passwords:

Password to open the document:

If it is applied then you have to give the correct password to open the document, otherwise you cannot open the document.

Password to modify the document:

If it is applied then you have to give the correct password to modify the document, otherwise your document is opened but you cannot modify the document. It means that your document becomes read-only.

To apply a password to document, follow these steps.

* Open Save As dialog box by selecting "Save As" command from File menu.

* Click "Tools" button of Save As dialog box and choose "General Options" from drop down menu, "Save" dialog box appears as shown in figure below.

* Enter first password in "Password to open" text box and second password in "Password to modify" text box (if required) and click "Ok" button of dialog box. Microsoft Word will open "Confirm Password" dialog box for the confirmation of passwords. The maximum length of password is 15 characters.

* Re-enter the password to open and password to modify and click "Ok" button of Confirm Password dialog boxes one by one.

* Click "Save" button of Save As dialog box.
If you face any kind of problems with you computer then go for Computer Repair
source: computerfreetips.com
Comments (0 )

Top Tips for Studying for Microsoft Office

Author: Tom4u // Category: , , , ,
Studying for Microsoft Office is not all that difficult if you know where to start. However, most people are clueless at first and need some direction or at the very least some tips to help them study for Microsoft Office. The following tips will help you with your MS Office training.

Tip 1

Start EarlyWhen it comes to Microsoft Office training you want to start early rather than waiting until the last minute. The reason why is because it takes time to learn all you need to learn and you want to take your time absorbing the information and really learning it. If you wait until the last minute to study you may learn enough information to pass the exam but it is unlikely you will have really learned the information.

Tip 2

TutorialsA great way to learn is to use a Microsoft Office tutorial. The tutorial will walk you through the steps you need to follow in order for you to learn everything necessary about Microsoft Office You can use the Microsoft Office tutorial CD to focus on what is necessary and what is not. You will be able to learn in a focused manner which is really important and it will prepare you for the exam.

Tip 3

Practice TestAnother good idea to help you study for Microsoft Office certification is to take practice tests online. Doing this will give you a good idea of how prepared you are and what areas you still need to focus on. Sit down with a timer and start taking a practice test. Then evaluate your score. Doing this will give you a realistic idea of whether you are prepared for the Microsoft Office exam or not.

These are just a few tips to help you study for Microsoft Office. There are of course many other ways you can study for your Microsoft Office certification and you know your study methods best. However, what is most important is that you are prepared for exam and that you put forth all of your efforts in order to pass the test the first time around. By not studying the way you should you could easily fail the test and would have to take it again wasting your precious time and money. So, follow the tips outlined here and you will be prepared for your Microsoft Office exam.

If you face any kind of problems with you computer then go for Computer Repair

Comments (0 )

The Smart Way to Master Microsoft Excel

Author: Tom4u // Category: , , , ,
Microsoft Excel is a spreadsheet and data storage software program that is an important part of the business management process in many organizations. An ability to understand this program and to work with it is essential for all levels from entry to top management. Many organizations list being able to use Excel as a requirement for employment. The ability to master this useful program will benefit anyone involved in business from a job applicant to the CEO of the company.

Excel training exists at many levels also. The software itself includes tutorials designed to get you started. The Microsoft website offers additional training software that is also intended to give a user at least a working knowledge of Excel. For many people, this is as far as they take their training and as a result they both struggle with Excel and fail to realize or utilize its tremendous potential. If you want to get the most out of it, you need to accept its complexity and recognize the need for some serious training. If you are able to reach the point where you can truly say you have "mastered" Microsoft Excel, you will have a leg up on the competition both within and outside of your company.

Microsoft Help or training is offered through a worldwide network of Microsoft Certified Learning Partners. These organizations have passed rigorous Certification examinations administered by Microsoft. There are more than 26,000 Learning Partners in this network. Training is administered in two different manners. There is classroom based training and distant learning. These two methods have become a common choice in most computer based training and educational programs in the last decade. Each individual must evaluate his own situation taking into consideration his budget, his schedule, and his own ideal learning style to make a decision about which is better for him.

Microsoft Excel training is offered by either group. The Microsoft Certified Partners for Learning Services (MCPLS) offer comprehensive hands on instructor led training at sites spread widely over the world. A directory on the Microsoft Excel training home site can guide you to a MCPLS facility in your area. Microsoft Official Distant Learning (MODL) partners provide training platforms that can be delivered directly to your own computer. They provide the back up and technical support needed to complete the training and maximize its results.

It is possible to delve into Microsoft Excel if you have any knowledge or familiarity with spreadsheet applications, but this approach ignores the potential and only skims the surface of what Excel can do for you and your organization. The smart way to master Excel and get the most out of it is to take some formal Excel training from a Certified Partner.

If you face any kind of problems with you computer then go for Computer Repair
Comments (0 )