If you want to create a new workbook in some folder and you are already there, then instead of clicking on excel icon and then making your way to the folder by clicking down through the folders until you reach the desired location where you want to save your file. Simply right click in the desired folder and then select New and choose microsoft office excel worksheet. And just rename it.

Read the rest of this entry »

Popularity: 18%

If we save some file without giving the path, then it will automatically get saved at the default location. We can change the Default File Location as:

1.Click on the Tools menu
2.Choose Options
3.Click on the General tab
4.Enter a new path in Default File Location and hit OK.

Popularity: 18%

This article explains how to deal with a situation when your keyboard gets locked without you even knowing it.

Read the rest of this entry »

Popularity: 100%

This article describes in detail why excel takes so long to open and how can you get around it.

Read the rest of this entry »

Popularity: 26%

This article shows how to take screenshots in general and also gives special methods which are excel specific.

Read the rest of this entry »

Popularity: 27%

Did you ever have problems sending excel files of several MBs through your email systems?? Sometimes it rejects it because it exceeds the quota size or takes forever to send…….This article shows how to split huge excel files into smaller parts which can easily be sent.Plus, it explains how to put them back together.

Read the rest of this entry »

Popularity: 13%

This article is a basic guideline on how to insert excel spreadsheet into word document. It gives a comprehensive list of the available options and describes each one of them in graphic detail.

Read the rest of this entry »

Popularity: 73%

This article talks about formatting and borders.

Read the rest of this entry »

Popularity: 5%

If you want to select adjacent sheets then you can do that by holding down the shift key and clicking on the next sheet tab.For e.g. There are six worksheets - sheet 1 to sheet 6. And you want to select one to four then simply select the first sheet, hold down the shift key and click on the forth sheet.You will notice this will automatically select sheet 2 and 3 as well.
However if you want to select non adjacent sheets then hold down both the shift and control keys together and choose the desired sheet.

If you want to do a mouseless selection, just hold down the shift and control keys and press “Page up” or “page down”.

If you want to select all the worksheets at once then you can also right click on one of the sheet tab and choose “Select all sheets” option.

Popularity: 5%

Once we have applied filter to our data using the excel’s “AutoFilter” option and we want to sum only the non-hidden range, then we can’t use the simple “sum” function as it adds both the hidden and visible cells. In that case we can use the excel’s subtotal function as it only sums the visible range.

The syntax of the Subtotal function is:

SUBTOTAL(function_num,range_reference1, range_reference2….)

We can perform 11 different functions in conjunction with subtotal.

Function_Num - Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

Suppose you have a list of 4 different products - A, B, C and D along with their quantity sold.

And you wish to add up only the quantity sold of product A. Then if you apply filter and sum the range using “Sum” function then it will give the total for all the products

Whereas if you use subtotal function you will only get it for product A as shown below:

Popularity: 17%

Whenever you have some text in one column and you wish to break it into several ones then instead of retyping the text in the next column, you can use the “Text to Columns” option under the “Data” tab. For e.g. Both the names and marks of the students are in the same column(say Column A) and you want to separate them in different columns as shown below:

The first step is to highlight the column that needs to be separated. Then click “Data” and choose “Text to Columns” option.

Then choose the delimited option.

Select the “space” check box, keeping others unchecked. So whatever text is after the space will be put into the next column.

As soon as you click the “Next” tab you will see the preview of your data. And you will notice that it has put marks into the next column.

Now just click the “Finish” button and it will be done.

Popularity: 5%

To switch between your open excel workbooks,you can use the “Window” drop-down menu as it lists all the workbooks that are currently open. Alternatively, you can use the shortcut keys(Alt+Tab) to move from one window to another.You need to hold down the Alt key as you repeatedly press the Tab key to switch from one window to another.
When the desired workbook window is selected, release the Alt key and the
actual workbook will be displayed.
However using this combination(Alt+Tab) will display the names of not just the excel
workbooks but all other applications that are currently open like word documents, notepad, internet explorer etc. If you only want to toggle between your open excel workbooks you can use (Ctrl+Tab) key combination instead You can also switch between excel sheets using the shortcut keys (Ctrl + F6).

Popularity: 7%

If an entry in a particular cell is too long, its value will be displayed as bunch of hash keys (#####). This is not an error and you can get around this problem by using the “Autofit selection” feature of excel. This can be found under “Column” tab of “Format”
drop down menu. Autofit selection option will expand the column to the size of the longest entry. If you want to expand all the columns then just press(Ctrl+A) to select the whole data and press(Alt+O+C+A) which is the shortcut for the Autofit selection option.

Popularity: 7%

If your calculations in a particular column are dependent on values in some other column which has blank entries in some cells then to avoid any value error you can use a simple “IF” command say column B2 is blank and column D2 is dependent on values in B2 then the equation would be:
=IF(B2=”",”",Formula) Where “” represents blank cell.

Popularity: 4%

Excel to PDF Converter

For this conversion, you don’t require any special Excel to PDF Conversion software. All you need is either Adobe Acrobat 8 Standard or Adobe Acrobat 8 Professional installed on your computer. If you have Adobe® Acrobat® 3D Version 8 then that is the king of the Acrobat family. It does just about anything. However if you just have the Adobe Reader, then that can only be used to read a PDF file. It cannot create one.
Once you have Adobe Acrobat professional or standard installed on your PC, there are two ways you can do the conversion.

1) Create a PDF using Adobe Acrobat icon

Double click on this. It will give you various options like create PDF, combine files, export, start meeting, secure, sign, forms and review and comment. Choose the create PDF tab and then click on the “Create PDF from a file” option. Just give the location of your excel file and it will be done.

2) Create a PDF using the print command

The simpler method would be to open your excel file and select the “print” option from the “File” tab. And just change the name from your printing machine to Adobe PDF. So print option does not necessarily give you the print outs or the hard copies but it can also print to the Adobe PDF format.

Popularity: 4%