Here is a quick announcement folks!
Many of you asked me whether we are going to have a holiday sale at Chandoo.org this year. Of course we have a sale!
Details of Chandoo.org Holiday Sale – 2012
Dates of the sale – 3rd & 4th December, 2012 (Monday, Tuesday)
What is on sale?
This year, you can save up to $50 on our best selling training courses.
- Course: Excel School Dashboards program
- Discount: $30
- Course: Excel School + VBA + Dashboards program
- Discount: $50
With both of these courses, you get full downloads, 1 year access to all material & excellent support. More than 2000 professionals from all over the world have gone thru these 2 courses & became awesome in Excel. Now its your turn.
Remember: the sale opens on 3rd December 6AM and closes well after midnight on 4th December (Pacific Time)
What a bummer, I just paid full fees:
Do not worry. We take excellent care of our existing students. For all of you who joining either of these programs in last 3 weeks, I am going to send a special bonus (valued $50) to compensate. Why? because we are awesome like that!
That is all for now. See you next week.
15 Responses
Align charts to grid by holding alt while moving them. Same goes when resizing them.
please how can i debug a cell hidden with formula becos right now i just got a job but my predecessor lock all formular and no handover note . please i need to rescue my self becos there is a report to submitt this weekend
Ralph, Google unlock excel without password. You’ll find some VBA that will unlock everything for you
I still use this code to remove internal passwords:
http://www.mcgimpsey.com/excel/removepwords.html
Also, clicking format painter twice will keep it selected for multiple uses. Small thing but easy to miss
Wow! That’s a very useful tip – thanks a ton.
Wow ! Amazing. I never thought this would be possible at all. *THUMBS-UP !
Thanks for this Chandoo – very useful and a good reminder – sometimes forget all the available tricks!
Ralph,
Yo can try the unlcok VBA codes, that are simple, or you can open another excel sheet and get the data from the locked one. In the new one, the data will be unloced and unformated.
#5 question
how do i un-bug then again. when i press F9 i get the value but what shortcut can i press to get back the formula? Now i only know to press enter and press excel undo but i am sure there is a faster way.
thank you!
Press ESC. This will exit the formula editing mode and reverts to original formula.
#4 – CTRL+ENTER is a nice trick but be aware that it creates an array of the selected cells so that you cannot insert/delete the rows of columns of the array or edit an individual formula in the selected cells.
I think you are talking about CTRL+SHIFT+ENTER which is used to enter array formulas. CTRL+ENTER simply fills all the selected cells with same contents that you have in active cell of selected range(Constant values or formula both, as the case maybe). Also for CTRL+ENTER, the selected cells may or may not be a continuous range. If works on both continuous and non-continuous selections.
You are correct Ajesh. I read it as CTRL+SHIFT+ENTER instead of CTRL+ENTER. Both work in Chandoo’s tip but obviously CTRL+ENTER would be the better one to use. Thank you.
Dear Chandoo,
I want to know if it is possible to do the same pivot table “User interaction hacks”
Thx
CL