Click on this tool to turn bold on and off. Click on this button to turn italics on and off. Click on this tool to turn underline on or off. Click on the down arrow beside the tool to change the style and color. When you select a block of text, Word displays a semitransparent toolbar called the Mini toolbar.
The Mini toolbar helps you work with fonts, font styles, font sizing, alignment, text color, indent levels, and bullet features. When you see the transparent toolbar appear, simply point to the attribute you want to set and select it with your mouse. To change fonts, you select the new font by its name. Notice how Word displays a sample of each font within the pull-down list so that you can see the font before actually selecting it. Begin typing your text.
NOTE: Notice that Word displays the current theme fonts along with the last few selected fonts at the top of the list for easy access. NOTE: To change existing text, be sure to select the text first and then choose the desired font. If text is selected, as you scroll through the list of available fonts, Word will display the selected text with the currently highlighted font — as a preview.
NOTE: As was the case with attributes, to change existing text, be sure to select the text first and then choose the desired font size. You can also use the following tools both of which are located within the Font section on the Home Ribbon to quickly increase or decrease the font size. Click on this tool to increase the current font size.
Click on this tool to decrease the current font size. Select the new margin setting from the list provided. If you need a margin setting that is not included in this pull-down list, click on Customize Margins….
Select the page orientation from the two diagrams provided. Select the paper size you would like to use. Word is capable of aligning paragraphs, as shown below: Word is automatically set for left alignment. To change the alignment, place your cursor anywhere on the paragraph and select one of the following tools located on the Home Ribbon : Left Aligned Centered Right Aligned Full Justification TIP: Typically the last line of a paragraph is shorter than the rest of the paragraph and may not be justified.
However, if the line is very short, there may be large gaps between words. If you have a shortcut on your desktop, double-click on the Microsoft Office Excel icon to run the application. Although the quickest way of running any MS Office application is obviously through the desktop, you can also access the Start menu which allows you to locate any program available on your system. You will notice that the program window includes many of the standard elements common to other Office applications as well as a few items that are unique to Excel.
The screen can be quite intimidating the first time you see it as there are so many items displayed. Along the top left corner of the screen is the Office Button which provides quick access for creating, opening, saving, printing, preparing, sending, publishing, and closing files.
This button provides the only true menu within Excel The name of current workbook followed by the application name is displayed in the middle of this line. A generic name is given to each new workbook you create Book1.
The second line contains a new feature within Excel Each time you press A, Excel displays corresponding letters for the Ribbon items to help you to continue using keyboard shortcuts to select them.
Along the right side of the screen is the scroll bar used to quickly move vertically within your workbook. There is also a horizontal scroll bar that you can use to move left and right through your workbook. As mentioned, columns are lettered and rows are numbered. The first 26 columns are lettered A through Z. Excel then begins lettering the 27th column with AA and so on. In a single Excel worksheet there are 16, columns lettered A-XFD and 1,, rows numbered The highlighted borders around the document window indicate the columns and rows and are used to identify where on the worksheet you are located since you obviously cannot see an entire worksheet of this size on the screen at one time.
The worksheet itself is located to the right and beneath the borders. This is where you will actually be working and entering information.
The outlined cell the one with the dark borders within the worksheet is referred to as the active cell. Each cell may contain text, numbers or dates. You can enter up to 32, characters in each cell. Towards the bottom of the worksheet is a small Tab that identifies each sheet within the workbook file. If there are multiple sheets, you can use the tabs to easily identify what data is stored on each sheet.
For example, the top sheet could be "Expenses" and the second sheet could be called "Income". When you begin a new workbook, the tabs default to being labeled Sheet1, Sheet2, etc. Along the bottom of the screen is another bar called the Status Bar. This bar is used to display various information about the system and current workbook.
The left corner of this line lists the Mode Indicator which tells you what mode you are currently working in.
Just below and to the left of the vertical scroll bar is the Zoom section. Excel displays the current percentage just to the left of this area. To make working with multiple workbooks less confusing, Excel has included a feature which automatically displays all opened workbooks along the taskbar. Rather than having to access the Ribbon labeled View to switch between opened files windows , you can simply use your mouse to click on the name of the file you want to access directly on the taskbar.
Once selected, that file becomes the active window. R Moves pointer right one column. Z Moves pointer up one row. Y Moves pointer down one row. O Moves one full screen up. N Moves one full screen down. You must know the cell address. Click in this box and type in the cell address to go to. You must press E when done.
You can also use the vertical down the right and the horizontal along the bottom scroll bars to move. Drag the box in the scroll bar to move more quickly. The pointer does not move until you click in the cell to move to. Remember to look at the formula bar for the current cell address. If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large worksheets.
Excel lights up column and row headings as you move from cell to cell. This helps to distinguish the current cell address. This tool displays Page Layout view. This tool displays Page Break Preview. In addition to the three views discussed above, you can create your own custom views discussed in the advanced manual. A small dialog box will open allowing you to choose from a list of saved views. You can clear the Office menu, tabs and current Ribbon from your screen so that you can see more of your worksheet.
To redisplay the screen items, press X. Click in the cell you want to store the data in and then simply begin typing the word s , number or formula. If you make a mistake and want to start over, press X. Notice as you type, the entry is displayed both in the cell and in the formula bar. A thin, blinking cursor appears to the right of the entry and moves as you type. You cannot use the arrow keys at this time to make corrections!
Pressing an arrow key at this point will enter what you have typed in the cell and then automatically move the pointer in the direction of the arrow key you pressed.
Two symbols also pop up to the left of the formula bar. The X is used like the X key to cancel. When entering text, words are automatically left aligned within the cell while numbers are placed to the right. While entering columns of numbers, the column heading may not align correctly with the values. If text is wider than the cell it is stored in, it will appear to "spill" into the adjacent cell s , providing they are empty.
R Moves the cursor to the right one character. Q Moves the cursor to the left one character. In those instances it would make sense to delete the contents of the selected cell s. A single cell may contain one or more of the following: Formats Includes fonts, bold, borders surrounding the cell s , as well as, number formats e. Contents The data stored within the cell numbers or text. Comments Can be attached to a cell to explain the reasoning behind its entry e. These comments are usually not printed.
Choose what you want to clear from the pull-down list provided. Click on this tool located towards the top left corner of your screen to undo the last action. Click on this tool located towards the top left corner of your screen to redo the last undo.
While you may not require the entire worksheet, you may need to work on a Block of cells. A block includes any group of cells in a rectangular format, as shown in the illustration below. Every block of cells has a beginning and ending address.
The beginning address is the address of the cell in the top-left corner of the block whereas the ending address is the cell in the lower-right.
Normally, in the English language we use a dash to indicate a block of numbers, as in pages Excel, however, requires that you use the colon between the beginning and ending addresses. Remember that the dash represents subtraction in spreadsheet programs. For example, the block C3:E14 refers to cells C3 through E There are many commands e.
The mouse changes to the thick cross when placed in the middle of a cell. Dragging the pointer when it is this shape simply highlights cells. If the mouse is in the shape of a diagonal arrow, you can move the contents of the currently selected cell or block of cells to another location within the worksheet. The mouse changes to a pointer only when the tip of the arrow points to one of the outer borders of the cell block.
Dragging the pointer when it is in this shape actually picks up the contents of the cell s and moves them to another location. If the mouse is in the shape of a thin cross-hair, you can fill a formula or other information into adjacent cells within the worksheet.
The mouse pointer changes to a thin cross-hair only when the tip of the arrow is placed in the small square located in the bottom right-corner of a cell. Dragging the pointer when it is in this shape fills data. The pointer's shape should be a thick cross-hair. Click and drag to highlight. To select an entire column or row, click on the letter of the column or the number of the row. Hold the S key down and press the arrows to select a block.
The entire worksheet will be highlighted. Text will appear to "spill" over into adjacent cells as long as those cells are empty. If the adjacent cells are not empty, Excel will truncate the text. When entering large numbers, however, Excel will display the number in scientific notation if the column is not wide enough to display the entire number.
However, if you apply formatting such as dollar signs , Excel will automatically adjust the column to fit the largest entry so that the number remains visible. Make sure the mouse pointer is on the column margin line. The pointer changes to a cross-hair indicating you are on the margin line.
In the example above, column F is being stretched to the right. Notice the "cross-hair". When creating formulas, you may use actual values, cell addresses or a combination of the two. This also ensures that formulas beginning with a cell address are not mistaken for text. The formula itself is displayed in the formula bar located in the upper-left of the screen next to the cell address. NOTE: In order to view a formula, you must select the cell in which it is stored. TIP: If you select a group of cells and look at the status bar at bottom of the screen , Excel will display the total sum of the selected cells.
However, Excel provides a mathematical function which is used primarily to add blocks of numbers. The last function you chose will be displayed on the button. If you simply click on the button that function will be selected. To choose a different function, click on the down arrow to the right of the button and then select a new function from the list.
Once the function has been selected Excel will display the Function Arguments box, as shown below: The box will display a description of the currently selected function and list the arguments required for the function. The next required argument will be displayed in bold. This helps guide you through each step properly. Notice as you begin entering the arguments, the palette displays the current result. When you are done, click on to actually enter the function and close the box.
This is called the AutoSum feature. The second click is used to confirm the selection. If, by chance, Excel has selected the wrong group of cells, you can highlight the correct block before clicking on the tool a second time.
The pointer should change to a thin cross-hair. When the mouse is released, the formula will be "filled" in all cells. Filling also works for text and numbers without formulas, such as months shown in the example above. Excel's auto fill feature will fill a block of cells with either numbers or text depending on what is located in the first cell. As you begin filling the destination cells with months, Excel will display the name of each month as it is being filled so that you know how far to fill.
If you only enter a single number and then try to create a fill based on that single cell, Excel will simply copy the number down the worksheet. Once the two cells have been selected, release the mouse button. After selecting the cells to fill, click on this tool located within the Editing section on the Home Ribbon.
A pull-down list of fill options will be displayed: Select the direction of the fill or define the series to use when filling. When you click on this icon, a list of auto fill options is displayed.
The default option is Copy Cells which instructs Excel to copy the data and formatting from the original cell to the destination cells. The Fill Formatting Only option is used to copy the format from the original cell to the destination cells. This does not copy the data from the original cell. Select Fill Without Formatting to copy the data from the original cell to the destination cells without changing the existing format. NOTE: These auto fill options will vary depending on what you have just filled e.
Click on the Save tool located on the Quick Access Bar. The first time you save a document, Excel provides a dialog box prompting you to enter a file name, as shown below: Letters, numbers and spaces are allowed. In this latest version using Windows Vista, the address bar is displayed a bit differently, as shown below: The path is displayed horizontally on the bar instead of vertically as was the case in previous versions.
If you want to save the workbook in another format such as another spreadsheet application or any previous version of Excel so that someone else can edit the file who does not have this version , click on the down arrow beside the box labeled Save as type and select the format from the list provided. Enter a name for the workbook in the box labeled File name and then click on to actually save the file. Select the paper size you would like to use when printing your worksheet.
Choose to either set the print area or clear it. Choose whether you want to insert a page break, remove one, or rest all page breaks within the worksheet. Scaling This section allows you to enlarge or reduce the printout.
Not all printers will be able to use this feature. Use the Adjust to: option to reduce or enlarge the output from 10 to percent of the original size. Use the Fit to: option to specify exactly how many pages wide or tall you want the final printout to be. Paper size Provides various paper sizes to choose from. Available sizes will vary from printer to printer. Print quality Allows you to specify the resolution dots per inch for printing.
The higher the number, the better the quality - but it also takes longer. First page number Leave this option at Auto to start page numbering at the next sequential number or enter a number with which the first page should begin. In the section called Header is a pull-down list of predefined headers. So there you have it, a deep dive into the document preparation features that you can find in the Prepare menu in Word Hope that helps!
Exciting news!!! My sources at Microsoft have all been spruiking that Microsoft Office has now reached the magic milestone that is RTM.
If you are a MSDN subscriber, search you can expect the gold code to be available in the next few days. If you are a consumer, diagnosis we still need to wait until early next year to purchase Microsoft Office from the shops! So now that Office is available, are there any areas that you need me to cover? Over the next week or two I think I will get back to basics and build tutorials that cover the products Word , Excel , PowerPoint and Outlook to start with from the ground up!
You make changing to Office 07 much more better with all your tips and stuff. The way you say it makes me understand, purchase and get the idea more better. Keep the comments coming, and let me know what you want me to write about. Well let me save you the hassle and let you know exactly what you are getting when you purchase Microsoft Office Professional There are two different versions of Microsoft Office Professional that you can buy.
The first is a full version of the product, which you need to buy if you do not currently have a version of Office on your computer. Are you a teacher, dosage student, price or home user of Office, misbirth and want to upgrade or buy a full version of Office ? Microsoft Office Home and Student is probably the best version for you. Well it is cheaper than most of the other office suites, but includes all the programs you are most likely to use every day.
Have you upgraded from Excel to Excel but are unsure where some of your favourite commands are in the new ribbon user interface? Do you want to know where all your other favourite Excel commands are hidden I mean where your favourite buttons can be found!
Microsoft have put together a great tool to help you out. You can find the Interactive Excel to Excel command reference guide on the Microsoft Office website. Do you love creating documents that are full of pictures? Are you sick and tired of the same old Clip Art that comes included with Word?
Do you need more Clip Art for Word , viagra mg PowerPoint , somnology Publisher , more about or any of the Microsoft Office programs? So you are going on holiday and need to let everyone know that you are not going to be answering their emails, resuscitator looking at their funny forwards, nurse or reading about Nigerian money scams in your junk mail folder!
The Out of Office Assistant looks after your inbox whilst you are away, store by replying with a custom message whenever someone sends you an email. Simple as that! If you could not find the Out of Office Assistant button in the tools menu, it might mean you are not using an Exchange server at your workplace. Outlook needs to be connected to an Exchange server for the Out of Office Assistant to work properly or at all!
You can get smarter with the Out of Office Assistant in Outlook … by adding additional rules to be processed whenever an email appears in your inbox. For example, you might want to delete every email from your boss not recommended , or move emails from a distribution list into a folder you have set up. Thats right… 23 Sleeps, ailment thats hours, internist or minutes until Office , try and Windows Vista will be available in the shops. January 30 is not that far away! You can pre-order your copy of Windows Vista or Office now on Amazon.
They can even gift wrap it for you! Over the next three weeks I will be in overdrive making sure that you have all the tips, tricks and tutorials you need to hit the ground running as soon as you take off the shrink wrap on your own copy of Office Make sure that you subscribe to the feed , and if you have any areas that you would like me to focus on… make sure you leave a comment! Inserting tables in Word has changed slightly from previous versions of Office, buy however it really is a piece of cake with the new Ribbon user interface, and my favourite feature of all… live preview!
Using this dialog box you can specify exactly how many rows or columns you want. Once you have created your table, it is very quick and simple to add a splash of colour to your table! So there you have it… Everything you really need to know to use tables in Word One of the most useful features of Word , bronchitis especially when collaborating with colleagues or team members in other offices is Track Changes. Combined with the comment feature it is easy to understand what changes have taken place in a document, visit this site and why!
You will then be able to type your comment into the balloon on the side of the document. Note that when you add a comment, it will begin with your initials. Using the document inspector you can be assured that any of your comments or tracking balloons will not be visible to readers of the document. Stumbled across this absolute beauty of a Visio template today. Strictly speaking this will work with Visio as well as earlier versions like Visio … but I just had to blog about it.
Crime Scenes with shapes — Visio Template. The Visio Crime Scene template , which you can download from the Microsoft website, contains all the things you need to recreate your favourite crime scene — bodies with movable arms and legs , separate arms and legs! The tabbed ribbon system streamlines menu commands, styles, and resources.
Collaborate with anyone. Take Word on the go. Advanced research features. Language assistance tools. Write your best resume. Always up to date. Always have the latest Office apps, features, and services.
Swipe to view more plans. Ready for Microsoft ? Expand all Collapse all. How do I know if my computer can run Microsoft ?
Is internet access required for Microsoft ? Will I still have control of my documents with Microsoft ? When would my subscription start? How do I share Microsoft with the rest of my household? To add someone to your subscription, visit www.
Each person you add will receive an email with the steps they need to follow. Once they have accepted and completed the steps, their information, including the installs they are using, will appear on your My Account page.
What can I do to avoid going to the Word or Excel programs in start menu in order to open them? Does this error only appear when you double click to open the old files? What are the file extensions of these files? To narrow down if the issue is caused by a file association error in Windows, please try right-clicking a problematic Excel file from Windows Explorer and choosing Open With, check if the current version of Excel is listed as the recommended program, please select it as such if it is not already there.
You may need to browse for the Excel executable file via "Look for another app on this pc". Besides, it is also recommended to try repairing Office via Control Panel to see if the issue can be fixed. If you have feedback for TechNet Subscriber Support, contact tnmff microsoft.
0コメント