tag:blogger.com,1999:blog-78209357477552319082023-11-16T11:28:12.066+01:00Easy Excel TricksDaily Excel tricks that make your life easier!Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-7820935747755231908.post-60235550605128265552013-03-17T21:54:00.002+01:002013-03-17T21:54:16.027+01:00My new blog<br />
<a href="http://easy-excel.com/"><b>This blog will not be updated anymore. </b></a><br />
<a href="http://easy-excel.com/"><b>Instead, I will provide great tips & tricks on this page: http://easy-excel.com/</b></a><br />
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-50035991666403393012012-11-22T06:30:00.000+01:002012-11-22T06:30:00.380+01:00Sort values in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
It’s easy to sort a table in Excel, but you have to be careful! There are two important rules:<br />
<br />
1. No empty cells in the table<br />
2. Select only one cell or the entire table before you click on Sort<br />
<br />
<i>Wrong (only the selected names will be sorted):</i><br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicyK-SLg0Nn6wEsZWhoi_cEolGs1Jpk6BDeS3HwBePQKH-uXviG2gU7UUm9Y7jP2QVo8hiItfY7MSxRLH9pQWXvHcrtsP-T1Sj8AIgMBzZwFXuOdKyDsFV93DwVn9FXEMysechn6XCUIqi/s1600/B12_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicyK-SLg0Nn6wEsZWhoi_cEolGs1Jpk6BDeS3HwBePQKH-uXviG2gU7UUm9Y7jP2QVo8hiItfY7MSxRLH9pQWXvHcrtsP-T1Sj8AIgMBzZwFXuOdKyDsFV93DwVn9FXEMysechn6XCUIqi/s400/B12_1.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
<div class="MsoNormal">
<span lang="EN-US"><i>Right (all
the names will be sorted, and Excel excludes the heading and the total
automatically):</i></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFWnq_VqQLSED3ipXeHgtQ3Z7E1qhgaYgkM35yewERwpRIq7TcHv2ROeH2jV-wxxi-6ys4uPmMffVSwb1BoybHvzmTqj6_LH5q0cz459jufyhiPSAO9SNiYr_Uepipdm5k6ilRcT3gDkfC/s1600/B12_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="318" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFWnq_VqQLSED3ipXeHgtQ3Z7E1qhgaYgkM35yewERwpRIq7TcHv2ROeH2jV-wxxi-6ys4uPmMffVSwb1BoybHvzmTqj6_LH5q0cz459jufyhiPSAO9SNiYr_Uepipdm5k6ilRcT3gDkfC/s400/B12_2.png" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<i>The result:</i></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC9-Fuvbv5gNFW6iwG89VKHEIfFu7IkrD81cSG9BOsiEporCXk8OIgo_NwydYGvI8HB-cY3C0qMopT1AR0n7Pc_n5ClFAXJyjWnVOsjwItbkTUV16XNd2ALFFdNZavkwrGXUI19u-5SnQH/s1600/B12_3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC9-Fuvbv5gNFW6iwG89VKHEIfFu7IkrD81cSG9BOsiEporCXk8OIgo_NwydYGvI8HB-cY3C0qMopT1AR0n7Pc_n5ClFAXJyjWnVOsjwItbkTUV16XNd2ALFFdNZavkwrGXUI19u-5SnQH/s400/B12_3.png" width="400" /></a></div>
<div>
<br /></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-80510064632453963142012-11-21T06:30:00.000+01:002013-06-01T22:35:01.391+02:00Trace Dependents before you delete a cell in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<h3>
<span lang="EN-US"><a href="http://easy-excel.com/?p=356" target="_blank">A new version of this post has been published here: http://easy-excel.com/?p=356</a></span></h3>
<span lang="EN-US"><br /></span>
<span lang="EN-US">Before you
delete a cell, you should check if there are other cells that are affected by
it. <o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US">Select the
cell, go to the Formulas ribbon and click on <b>Trace Dependents</b>. The arrows show
the dependent cells.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoNormal">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivHhZAsoQ82HciDkxhZUrWk6hhyphenhyphenppf9TXpBrRJ8NOaXWnSp3GJm-ck6na63SMyo-r6tLm27J6DFIQ03HF0fZmq4evRG7QqdP_u5nhGDA4wSTin_utFiouYDi0EaW3ocetOJX5brD5qA-U8/s1600/B11_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEivHhZAsoQ82HciDkxhZUrWk6hhyphenhyphenppf9TXpBrRJ8NOaXWnSp3GJm-ck6na63SMyo-r6tLm27J6DFIQ03HF0fZmq4evRG7QqdP_u5nhGDA4wSTin_utFiouYDi0EaW3ocetOJX5brD5qA-U8/s400/B11_1.png" width="400" /></a></div>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<br />
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
</div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-44090337350596879682012-11-20T06:30:00.000+01:002012-11-20T06:30:05.182+01:00Zoom in and Zoom out in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
This is a standard shortcut that works in most applications, including all MS Office applications and all web browsers:<br />
<br />
<b>Hold down the Ctrl key and use the scroll wheel of your mouse to zoom in and out. </b><br />
<br />
Of course, you can use the zoom bar on the right bottom of the page, but what’s the point?<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOHCVuUcSdVhR5IJqeo3Fe7Lm7-8huBNUEpESmuezawzv3Hf_miOvp8744LPOc9AyD3GY0KpkmcINU7-KCMJRVvru7Yhg2lWVY5lOncE-PwtCI5O_ChL0KXWSBcwL0lBssItzM9rFtbScN/s1600/B10_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOHCVuUcSdVhR5IJqeo3Fe7Lm7-8huBNUEpESmuezawzv3Hf_miOvp8744LPOc9AyD3GY0KpkmcINU7-KCMJRVvru7Yhg2lWVY5lOncE-PwtCI5O_ChL0KXWSBcwL0lBssItzM9rFtbScN/s1600/B10_1.png" /></a></div>
<br />
<div>
<br /></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-65108694331957528682012-11-19T06:30:00.000+01:002012-11-19T13:15:38.208+01:00Show File Path in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<span lang="EN-US">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:<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4z1zp5aaFd6FKkTH2jvwGpfgGNlAEC2ieCZpatY6uzei07iYHPbhT-rQRFPwbM2E2AobqW9KxYe8DQ0dH3GV41GzCXPfZN1S9VPrttTir5sCWAtG3VmfitywOaEr1_eWWjwbjeFm9AAxI/s1600/B9_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4z1zp5aaFd6FKkTH2jvwGpfgGNlAEC2ieCZpatY6uzei07iYHPbhT-rQRFPwbM2E2AobqW9KxYe8DQ0dH3GV41GzCXPfZN1S9VPrttTir5sCWAtG3VmfitywOaEr1_eWWjwbjeFm9AAxI/s400/B9_1.png" width="400" /></a></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"></span></div>
<div class="MsoNormal">
You only have to do this once – when you make any changes in the Quick Access Toolbar, they apply to all Excel documents. </div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b>Do like this (Excel 2010):</b></div>
<div class="MsoNormal">
1. File => Options</div>
<div class="MsoNormal">
2. Choose All Commands in the drop-down and scroll down to and choose Document Location.</div>
<div class="MsoNormal">
3. Click Add</div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC6mTobMFGxvWNOAgtj78e6rHsM3vXySDweriwmSr0NyNNPsXjXfBFpveoLhZKBynJr-0if5sTPLy3rtDEmIx3Lo09M5O5JfNt2ncMGUVe-AcvKfJWVAMn1HHVL6GgR6jrrIo6o26q7Lp5/s1600/B9_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjC6mTobMFGxvWNOAgtj78e6rHsM3vXySDweriwmSr0NyNNPsXjXfBFpveoLhZKBynJr-0if5sTPLy3rtDEmIx3Lo09M5O5JfNt2ncMGUVe-AcvKfJWVAMn1HHVL6GgR6jrrIo6o26q7Lp5/s400/B9_2.png" width="400" /></a></div>
<div class="MsoNormal">
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
<br /></div>
<div>
<b>In Excel 2007:</b></div>
<div>
1. Office button => Excel Options => Customize</div>
<div>
2. Choose All Commands in the drop-down and scroll down to and choose Document Location.</div>
<div>
3. Click Add</div>
</div>
<div>
<br /></div>
<br /></div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-33629683064453877412012-11-16T06:30:00.000+01:002013-04-19T12:12:00.349+02:00Highlight Cells in Excel that Contain a Formula<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<h3>
<b>A new version of this post has been published on my new blog: </b></h3>
<h3>
<b><br /></b><b><a href="http://easy-excel.com/?p=133">http://easy-excel.com/?p=133</a></b></h3>
<br />
<br />
<br />
Is there an easy way to locate the cells in Excel that contain a formula? Yes, there is!<br />
<br />
Open the Go to-window (Ctrl+G) and click on Special. Choose the radio button <b>Formulas</b>:<br />
<br />
<div>
</div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgWG_P6OhF-G6w3fcrNmcvnAArg-xi-v91nhYC0qildLXBMKAW5YrRtB5OKRcnzvLwY3lp9MLaEyi1k-JtZ7kW0YFuHk_3NzFve_M6tfTg0iaGgaEgK7L8Oq144NSO7jTei3RvL3M5CqGc/s1600/B8_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgWG_P6OhF-G6w3fcrNmcvnAArg-xi-v91nhYC0qildLXBMKAW5YrRtB5OKRcnzvLwY3lp9MLaEyi1k-JtZ7kW0YFuHk_3NzFve_M6tfTg0iaGgaEgK7L8Oq144NSO7jTei3RvL3M5CqGc/s400/B8_1.png" width="400" /></a></div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Click OK, and all the cells that contain a formula are highlighted!<br />
<br /></div>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgONTc6HoKhlmbZUm_lAxfv3dM9ToGARnSIl9ZU9X8UtkR00lFy8ICDkq_ZuARVFtix6VuPwqJtx_sTNzQ8jwzLQPY6EdF1JfOgZL7NsS4JMrQxGIgzzuu5yF0RlrxYmuPR9Nu0PjvnaWvM/s1600/B8_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="245" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgONTc6HoKhlmbZUm_lAxfv3dM9ToGARnSIl9ZU9X8UtkR00lFy8ICDkq_ZuARVFtix6VuPwqJtx_sTNzQ8jwzLQPY6EdF1JfOgZL7NsS4JMrQxGIgzzuu5yF0RlrxYmuPR9Nu0PjvnaWvM/s400/B8_2.png" width="400" /></a></div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<br /></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-63857977941805373672012-11-15T06:30:00.000+01:002012-11-15T06:30:02.602+01:00Create a Drop Down List in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Today I’ll show you how to create a drop down list in 20 seconds:<br />
<br />
1. Open the Data Validation window from the Data ribbon (or use the shortcut Alt => D => L)<br />
2. Select the array you want to have in the drop down list<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimO3xeijxMJQnUnpd5MxOS6LJPlGZX07Y5L6g3O6Qsq2xO_TvkR7xMxjN4Ed0hfybCFOS5hdOl-D53QhikCpzz2eBsJHoM4Ec5OIbhzrR29nu7UHyH40mRxqxHzIuP7vzM-lCEDKINsShL/s1600/B7_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="373" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimO3xeijxMJQnUnpd5MxOS6LJPlGZX07Y5L6g3O6Qsq2xO_TvkR7xMxjN4Ed0hfybCFOS5hdOl-D53QhikCpzz2eBsJHoM4Ec5OIbhzrR29nu7UHyH40mRxqxHzIuP7vzM-lCEDKINsShL/s400/B7_1.png" width="400" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Done!</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSr-TERircqq9eF9fY4CdktEjhRfbURhbPhaj5tjTlJqiuwTG4wZxWiyz3epURP_3qNe6zDdVO-WBWNm3Qx_VFa-PlyT9roROGuRNebUIWOVHt-FpSciQWN8jTM2Ykt72UYTQ7lwlAH02f/s1600/B7_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSr-TERircqq9eF9fY4CdktEjhRfbURhbPhaj5tjTlJqiuwTG4wZxWiyz3epURP_3qNe6zDdVO-WBWNm3Qx_VFa-PlyT9roROGuRNebUIWOVHt-FpSciQWN8jTM2Ykt72UYTQ7lwlAH02f/s1600/B7_2.png" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
For more posts about drop down menus, have a look at my other blog:</div>
<div>
<a href="http://exceliseasy.wordpress.com/2012/10/14/create-a-drop-down-list-in-excel-in-3-minutes/">http://exceliseasy.wordpress.com/2012/10/14/create-a-drop-down-list-in-excel-in-3-minutes/</a></div>
<div>
<a href="http://exceliseasy.wordpress.com/2012/10/15/create-a-dynamic-drop-down-in-excel-in-5-minutes/">http://exceliseasy.wordpress.com/2012/10/15/create-a-dynamic-drop-down-in-excel-in-5-minutes/</a></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-43631937001229226702012-11-14T06:30:00.000+01:002013-04-24T11:22:47.330+02:00Avoid #DIV/0 in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<h4>
<span lang="EN-US">An updated version of this post has been published here:</span><span lang="EN-US"><a href="http://easy-excel.com/?p=381">http://easy-excel.com/?p=381</a></span></h4>
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US">In the
table below we get the #DIV/0! error because there are no values in the cells
that the formula refers to. Let’s see how we can avoid it.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwT0mTl3u6ONoHSFm_LkRP1gewyCu8abOry0k_3sUx_OWh7Yo17_DFlZgybsId1Q2NIDPeED-IIcTMNd4NKPSv68076nLkMzY8_u4zCs_rDh-Au9kSOxhjpOrkR8XP4q_Rdha_MUjk2JvL/s1600/B6_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="247" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwT0mTl3u6ONoHSFm_LkRP1gewyCu8abOry0k_3sUx_OWh7Yo17_DFlZgybsId1Q2NIDPeED-IIcTMNd4NKPSv68076nLkMzY8_u4zCs_rDh-Au9kSOxhjpOrkR8XP4q_Rdha_MUjk2JvL/s400/B6_1.png" width="400" /></a></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-US"></span></div>
<div class="MsoNormal">
<span lang="EN-US">You don’t
want to make any changes only in the cells that turn out to return this error
message – that will get you in trouble if you change the data later, so we’ll
write a formula that takes into account that some cells are empty. <o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US">Let’s wrap
the <b>IFERROR</b> function around it:</span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><b>=B4/C4</b> becomes <b>=IFERROR(B4/C4,”-“)</b><o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US">What we do
is to tell Excel to return whatever is between the double quotes (“) if the
formula returns an error. Problem solved!</span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidXnVZiXPWA8CApcTsUY4Uo88DVNeBvuo0dwvIgbjpGak8xQmbuav7Mmd-mvGf_2bknBv5Tm7VcbqM7oRoS_9_6XcUZZ-H9kU4ryA-ZPOOqiSFAcdP3XQgmlEQPi3mrp-A5so1LOASjjaX/s1600/B6_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidXnVZiXPWA8CApcTsUY4Uo88DVNeBvuo0dwvIgbjpGak8xQmbuav7Mmd-mvGf_2bknBv5Tm7VcbqM7oRoS_9_6XcUZZ-H9kU4ryA-ZPOOqiSFAcdP3XQgmlEQPi3mrp-A5so1LOASjjaX/s400/B6_2.png" width="400" /></a></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<br /></div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-39011610282923411302012-11-13T06:30:00.000+01:002013-08-22T15:45:02.720+02:00Copy Format in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<h4>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">This blog is no longer being updated. Please visit my new blog at <a href="http://www.easy-excel.com/">www.easy-excel.com</a> for an updated version og this post: <a href="http://easy-excel.com/?p=715">http://easy-excel.com/?p=715</a></span></h4>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Sometimes
some of the data in a table have the wrong format. Here is an easy way to fix
it:</span><br />
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgga98Z-ULXlCoHuFOxDA9qXA655nzTNpCQcQUftdzsKEDat8jkU_fyVOaD4zjctE8onE2OESqxcJvJQlUyMv2Lg2rFfa-__8LdJoSjaBENGFaKLzLm7-EGe8BTKSG_3JquQ-9awTjB6hxh/s1600/B5_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="215" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgga98Z-ULXlCoHuFOxDA9qXA655nzTNpCQcQUftdzsKEDat8jkU_fyVOaD4zjctE8onE2OESqxcJvJQlUyMv2Lg2rFfa-__8LdJoSjaBENGFaKLzLm7-EGe8BTKSG_3JquQ-9awTjB6hxh/s400/B5_1.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span>
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">Choose one
of the cells with the right format and click on the Format Painter on the Home
ribbon.</span><br />
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYg8nvrmIAYZn7jdM5tC9qpviBauRvzc3_EpHT9N82cZTuh2Rdcwtgye8wFzsnslEaVdDx3aftgUeoxTMsxlglJen-y4gYOaBz1yMQM0CkWUCJHGTgsPNI7SUUfgPY3MO75JrGjXriPJvw/s1600/B5_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYg8nvrmIAYZn7jdM5tC9qpviBauRvzc3_EpHT9N82cZTuh2Rdcwtgye8wFzsnslEaVdDx3aftgUeoxTMsxlglJen-y4gYOaBz1yMQM0CkWUCJHGTgsPNI7SUUfgPY3MO75JrGjXriPJvw/s1600/B5_2.png" /></a></div>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span>
<span lang="EN-US" style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;"><br /></span><span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;">Select
the cells you want to change, and they will get the same format! If you want to
change formats in several different arrays, double-click on the format painter
and press Escape when you’re done.</span><br />
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge2dOy7W92wORo904dDXLCIlRZQTuJavYJ4Ar1qrU_Lb2ljvwVy7O4-GOdmNUsCOP3mhlGy7dTuWGBCSwKE7gLXqcb2nwukMszPmkYjFhAIfJrsbPUib_cOOH-9RXYDo_sQj4rtibI-V9Z/s1600/B5_3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="207" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEge2dOy7W92wORo904dDXLCIlRZQTuJavYJ4Ar1qrU_Lb2ljvwVy7O4-GOdmNUsCOP3mhlGy7dTuWGBCSwKE7gLXqcb2nwukMszPmkYjFhAIfJrsbPUib_cOOH-9RXYDo_sQj4rtibI-V9Z/s400/B5_3.png" width="400" /></a></div>
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<span style="font-family: Calibri, sans-serif; font-size: 11pt; line-height: 115%;"><br /></span></div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-6841789257416316852012-11-12T09:23:00.000+01:002012-11-12T09:26:05.367+01:00Keep the Heading visible in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<span lang="EN-US">How can you
keep the heading visible in a long list when you scroll down? Easy – use the
Freeze Panes feature!<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US">Select the
row <b>below</b> the one you want to lock and choose Freeze Panes from the View ribbon:<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIA4kLytTQrkBNR23l28nk0I1Vk5IQCOKt0LTHLVHUNOHtIDy1MMmh7PZGwgdfVeynwlK5vmjxFlFqTWKvF7U0DqxVWh0HECEkEKwpe9zoUpwUJd8mykbQukaEVb51ZaqaZLuJRjoYHn6r/s1600/B4_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="242" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIA4kLytTQrkBNR23l28nk0I1Vk5IQCOKt0LTHLVHUNOHtIDy1MMmh7PZGwgdfVeynwlK5vmjxFlFqTWKvF7U0DqxVWh0HECEkEKwpe9zoUpwUJd8mykbQukaEVb51ZaqaZLuJRjoYHn6r/s400/B4_1.png" width="400" /></a></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-16034536499527038862012-11-11T11:25:00.000+01:002012-11-13T08:53:18.557+01:00Add Sums to an Excel Table<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<span lang="EN-US">In this
post I will show you how to sum up all the values in a table in a second:<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US">Select all
the values in the table plus one extra column and one extra row for the sums:<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj20NbCi7dGhOUggoDUKCiJclKk5JfsB-pMoG2gHNeFJpwNeFtKpeIAUpl0O-ol5x_xclAjQovExrAYQGksrQXqpSjDo1LIgGlfhSuU1r_FXv4Pj0a7snMJcOlVSpjaar16p5ipN1kcOboC/s1600/B3_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj20NbCi7dGhOUggoDUKCiJclKk5JfsB-pMoG2gHNeFJpwNeFtKpeIAUpl0O-ol5x_xclAjQovExrAYQGksrQXqpSjDo1LIgGlfhSuU1r_FXv4Pj0a7snMJcOlVSpjaar16p5ipN1kcOboC/s400/B3_1.png" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div class="MsoNormal">
<span lang="EN-US">Press <b>Alt +
Equal sign (=)</b> and Excel adds all the sums:</span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqm-mmyauogz0DyapUG4FnOyzDKmjwuR3AV3ehMj7QHmwdWi1JcKBAPfX8lP5mrmbPH9wabGJEkaedQrQ8BLrS-yKd1DDOyQxwV4wlvtv8EbTG5_W1C-qj0J53MPgMO2fVeeHojx9vlxxa/s1600/B3_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="162" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqm-mmyauogz0DyapUG4FnOyzDKmjwuR3AV3ehMj7QHmwdWi1JcKBAPfX8lP5mrmbPH9wabGJEkaedQrQ8BLrS-yKd1DDOyQxwV4wlvtv8EbTG5_W1C-qj0J53MPgMO2fVeeHojx9vlxxa/s400/B3_2.png" width="400" /></a></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-73790258509133142352012-11-10T20:34:00.000+01:002013-04-19T12:14:09.652+02:00Hide Zeroes in a Table in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<h3>
<span lang="EN-US">A new version of this post has been published here:</span><span lang="EN-US"><br /></span><span lang="EN-US"><a href="http://easy-excel.com/?p=319">http://easy-excel.com/?p=319</a></span></h3>
<br />
<span lang="EN-US"><br /></span>
<span lang="EN-US"><br /></span>
<span lang="EN-US">Is it
possible to hide all the zeroes in this table? Yes, and it’s easy!<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB1_uNIq51sxCjSBtaTrfvre4yCkU1MzaKD_SZJBHpw0hp2yfo4wKQccmzkYMwg11Z1raUQp70agC2Q6k7N0DIhqqaoSakO2qKROaRlXC9hMbqdYEXz2s-YvlZZZ0I6z3oni2A4oH5E53G/s1600/B2_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB1_uNIq51sxCjSBtaTrfvre4yCkU1MzaKD_SZJBHpw0hp2yfo4wKQccmzkYMwg11Z1raUQp70agC2Q6k7N0DIhqqaoSakO2qKROaRlXC9hMbqdYEXz2s-YvlZZZ0I6z3oni2A4oH5E53G/s400/B2_1.png" width="400" /></a></div>
<br />
<br />
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Select the
cells, go to the home ribbon, choose Conditional Formatting => Highlight
Cell Rules => Equal to...</div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWPCY2raHFeCK1iDHEWXmBAwAYYL59XvyuZhuwcDhXfumirdYIW1AtT8iR9-0isBLhwiavYJ1JUTSHyeGe5CJPjmQBJJQiL1okbwdslI-J_OVuquTLfK-mVsj24vH48a4m6eTEl0N7jrVM/s1600/B2_2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="157" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWPCY2raHFeCK1iDHEWXmBAwAYYL59XvyuZhuwcDhXfumirdYIW1AtT8iR9-0isBLhwiavYJ1JUTSHyeGe5CJPjmQBJJQiL1okbwdslI-J_OVuquTLfK-mVsj24vH48a4m6eTEl0N7jrVM/s400/B2_2.png" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Type a zero
in the left field and choose Custom Format in the drop-down menu.<br />
<div class="MsoNormal">
<span lang="EN-US"><br /><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiFjUKAhML396XSJHBOhmx_EgZ24Lm9c5Bs4zWhDSGJtLDeDHpy5EEPevFuXVKogsOntUuWyx_zuNU-FqNq6JYMZWSKM-s33vax7RAlW_6GFQ1cMQWXWWVXv6WvblYm-62vKMur05diBq6/s1600/B2_3.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="202" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiFjUKAhML396XSJHBOhmx_EgZ24Lm9c5Bs4zWhDSGJtLDeDHpy5EEPevFuXVKogsOntUuWyx_zuNU-FqNq6JYMZWSKM-s33vax7RAlW_6GFQ1cMQWXWWVXv6WvblYm-62vKMur05diBq6/s400/B2_3.png" width="400" /></a></div>
<br />
<br />
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-US">Go to the
Font tab and choose white colour (or light grey, if you don't want to hide them completely): <o:p></o:p></span></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhInQLZX7hqShWnf0cEE0_V0bqrnapcn6WzytGhtSeJNiVVDkE8rLrjhyphenhyphen1AMOuhENtQmzasu0OWGvOnmzcNS8uszfFxCQ2tnXKVbQUQ1bAM3byQAJIJHUx6xD2fS1l-TJeBbyypeEOiXd6H/s1600/B2_4.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="383" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhInQLZX7hqShWnf0cEE0_V0bqrnapcn6WzytGhtSeJNiVVDkE8rLrjhyphenhyphen1AMOuhENtQmzasu0OWGvOnmzcNS8uszfFxCQ2tnXKVbQUQ1bAM3byQAJIJHUx6xD2fS1l-TJeBbyypeEOiXd6H/s400/B2_4.png" width="400" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
And now the
table looks nice and clean:<br />
<div class="MsoNormal">
<span lang="EN-US"><br /><o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrb892mGZOqL7yUbv4D5EMNLU2aZcUOIUn4EKTFyJLrY1WQQ42jSTi64Q-7kSHtz4kkujWT3BYikHMkUD4zI8SsyljNxbvrObdhUv1jbAayQlk9T_FQ6SUIsbZAv0Uob6v_8GmqnwiH-LZ/s1600/B2_5.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="125" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrb892mGZOqL7yUbv4D5EMNLU2aZcUOIUn4EKTFyJLrY1WQQ42jSTi64Q-7kSHtz4kkujWT3BYikHMkUD4zI8SsyljNxbvrObdhUv1jbAayQlk9T_FQ6SUIsbZAv0Uob6v_8GmqnwiH-LZ/s400/B2_5.png" width="400" /></a></div>
<span lang="EN-US"><span id="goog_593389192"></span><span id="goog_593389193"></span><br /></span></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-36159271015553951782012-11-10T10:17:00.001+01:002012-11-13T08:52:04.903+01:00Remove Duplicates in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
How can you
remove duplicates from a list?<br />
<div class="MsoNormal">
<span lang="EN-US">Easy! Excel
has a built-in feature for this. Just select one of the cells in the list and
click on Remove Duplicates on the Data ribbon.</span></div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoMHgk61d7o8VaemAJtYMuWy4p5u1IxbzmlaXX4PREjXY5oDkymbP2QlRs1JLzMxnY_PttcHW4B1G4R_sPBzqUVWNhnNdAhO9ic6ZZjT-ozehrc1DPW9_xidpOHwN_6X0S8MOXpluzA7Fl/s1600/B1_1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="315" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoMHgk61d7o8VaemAJtYMuWy4p5u1IxbzmlaXX4PREjXY5oDkymbP2QlRs1JLzMxnY_PttcHW4B1G4R_sPBzqUVWNhnNdAhO9ic6ZZjT-ozehrc1DPW9_xidpOHwN_6X0S8MOXpluzA7Fl/s400/B1_1.png" width="400" /></a><span lang="EN-US"></span><br />
<span lang="EN-US"><span lang="EN-US"><br /></span></span>
<span lang="EN-US"><span lang="EN-US"><br /></span></span>
<span lang="EN-US"> <o:p></o:p></span><br />
<br />
<br /></div>
<div class="MsoNormal">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Voilà, the
duplicates are gone:</div>
<div class="MsoNormal">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCZ9z_kAva8JlkuQpvuHsVB3QIvnVoa8dXuaL-F_sl0zMpAfetp60ebr3CM0XZ4heofAi8Q3JfrwVPypObnWdmhCs_o87DVN_K2Vt5N7B8iS-1mYGWeRdkD59Mj2iDVf0lLsYyZnGWKagg/s1600/B1_2.png" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCZ9z_kAva8JlkuQpvuHsVB3QIvnVoa8dXuaL-F_sl0zMpAfetp60ebr3CM0XZ4heofAi8Q3JfrwVPypObnWdmhCs_o87DVN_K2Vt5N7B8iS-1mYGWeRdkD59Mj2iDVf0lLsYyZnGWKagg/s1600/B1_2.png" /></a><br />
<br />
For more advanced ways to handle duplicates (and triplicates, quadruplicates etc.), take a look at my <a href="http://exceliseasy.wordpress.com/2012/11/12/find-duplicates-and-triplicates-in-excel/" target="_blank">blog Excel is Easy</a>.</div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0tag:blogger.com,1999:blog-7820935747755231908.post-32774391671956984952012-10-30T11:54:00.003+01:002012-11-13T11:46:09.661+01:00About this blog<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div style="background-color: white; color: #555555; font-family: Arial, Tahoma, Verdana; font-size: 11.818181991577148px; line-height: 20px; padding: 0px 0px 15px;">
In this blog I will share some easy Excel tricks that will make your life a little bit easier. I will publish one trick every morning, Monday to Friday, so be sure to bookmark this blog or add it to your blog reader.<br />
<br />
Excel is packed with built-in features and little-known functions that many people don't know about. In this blog I will show you some of these features. There will only be short posts which take a minute to read, about tricks that take a minute to perform!<br />
<br />
I hope you will enjoy this blog!<br />
<br />
If you want to read about some more advanced Excel tricks, please visit my other blog: <a href="http://exceliseasy.wordpress.com/">http://exceliseasy.wordpress.com/</a></div>
<div style="background-color: white; color: #555555; font-family: Arial, Tahoma, Verdana; font-size: 11.818181991577148px; line-height: 20px; padding: 0px 0px 15px;">
<br /></div>
</div>
Audun Danielsenhttp://www.blogger.com/profile/17395169455305650743noreply@blogger.com0