Yearly Archives: 2010

Excel 2010 provides a handy feature to instantly remove formatting along with all the hyperlinks. Many a times it happens that while pasting/importing data from external sources, hyperlinks get included. If your datasheet contain hundreds of hyperlinks, removing them manually is a tedious  job.This post covers how to remove it using the build-in feature. Read More

One of our reader asked that how to remove Row & Column headers in Excel 2010. As long as Excel 2010 is concerned, one can not remove it but it lets you easily conceal it. So here is how to make row & column header invisible. Read More

This post will cover how to quickly sort numeric data in Excel 2010. It provides two ways in which you can sort data; Ascending and Descending. You would need to pick one among these two options according to your requirements. Read More

Excel 2010, like previous versions, shows gridlines in the spreadsheet to let users easily add/remove cells' values, and adjust height and width of row and columns, respectively. You may know that Excel 2010 doesn't print the guidelines unless you manually add them to printable elements. Most users choose to apply border style to gridlines to make their data sets prominent in the spreadsheet, but there is another rather easy way to make your data set prominent, and that is by hiding the gridlines and then applying the guidelines border style to selected rows and fields; using the Gridlines view toggle button, you can hide the gridlines and then apply border to selected cells. However, if gridlines are distracting your work, you can make them invisible. This post will let you know how to make gridlines invisible to view only the cells' values. Read More

If you're a heavy user of Excel, then you may know that it requires you to draw a border around the cells in order to print the cells. However, it also provides you with an option to enable printing of gridlines, so that you don't have to manually draw the border around the cells to get gridlines printed. In addition to gridlines, Excel 2010 also includes an option to print column and row headers. Enabling the print gridlines options displays the specified size on the page, allowing you to view the portion that will be printed on a single page. The Page Setup dialog includes a number of settings to further tweak the print options; you can choose to select the borders, black & white, headers and gridlines to print them, and     specify the position of the comments in the spreadsheet.  Read More

Excel 2010 does not point out spelling mistakes in real-time. It’s better to check spelling mistakes in Excel sheet before marking it as complete. Lets see how to thoroughly check for spelling mistakes. Read More

Excel 2010 offers three forms for pivot tables report layout which are; Compact Form (default), Outline Form, and Tabular Form. In this post we will look at how to change the form of a report layout. Read More

If you’re dealing with one huge spreadsheet, in which you need to scroll a lot to get to the bottom or upper part of the sheet, you can use a hotkey instead to quickly jump to the start of worksheet (position: A1). Read More

Excel 2010 offer two ways in which you can move chart to worksheet. You can either let it create a new sheet for the chart or move the chart as an object to the existing one. By moving the chart as an object, you don't have to copy the chart to other sheet,  just use the Move Chart option to move it without changing the data sources. Read More

The Name Ranges feature makes it easy to call/use the source data set in formulas and functions without having to select the source data set by hand. If you've just started using Excel, then you may know that Excel requires you to specify the data range in order to apply formulas and functions to produce the required results. Since it may become quite tedious to select the entire data range, you can use Name Ranges feature to give an appropriate name to the selected data range, and then use it in formulas to refer to the source data set. Excel 2010, just like previous versions, offers an easy way to name a data range. All it requires you to select the data range that you wish to give a name, and define its name range. Once done, you can call the data set anywhere in your workbook by its name instead of source data range. In this post we will explain how you can define a new name range in your spreadsheet. Read More

Changing the columns into rows and rows into columns is easy, and it takes just a click to transpose a selected field to the row and vice versa. Excel 2010, like previous Excel versions, offers a an easy way to quickly transpose rows and columns. For those who are not familiar with row/column transpose feature, it allows shifting the values in a selected column to row and vice versa, preventing users from manually copy & paste each cell's value. You may know the transpose option is accessible from the Paste Special menu, which also contains options like paste plain value, paste formula, paste formula and function, paste without borders, paste with source column width etc. Since it is associated with the Excel paste function, you first need to copy the column or row that you wish to transpose to row or column. Once the required data set in a row or column is selected, just move to the cell where you want to transpose the copied row/column, and right-click it to select Transpose from Paste Special menu. In this post we cover how to change a row into columns and vice versa. Read More