Viewing: Excel 2010

How to automatically insert decimal point in Excel 2010

Excel 2010 has a feature which automatically inserts a decimal point after the specified number of decimal places. This can be done using the Excel Options. Click the File menu –> Options link and Navigate to Advanced screen. In the Advanced screen, editing options, mark the check box with the label as Automatically Insert a […] Read More

How to change the default font in Excel 2010

Microsoft Excel 2010 provides option for the changing the default font for a workbook. This can be changed using the Excel Options. Click the File menu –> Options link. In general tab, navigate to When creating new workbooks   Using the Use this font you can change the default font for a workbook, similarly the […] Read More

How to insert header and footer in Excel 2010

Microsoft Excel 2010 provides option for inserting header and footer for Worksheets. This can be done using the Page Layout option. Click on the View menu and then select Page Layout option. The following Page Layout view will be displayed. click the Click to add header text and enter the Header for the Worksheet like […] Read More

How to change the number of sheets in Excel 2010 Workbook

In Excel 2010, the default number of worksheets included in a new workbook is 3.  We have already seen how to change the number of worksheets in Excel 2007. Similarly using Excel 2010 options the number of sheets can be increased on decreased. Click on the File menu –> select options link   In Excel […] Read More

How to insert a function in Excel Worksheet

Microsoft Excel has lot of functions to help users to simplify their work. These functions can be easily inserted in to a worksheet. For example if you want to find the absolute number then you can do the following Click on the Formulas –> Insert Function This would display the following Insert Function window. Select […] Read More

1 5 6

Get your free copies of the following tech guides by joining the Digital Answers mailing list.