\n| Accounting<\/span><\/td>\n | Account purpose data are entered in accounting purpose.<\/span><\/td>\n<\/tr>\n\n| Date<\/span><\/td>\n | Displays in the format of date.<\/span><\/td>\n<\/tr>\n\n| Time<\/span><\/td>\n | Displays in the time format.<\/span><\/td>\n<\/tr>\n\n| Percentage<\/span><\/td>\n | Displays the values in percentage.<\/span><\/td>\n<\/tr>\n\n| Fraction<\/span><\/td>\n | Displays in the format of fraction.<\/span><\/td>\n<\/tr>\n\n| Scientific<\/span><\/td>\n | Displays in the exponential form.<\/span><\/td>\n<\/tr>\n\n| Text<\/span><\/td>\n | This format is used when the data is in text format.\u00a0<\/span><\/td>\n<\/tr>\n\n| Special<\/span><\/td>\n | Special formats are used in case of entering telephone numbers etc<\/span><\/td>\n<\/tr>\n\n| Custom<\/span><\/td>\n | The format can be customized as per the user convenience<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nBorders in excel<\/h3>\nYou can add borders and shades to a cell in the spreadsheet. To add borders, select the cell, right click on it, choose the format cells option and then click on the type of border that you would like to add to that cell. You can also change the thickness, style, color etc.<\/p>\n Decorating and formatting the data in Excel<\/h3>\nYou can also decorate and format the data in an excel spreadsheet. To decorate and format, right click on the cell, choose format cells option and click on the font tab in the dialog box window. After making the required changes in the font type, style and size, click on the ok button.<\/p>\n ![\"font](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/font-format-cell.png\") <\/a><\/p>\nExcel Context Help:<\/h3>\nExcel context help is a feature in excel which provides appropriate information about the Excel commands in order to make the user know about its usage and working.<\/p>\n ![\"Conditional](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/cond-format.png\") <\/a><\/p>\nEditing the Excel Worksheets:<\/h3>\nThe user can also edit the data that they enter in the worksheet. The user can enter in any form such as text, numeric or formulae.<\/p>\n Formatting MS Excel Worksheets:<\/h3>\nSheet Options:<\/h4>\nThere are a number of options available for taking the printouts. The user can select an option from it and print the sheet in various ways. To click on the sheet options, choose the page layout group from the home tab, open the page setup. You can see a various number of sheet options and they are listed below:<\/p>\n
\n\n\n| Option<\/b><\/td>\n | Description<\/b><\/td>\n<\/tr>\n\n| Print Area<\/span><\/td>\n | The user can set the print area.<\/span><\/td>\n<\/tr>\n\n| Print Titles<\/span><\/td>\n | It allows the user to set the row and column titles at the top.\u00a0<\/span><\/td>\n<\/tr>\n\n| Gridlines<\/span><\/td>\n | The user can add the gridlines to the printout.<\/span><\/td>\n<\/tr>\n\n| Black and White<\/span><\/td>\n | The user can take the print out in black and white.<\/span><\/td>\n<\/tr>\n\n| Draft Quality<\/span><\/td>\n | It allows the user to print the sheet using the printer’s draft quality.<\/span><\/td>\n<\/tr>\n\n| Row and Column Headings<\/span><\/td>\n | It allows the user to print the row and column headings.\u00a0<\/span><\/td>\n<\/tr>\n\n| Down, then over<\/span><\/td>\n | It prints the down pages first and it is followed by the right pages.<\/span><\/td>\n<\/tr>\n\n| Over, then down<\/span><\/td>\n | It prints the right\u00a0 pages first and it is followed by the down pages.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\nExcel Margins and Page Orientation:<\/h3>\nMargins:<\/h4>\nThe margins are the unprinted regions on the top-down and left-right sides. Each and every MS Excel page has borders and if the user selects some border for a page, then that border appears to those particular pages.
\nNote: The user can\u2019t have different margins for each page. The user can add margins in the following ways:<\/p>\n \n- Select the page setup from the page layout tab and then the user can click on the margins drop-down list.<\/li>\n
- The user can also add Margins while printing the excel page. In order to perform that, click on the File tab and choose Print. Here, the user will be able to see a dropdown list having all the Margin options that are available in Excel.<\/li>\n<\/ul>\n
Page orientation<\/h4>\nPage orientations are of two types and they are portrait and landscape. The page orientation helps the user to select the format in which the sheet is printed. The portrait orientation prints the page taller and the landscape orientation prints the sheet wider. To select a type of page orientation, choose the drop-down list from the page setup group and click on the appropriate orientation. The user can change the page orientation while printing the excel sheet.<\/p>\n Excel Headers and Footers:<\/h3>\nHeaders and footers provide some information at the top and bottom of the page. The header and the footer are not available in a new workbook. In order to add the header and footer, the user can open the page setup window and open the header\/footer pane. The user will have a number of options to customize the headers and footers.<\/p>\n If the user wants to preview the header and footer that are added, click on the print preview option and the user can see the changes.<\/p>\n Page Breaks:<\/h4>\nMS-Excel allows the user to control what they want to print and what they want to omit. Using page breaks, the user can control the page print such as restrain from printing the first row of a table at the end of a page or printing the header of a new page at the end of the previous page. The page breaks will allow the user to print the sheet in order to the preferences. The user can have both horizontal and vertical page breaks. Select the row or column to include the page break and then go to page setup, choose the options from insert page break.<\/p>\n Horizontal Page Break:<\/h4>\nTo add a horizontal page break, select the row where the user wants to introduce the break from.<\/p>\n Vertical Page Break:<\/h4>\nTo add a vertical page break, choose the column where the user wants the page to break from.<\/p>\n | | | | | | | | | | | | | | | | | |
![\"Excel](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/07\/basic-ss.png\")
<\/a><\/p>\n