Use CTRL+Enter to Enter Same Data in to Multiple Cells [Quick Tip]
Here is a quick Excel tip to kick start your week.
Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap.
(1) Select all the cells where you want to enter the same data.
(2) Type the data
(3) Press CTRL+Enter
(4) Done!
See the animation aside to understand how this works.
Quick Update about VBA Classes & Discount Expiry!
I have 2 quick announcements & 1 Excel tip for you.
Announcements
- Registrations for next batch of VBA Class start form January 11th (Wednesday). Please click here to download the course brochure.
- 20% Holiday discount on Excel School expires tonight (Midnight, Pacific Time). Please visit Excel School page and use the code LETSGOEXCEL to claim your discount.
Read on for a bonus Excel tip as well.
Make VBA String Comparisons Case In-sensitive [Quick Tip]
Today, while answering a reader’s email, I wrote this VBA code, If Target.Value = “yes” Then ‘do something End If But I realized that my code would run only the Target cell has “yes” in it. It wont run if the target cell has “YES”, or “Yes” or “YeS”. This is because by default, all […]
Add Data to Charts with Copy Paste [Quick Tip]
So how did your weekend go?
I did a bit of gardening, painted our car shed, played badminton (I am learning), attended 60th birthday of a close friend’s dad. Pretty hectic, but fun as usual.
To start this week, let me share a simple but fun way to add data to charts.
Lets say you have a chart that depicts Annual sales for last few years. And you want to add the data of Profits (or Expenses) to this chart. Here is a dead-simple way to do it.
- Copy the profit data by selecting it and pressing CTRL+C
- Select the chart
- Paste by pressing CTRL+V
- That is all!
Quickly Fill Blank Cells in a Table [Reader Tip]
This post is authored by Martin, one of our readers.
Situation:
Sometimes I encounter data in my tables with blank cells where there is a repeated value from the cell directly above. See below:
This can be annoying when it comes to interpreting the data and when sorting columns.
Solution:
To know how I solve this, just read rest of the article.
Filter values where Fruit=Banana OR Sales>70. In Other Words, How to use Advanced Filters?
Filtering is a simple yet powerful way to analyze data. When you apply filters to any list of values, Excel gives you some really useful pre-defined filters so that you can analyze the data in a variety of ways. So, assuming you have data like this: We all know how to filter data for Bananas. […]
Refresh All Pivot Tables at once [Quick Tip]
Pivot Tables are an integral part of Excel based reports. So it is no surprise that many of create multiple pivot reports in one Excel workbook. So when the underlying data changes, we often spend time refreshing individual pivot tables. Today, I want to share a quick tip about how to refresh all pivot tables […]