Exceljet

Quick, clean, and to the point

How to ask a question about Excel

Tips on how to ask good Excel questions

Every day, thousands of questions about Excel are posted on the internet. Many go unanswered because they are unclear, or too complicated to understand. Below are six tips to write a better question that will attract good answers quickly.

1. Search for existing solutions

Try a search first to see if you can find an existing solution you can use or adapt. You can save a lot of time by finding a path others have already travelled.

2. State your goal clearly and briefly

Be clear about what you want. For example:

CONCAT & TEXTJOIN

Fiddles with new CONCAT & TEXTJOIN functions

I've been playing around with the TEXTJOIN and CONCAT functions this week. These are both new functions in Excel 2016, introduced in the Office 365 subscription service.

Both of these functions let you join (concatenate) text in different cells together. TEXTJOIN lets you join values with a delimiter of your choice, and has an option to ignore empty values. CONCAT simply mashes all values together without options.

Tags 

20 very popular Excel shortcuts

Popular Excel shortcuts

We ran a survey on Excel shortcuts. Here are the results, based on over 800 replies.

I've also compiled a list of the most 20 popular Excel shortcuts below. This is a tricky business, because people often don't know what to call shortcuts, or how to refer to them. So I've had to "interpret" many of the shortcuts peopled named. That said, the patterns are clear, and the best shortcuts naturally bubbled up again and again. It's a great list.

Dave

Tags 

How to disable Scroll Lock in Excel

The evil scroll lock enabled in Excel 2010

Your report is due in an hour. You're working along in Excel, things are going fine, when suddenly you notice that you can no longer move around properly. You press the arrow keys, but instead of the cursor moving to another cell, the entire worksheet seems to be moving about. WTF?! 

Before you panic, and call support to tell them Excel is broken, check to see if Scroll Lock has been accidentally enabled. 

Tags 

Top 10 reasons to learn Excel formulas

Learn Excel formulas and differentiate yourself

If you've ever wondered whether learning Excel formulas is worth your time, this list is for you!

Formulas are the heart of spreadsheets, so your skill with them can help you in many ways. Read below for 10 reasons you should take time to increase your skill with formulas.

1. Formulas are important in many jobs. In a recent survey we conducted about formulas, over 90% of respondents said that Excel formulas were "important", "very important", or "vital" to their job.

Tags 
In this video we show you how to find and replace formatted values or change just the formatting.
In this video we show you how to find all matches at the same time.

Pages

Subscribe to Front page feed