fbpx
Search
Close this search box.

Excel Links of the Week [Jan 12]

excel links - 2 comments

Everyweek PHD shares some of the Excel links to help you learn better and become productive at using Excel. This weeks edition will help you with printing, creating named ranges, finding excel version.

Check your Excel Version using VBA

Often you might need to check which version of Excel user is running to avoid compatibility issues. Here is a VBA script that will do the task for you

How to print an excel sheet in one page?

Here is a very simple printing trick to get your excel sheet printed on one page

Excel Tutorial : Naming a range

JP offers a very good tutorial on creating named ranges in Excel.

Why you cannot open two excel files with same name

Microsoft Excel Team blog answers this question in one line:

“calculation ambiguity with linked cells. If you had a cell ='[Book1.xlsx]Sheet1′!$G$33 and you had two books named “Book1” open, there’s no way to tell which one you mean”

Got a link?
Please share with us through comments 🙂

Chandoo

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

Written by Chandoo
Tags: , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

2 Responses to “Excel Links of the Week [Jan 12]”

  1. JP says:

    Thank you Chandoo, and I have more tutorial posts on the way, about 10 in all. Plus I'm excited about a new Excel add-in I'm working on, and several other blog posts are also in the works.

  2. Chandoo says:

    @JP.. That is good to know. Tell us more about your add-in once it is ready. I am sure many readers will like it.

Leave a Reply


« »