, ,

44. Formatting Worksheets: Conditional Formatting

MS Office Excel Conditional Formatting feature enables you to format a range of values so that the values outside certain limits, are automatically formatted.Choose Home Tab » Style group » Conditional Formatting drop-down. Various…
, ,

42. Formatting Worksheets: Setting Background

Background Image 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…
, ,

41. Formatting Worksheets: Inserting Page Breaks

Page Breaks 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.MS Excel handles page breaks automatically, but…
, ,

40. Formatting Worksheets: Header and Footer

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. Adding Header and Footer…
, ,

39. Formatting Worksheets: Page Orientation

Page Orientation 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. Types of Page OrientationPortrait −…
, ,

38. Formatting Worksheets: Adjusting Page Margins

Margins 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.You can set margins by various ways…
, ,

37. Formatting Worksheets: Sheet Options

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.Options…