Easy Excel Tricks
Daily Excel tricks that make your life easier!
Sunday, March 17, 2013
My new blog
This blog will not be updated anymore.
Instead, I will provide great tips & tricks on this page: http://easy-excel.com/
Thursday, November 22, 2012
Sort values in Excel
It’s easy to sort a table in Excel, but you have to be careful! There are two important rules:
1. No empty cells in the table
2. Select only one cell or the entire table before you click on Sort
Wrong (only the selected names will be sorted):
Right (all
the names will be sorted, and Excel excludes the heading and the total
automatically):
The result:
Wednesday, November 21, 2012
Trace Dependents before you delete a cell in Excel
A new version of this post has been published here: http://easy-excel.com/?p=356
Before you delete a cell, you should check if there are other cells that are affected by it.
Select the
cell, go to the Formulas ribbon and click on Trace Dependents. The arrows show
the dependent cells.
Tuesday, November 20, 2012
Monday, November 19, 2012
Show File Path in Excel
If you want
to see the location of your Excel file, or e-mail the link to the file to your colleagues, you can display the file path in the Quick Access Toolbar:
You only have to do this once – when you make any changes in the Quick Access Toolbar, they apply to all Excel documents.
Do like this (Excel 2010):
1. File => Options
2. Choose All Commands in the drop-down and scroll down to and choose Document Location.
3. Click Add
In Excel 2007:
1. Office button => Excel Options => Customize
2. Choose All Commands in the drop-down and scroll down to and choose Document Location.
3. Click Add
Friday, November 16, 2012
Highlight Cells in Excel that Contain a Formula
A new version of this post has been published on my new blog:
http://easy-excel.com/?p=133
Is there an easy way to locate the cells in Excel that contain a formula? Yes, there is!
Open the Go to-window (Ctrl+G) and click on Special. Choose the radio button Formulas:
Click OK, and all the cells that contain a formula are highlighted!
Thursday, November 15, 2012
Create a Drop Down List in Excel
Today I’ll show you how to create a drop down list in 20 seconds:
1. Open the Data Validation window from the Data ribbon (or use the shortcut Alt => D => L)
2. Select the array you want to have in the drop down list
Done!
For more posts about drop down menus, have a look at my other blog:
Subscribe to:
Posts (Atom)