If you don’t want a row to print on a page by itself or you don’t want a table header row to be the last line on a page. MS Excel gives you precise control over page breaks. (toc) Page Breaks MS Excel handles page breaks automatically, but sometimes you may want to force a page […]
Tag: Microsoft Excel
Set Background in M S Excel
Unfortunately, you cannot have a background image on your printouts. You may have noticed the Page Layout » Page Setup » Background command. This button displays a dialogue box that lets you select an image to display as a background. Placing this control among the other print-related commands is very misleading. Background images placed on a worksheet […]
Freeze Panes in M S Excel
If you set up a worksheet with row or column headings, these headings will not be visible when you scroll down or to the right. MS Excel provides a handy solution to this problem with freezing panes. Freezing panes keeps the headings visible while you’re scrolling through the worksheet. (toc) Using Freeze Panes Follow the […]
Conditional Format in M S Excel
MS Excel 2010 Conditional Formatting feature enables you to format a range of values so that the values outside certain limits, are automatically formatted. (toc) Conditional Formatting Choose Home Tab » Style group » Conditional Formatting dropdown. Various Conditional Formatting Options Highlight Cells Rules − It opens a continuation menu with various options for defining the formatting […]
Microsoft Office Tools
Application software that assist users in regular office jobs like creating, updating and maintaining documents, handling large amounts of data, creating presentations, scheduling, etc. are called office tools. Using office tools saves time and effort and lots of repetitive tasks can be done easily. Some of the software that do this are Word processors Spreadsheets […]
Explore Window in M S Excel
The following basic window appears when you start the excel application. Let us now understand the various important parts of this window. (toc) Explore Excel Window File Tab The File tab replaces the Office button from Excel 2007. You can click it to check the Backstage view, where you come when you need to open or save […]
Backstage View in M S Excel
The Backstage view has been introduced in Excel 2010 and acts as the central place for managing your sheets. The backstage view helps in creating new sheets, saving and opening sheets, printing and sharing sheets, and so on. (toc) Getting to the Backstage View is easy. Just click the File tab located in the upper-left corner of the Excel […]
Entering Values in M S Excel
Entering values in excel sheet is a child’s play and this chapter shows how to enter values in an excel sheet. A new sheet is displayed by default when you open an excel sheet as shown in the below screen shot. Enter Text Sheet area is the place where you type your text. The flashing […]
Move Around in M S Excel
Excel provides a number of ways to move around a sheet using the mouse and the keyboard. First of all, let us create some sample text before we proceed. Open a new excel sheet and type any data. We’ve shown a sample data in the screenshot. OrderDate Region Rep Item Units Unit Cost Total 1/6/2010 […]
Save Workbook in M S Excel
Saving New Sheet Once you are done with typing in your new excel sheet, it is time to save your sheet/workbook to avoid losing work you have done on an Excel sheet. Following are the steps to save an edited excel sheet − Step 1 − Click the File tab and select Save As option. Save As Option Step 2 − […]