« Back to blogAboutContactArchivesAsk an Excel Question Excel Shop
Pointy Haired Dilbert - Chandoo.org - Learn Excel and Charting Online
  • Kickass Stuff!
  • Excel Tips
  • Charting Tutorials
  • Excel Dashboards
  • Top Excel Formulas
  • Downloads
  • Subscribe

All articles with 'paste-special' Tag

Use Paste Special to Speed up Chart Formatting [Quick Tip]

Published on Feb 24, 2010 { 15 Comments }
Use Paste Special to Speed up Chart Formatting [Quick Tip]
Continue »

Fix Incorrect Percentages with this Paste-Special Trick

Published on Jan 29, 2010 { 6 Comments }
Fix Incorrect Percentages with this Paste-Special Trick
Continue »

Transpose Excel Rows and Columns [Quick Tip + Video]

Published on Nov 18, 2009 { 2 Comments }
Transpose Excel Rows and Columns [Quick Tip + Video]
Continue »

Copy Data Validations from one cell to another [quick tip]

Published on Oct 28, 2009 { 6 Comments }
Copy Data Validations from one cell to another [quick tip]
Continue »

Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad

Published on Sep 25, 2009 { 6 Comments }
Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad
Continue »

Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)

Published on May 26, 2009 { 16 Comments }
Do you know these Excel 2007 Productivity Secrets (Hint: Coffee is not one of them)
Continue »

Skip Blank doesnt skip blank cells ?!?

Published on Mar 19, 2009 { 9 Comments }
Skip Blank doesnt skip blank cells ?!?
Continue »

Weekly Links – Even More Downloads Edition

Published on Feb 10, 2009 { 1 Comment }
Weekly Links – Even More Downloads Edition
Continue »

Copy like a cat – paste like a pro : 17 excel pasting tricks you must know

Published on Jul 2, 2008 { 69 Comments }
Copy like a cat – paste like a pro : 17 excel pasting tricks you must know
Continue »
FREE E-mail Updates
Add to your RSS reader
Subscribe to Feed Add to Google Reader or Homepage Add to Yahoo more
Meet Chandoo
Chandoo - AvatarAt Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. Read more.
Connect

New to Excel?
1. 100 Excel Tips & Tricks
2. Excel Pivot Tables - Tutorial
3. 51 Excel Formulas in Plain English
4. VLOOKUP Formula for Dummies
5. Free Excel Chart Templates
Advanced Excel Tricks
1. Excel Dynamic Charts
2. Learn Conditional Formatting
3. Making Dashboards using Excel
4. Project Management with Excel
5. Working with Excel Tables
Topics & Archives
1. Learn Excel - Topic-wise
2. Charting Tips, Tricks and Tutorials
3. Ask an Excel Question
4. Most Popular Posts on PHD
5. Excel Tips, Tricks and Tutorials
6. Excel & Charting Quick Tips
7. Free Excel Templates
  • Recent Comments

    • Daniel Ferry: Sorry, that was the direct link to the workbook. Here’s a...
    • Daniel Ferry: Chandoo: Here’s 42 European flags in ONE CHART! I...
    • Jamie Regan: I don’t understand the difference between actual and %...
    • Pedro: As I like this flags exercise and as I am european, I just upload it...
    • Santosh: Hi, Thanks a lot for your effort to make our life easier. Can you...
    • Clarity: I also add in a couple of custom buttons on there for a format macro...
    • Hui: I always add Set Print Area, Print Preview, Print, Paste Values, Paste...
    • Joseph: Thanks for the tip. However, doesn’t Ctrl + Click do the same...
  • RSS Recently Popular

    • Pivot Table Tricks to Make You a Star
    • Flu Trends Chart in Excel [Yes, we can edition]
    • Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls
    • Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
    • Best Charts to Compare Actual Values with Targets – What is your take?
  • RSS On PHD Forums

    • Dee on "Track changes in sheet containing tables"
    • Tickles on "Gantt charts from Pivots with data sourced from Access"
    • simcat95 on "Automatic Format Axis"
    • Hellcat94 on "Move Cells from one sheet to another"
    • ashfire jon on "IF this equals that OR that or that, then....."
  • Create Excel dashboards quickly with Plug-N-Play reports.
  • Disclaimer

    This is a personal blog, don't take it too personally. I post whatever I want, you read whatever you like. Oh yeah, PHD tastes better with a latte, caramel if you please. So read, repeat and enjoy. Our Policies

Copyright © 2010 Pointy Haired Dilbert: Learn Excel Online – Chandoo.org All rights reserved
Wordpress powered theme by PremiumThemes.net

  • Home
  • About
  • Archives
  • Subscribe
  • Download Free Excel Templates