A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets. Charts generated by early spreadsheet products were quite crude, but thy have improved significantly over the years. Excel provides you with the tools to create a wide variety of highly customizable charts. Displaying data […]
Tag: Microsoft Excel
Pivot Charts MS Excel
A pivot chart is a graphical representation of a data summary, displayed in a pivot table. A pivot chart is always based on a pivot table. Although Excel lets you create a pivot table and a pivot chart at the same time, you can’t create a pivot chart without a pivot table. All Excel charting […]
Keyboard Shortcuts in MS Excel
Keyboard Shortcuts in MS Excel MS Excel Keyboard Short-cuts MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel. Ctrl + A − Selects all contents of the worksheet. Ctrl + […]
Merge & Wrap in M S Excel
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 […]
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 […]