Excel Links of the Week [Jan 12]
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.
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
Here is a very simple printing trick to get your excel sheet printed on one page
JP offers a very good tutorial on creating named ranges in Excel.
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 🙂
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.
Thank you and see you around.
Leave a Reply
|« Featured Visualizations – Jan 09
|What are the formulas you wish Excel had ? »