Yearly Archives: 2010

There are many handy pre-defined hotkeys which enables you to select, create, edit the part of Excel 2010 spreadsheet quickly. Out of such hotkeys, take a look at one which quickly creates chart of selected dataset. Read More

XML (eXtensible Markup Language) is widely used format for holding data with user-defined tags, so that users can easily retrieve their data to use it with other applications according to the requirements. Since Excel 2010 has the ability to convert spreadsheet between various formats including HTML, CSV, TXT, DIF, XPS, ODA etc., you can also use it use Excel to convert said formats into XML without having to use any dedicated, third-party application to do the conversion. Excel 2010, just like previous versions, doesn't offer a separate tool to perform the conversions, so you have to use the Save As dialog to convert XLSX or other Excel-supported formats to XML format. It must be noted the Excel 2010 saves the spreadsheet in XML Spreadsheet 2003 format, and some new features of your spreadsheet may not work with XML 2003 format. When you attempt to convert Excel 2010 workbook to XML, you can view the Excel Help section to check out the feature that won't work with XML format. Like other formats, you can access General and Web options while saving the spreadsheet to XML format; before you click Save, click Tool menu to access General options to apply password-protection and Web Options to optimize the spreadsheet for the web. Read More

Unlike Excel 2007, which offers only a few viewing modes and options to hide UI elements from spreadsheet, Excel 2010 includes a number of spreadsheet viewing-sheet. It allows users to hide all those UI elements that annoy them while working on a spreadsheet. Previously, we brought you a guide on hiding gridlines, this time around we will take a look at the spreadsheet hide feature. Excel 2010 enables users to easily hide the entire worksheet from the workbook, preventing others from making changes to the data sets. It is worth mentioning here that it doesn't permanently hide the worksheet, and you can easily reveal it using the Unhide button. When you hide the worksheet, it automatically hides its tab present over the status bar, restricting users from accessing work sheets in your workbook. Unhiding the worksheet is simple. All you need is to click Unhide button and choose the worksheet you want to display. Upon selecting, it will immediately show you the selected sheet. Read More

Data labels feature lets user understand the chart type and used scales in depth. With data labels, you can easily view the values that affects chart area in Excel 2010. Lets look at how to enable and use them. Read More

By Default, All Macros option is disabled in Excel 2010 due to the fact that any kind of malicious code can run which can seriously harm your work. However, if you’re an advanced user and want to enable all the macros, you can do it from Excel 2010 Trust Center Settings. Read More