Formatting Multiple Worksheets? Use Group Sheets option to Speed up [Quick Tip]
Often we come across workbooks that have similar formatting needs for multiple worksheets. For eg. you may have sales records spanning across 12 worksheets, one for each month. Now as a loyal reader of chandoo.org, you want to keep the formatting of all these worksheets consistent. So here is a quick tip to begin your work week.
Learn an Excel Feature: Picture Links (or Camera Snapshots)
Today I want to introduce a new excel feature to you, called as Picture link.
Well, picture links are not really new, they are called as camera snapshots in earlier versions. They provide a live snapshot of a range of cells to you in an image. So that you can move the image, resize it, position it wherever you want and when the source cells change, the picture gets updated, immediately.
How to Paste Numbers Only [quick tip]
Sometimes when you are working with data, you may need to just copy and paste numbers from one range to another. Here is a handy little trick to achieve that.
Use Paste Special > Add operator to paste numbers only.
1. Select the source range, press CTRL+C
2. Now, go to target range, press ALT+ES to activate paste special dialog
3. Select “Add” operator (you can press d)
4. Click ok.
Jump to Any Cell / Worksheet using Name Box [Quick Tip]
Welcome back. Did you have a good weekend?
We ate fish, watched a movie, had hilarious moments watching the kids and didn’t even leave the house for anything other than to buy some fish.
Coming back to Excel, I want to share a simple productivity tip with all of you. I accidentally learned this and now I use it often to speed up when I am working on large excel files.
Jump to Any Cell / Worksheet using Name Box
If you want to quickly jump to a named range or another worksheet, here is a quick trick. Just enter that name or address in the name box (top-left corner, next to formula bar). And bingo, you are on the target cell or sheet.
Take your Excel Baby Steps with 89 Minutes of FREE Online Training
I don’t remember when was the last time both of us (Jo and I) were this excited. And the reason?
Nakshatra and Nishanth have started taking their first steps last week !!!
It is such a joy watching them take one step at a time. Aah, the beauty of parenting 🙂
So I asked myself, “What is a good way to celebrate this without looking like a super-excited dad?” and I got my answer in 72 milli-seconds.
I have created 10 short (<10 min) videos helping you to take baby steps in Excel world. Each video introduces you to one new functionality of Excel and shows you some nice examples. Before jumping straight in to the videos, I want to share a short clip (30 seconds) of our kids taking their baby steps.
Between Formula in Excel [Quick Tips]
Checking if a value falls between 2 other values is fairly common when you are working with data. In today’s quick tip, we are going to learn how to check for such between conditions in excel. You will be learning how to check if a value, date or text falls between 2 other values, dates or texts (when arranged in dictionary order) as shown in the picture aside.
How to Add your Macros to QAT or Excel toolbars?
Ok, so you have written a shiny new macro to solve all the problems. The macro, solveWorldProblemsAndMakeSomeCoffee() sits nicely in your personalmacros.xlam file somewhere in C drive. You have also installed the macro as an add-in so that it is always available. But wait!!! How do you run your sWPAMSC everyday in the morning? (ok, […]