Print Worksheets in One Page Across [Quick Tips]
Have you ever wondered how to print excel sheets in one page across? so that when you print a large excel spreadsheet the output can be read one page after another. We can use the print settings in Excel to do this very easily. In this episode of quick tips we will learn how to do this with in 5 seconds.
The 1000th Post
It is not everyday that a blog boasts of 1000th post. After blogging for 1999 days ie 5 years 5 months 24 days, finally, this is my thousandth post.
While this is not a real mile stone or anything, I want to use this post to say thanks. Without you, this mile stone means nothing to me. 🙂
How to Print Excel Comments
We all know how to make comments on excel documents, just select the cell where you want a comment, press SHIFT+F2 and make the comment. But the comments are only visible when you open the workbook. What if you want to print out an excel file, but include all the comments as well?
Turns out you can do that with a hidden option in excel page setup.
Excel Links – Learn Excel Online Edition
Recently I have conducted a survey on my blog to find out your pulse on PHD. Quite a few survey respondents have told me that PHD needs a topic-wise archive so that you can learn excel easily. So over the weekend I have prepared a webpage where you can find topic-wise posts on excel and […]
Format Charts Faster in Excel 2007 [quick tips]
Most of us use chart formatting options to change the way grid-lines, data series, labels, axis, titles, plot areas look. Chart formatting is one of the areas where people spend most time. Today I want to teach you a quick productivity hack to speed up chart formatting. In excel 2007 and above, when you click […]
Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]
Every year, on 4th Thursday of November, folks in US celebrate Thanksgiving day. A similar holiday exists in Canada too, they celebrate it on Second Monday of Every October.We will celebrate thanksgiving in PHD style, by sharing a wacky formula tip.
Today, we are going to learn how to use excel formulas to find out thanksgiving day’s date for any year.
Reverse a List using Formulas [Using Excel INDEX() Formula]
Here is a simple yet novel use of formulas. Let us say you have a list of values in range A1:A5 and you want to reverse the list. In an empty cell write =INDEX($A$1:$A$5,6-ROWS($A$1:A1)) and copy down. Boom, you get the reversed list. Here is how the formula works: In the reversed list, first item […]