Merge Cells MS Excel enables you to merge two or more cells. When you merge cells, you don’t combine the contents of the cells. Rather, you combine a group of cells into a single cell that occupies the same space. (toc) You can merge cells by various ways as mentioned below. Choose Merge & Center control on […]
Tag: M S Office Tutorials
Borders and Shades in M S Excel
Apply Borders MS Excel enables you to apply borders to the cells. For applying border, select the range of cells Right Click » Format cells » Border Tab » Select the Border Style. Setting Border Style Then you can apply border by Home Tab » Font group » Apply Borders. Setting Border Apply Shading You can […]
Apply Formatting in M S Excel
Formatting Cells In MS Excel, you can apply formatting to the cell or range of cells by Right Click » Format cells » Select the tab. Various tabs are available as shown below Formatting Cells option Alternative to Placing Background Number − You can set the Format of the cell depending on the cell content. Find tutorial […]
Sheet Options in M S Excel
MS Excel provides various sheet options for printing purpose like generally cell gridlines aren’t printed. If you want your printout to include the gridlines, Choose Page Layout » Sheet Options group » Gridlines » Check Print. Sheet Options Options in Sheet Options Dialogue Print Area − You can set the print area with this option. Print Titles − […]
How to Adjust Margins in M S Excel
Margins are the unprinted areas along the sides, top, and bottom of a printed page. All printed pages in MS Excel have the same margins. You can’t specify different margins for different pages. (toc) Margins You can set margins by various ways as explained below. Choose Page Layout » Page Setup » Margins drop-down list, […]
Types of Page Orientation in M S Excel
Page orientation refers to how output is printed on the page. If you change the orientation, the onscreen page breaks adjust automatically to accommodate the new paper orientation. (toc) Types of Page Orientation Portrait − Portrait to print tall pages (the default). Landscape − Landscape to print wide pages. Landscape orientation is useful when you have a […]
Adding Header and Footer in M S Excel
A header is the information that appears at the top of each printed page and a footer is the information that appears at the bottom of each printed page. By default, new workbooks do not have headers or footers. (toc) Adding Header and Footer Choose Page Setup dialog box » Header or Footer tab. Setting […]
Insert Page Break in M S Excel
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 […]
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 […]