Learn About Formatting And Printing In Excel

Microsoft Excel is a computer program that can make dealing with numbers, tables, and spreadsheets a whole lot easier. By simply entering data into rows and columns, it can be organized in almost any manner you wish, from pie charts to comparison sheets. Unless it is a small job that you have completed for individual reasons, the sheets created by Excel will probably need some modifications and printed out for others to use; therefore, you might benefit from some formatting and printing advice for Microsoft Excel.

Formatting your work so that it is logical and easy to comprehend is one of Excel’s specialties. Take for example information arranged in columns that all have a common theme. You want to give the sheet a title, but cannot quite center it perfectly above the columns. Some people will simply choose a cell above the information that is close to the middle and call it a day, but this method rarely yields a professional looking result. All you must do is highlight every blank cell along the top of the columns, place your cursor on the Merge and Center button, and click. Now the title is perfectly centered and looks good.

Occasionally, especially when dealing with values and text that is more important than others, you will want certain items to be prominent. Increasing font size is an effective way to do this, and performing the task with Excel is pretty much the same as with Microsoft Word. All you have to do is highlight the designated cell and click on the font size dropdown box. Choose your new size and you are done, adding bold face if desired. If you wish to center this particular text, or any other for that matter, highlight the cell and click on the tab that reads Formatting near the top of the page. Dropdown boxes are available for both horizontal and vertical centering, enabling you to choose which axes you wish to center.

Once you are finished creating your charts, spreadsheets, or graphs, you can print them out to share with others. You do not want to waste your valuable ink on an inferior design, so it is important to choose the print preview function before finalizing the print command. A miniature version of how the page will look once printed is displayed. If work needs to be done, close out of the preview and perform some last minute formatting. If the graphics are too small, then they may be increased by clicking on Page and choosing the scaling option.

Using Microsoft Excel, you may shape and size your graphics in many formats. Once you have achieved the design you are looking for, it can then be formatted and printed upon completion. Excel is quite user friendly, and you will master its usage with just a little practice.

Further Reading : Excel Training

Leave a Reply

Your email address will not be published. Required fields are marked *