Monthly Archives: January 2010

Want to quickly select entire current row or column in your Excel sheet to perform the a set of actions over all the data values present in the selected row and column? Often, while working on an Excel spreadsheet, users require to select the current entire column or row to perform required operations over all selected data values. This can be easily done using the mouse; all you need is to select the required row or column header in order to select the row/column, but wouldn't it be easier if you could select the required column or row using a hotkey combination? Luckily, Excel 2010 lets you select a current row or column with a simple shortcut key. Using Shift + Space on keyboard selects the whole row, while using the Ctrl+Space will quickly select the current column, letting you perform the operations over the entire row/column without having to move the mouse. If you select current row and then use the shortcut to select the current entire column, Excel 2010 will automatically select entire sheet including both the rows and the columns. However, if you wish to quickly select the column after selecting the row, first unselect the selected row and then press Ctrl+Space to select the curent column. Read More

Name Manager is responsible for managing all the specified name ranges in Excel 2010. All you’d need is to bring it up and view and manage all the name ranges. You can edit them, create a new name range, and delete all the existing name ranges. To check all the existing name ranges, head over to Formulas tab and under Defined Names group, click Name Manager. Read More

If you’re dealing with chemical formulas in Excel 2010 spreadsheet, you may need to apply super-script and sub-script. In this post we will let you know how to do it. Read More

It would be great to assign colors to sheet tab in Excel workbook to differentiate each worksheet visually. By default Excel 2010 assigns white color to active & blue to inactive sheet tab. This post covers applying colors to worksheets tabs. Read More

If you’re working on a huge spreadsheet which contain a lot of data sets, you may want to zoom-in selected area to focus on single data set. Excel 2010 offers Zoom-In selected area option which can help you edit the content easily without having to adjust the screen manually. Read More

Excel 2010 offers a lot chart-specific features and tools which you can use to overhaul the chart in a way you want. Many a times it is not necessary to show the chart plot area, Excel also allows user to conceal Plot Area to make your chart look more clean. To do so, head over to Chart Tool Layout tab, from Plot Area drop-down menu, click None. Read More

Hiding a worksheet can become necessary in instances when you need to show only specific worksheets of the workbook to your audience. Excel 2010 allows you to quickly hide/unhide the worksheet window, lets take a look at how to do it. Read More