Enter same data in multiple cells
Windows shortcut
CtrlEnter
Mac shortcut
⌃Return
With multiple cells selected, this shortcut will enter the same data in all cells in the selection at once. This is a great way to skip a copy & paste step. Cells do not need to be contiguous; use Control (Win) or Command (Mac) to select non-contiguous cells before using Control + Enter.
Related videos
In this video, we run through more than 20 tips you can use to save time with Excel formulas today. We believe in making videos that are quick and to the point, so this is a rapid-fire list. We trust that you can rewind the video as needed :)
One of the biggest mistakes you can make is to hard code assumptions into your formulas. Instead, if a value might change, put it in a cell and refer to it with a reference, as explained in this video.
The data labels in Excel charts are flexible and powerful. While you can easily use them to display values from source data, you can also display values from other cells. The video below shows how to leverage this feature to dynamically display the minimum and maximum value in the data, using formulas.
Some formulas you see in Excel can be extraordinarily complex. But all complex formulas are built from simple steps. In this video, we built a more complex formula step by step.
In this video, we show how to plot American generations in a floating horizontal bar chart. This seems like a simple problem, but it requires a formula, clever formatting, and a special feature of data labels. A nice example of what can be done with Excel's charting engine.
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and even random text values. This is a great way to create dummy data to test formulas and worksheets.
In this video, we look at how to use the SMALL and LARGE functions to get the nth value from a data set. You can use these functions to get the top 3 test scores, top 5 fastest times, and so on.
In this video we show how to highlight approximate match lookups with conditional formatting and the LOOKUP function. Highlighting approximate matches is tricky, because you must replicate the original approximate match in the CF rule.
In this video, we look at how to simulate a drawing and pick winners in a contest with Excel, using the RAND and RANK functions together.
An easy way to add missing values to data using a dead-simple relative formula and a few other tricks to select empty cells.
In this video, we look at a way to fill in missing data when the structure is not consistent, using formula created with IF and ISBLANK functions.
In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated formulas based on VLOOKUP, INDEX and MATCH, or nested IFs.
A short introduction to the CODE and CHAR functions, two geeky (but surprisingly useful) functions that help you manipulate text in Excel.
In this video, we look at how the MATCH function can find the position of an item in a list. Once you have a position, you can use it to get related values with INDEX.
Conditional formatting with formulas can be tricky because you can't see what happens to the formula when the rule is applied. Dummy formulas let you visualize how formulas will behave before you create a rule. This video shows you how to test with dummy formulas, for perfect conditional formatting, every time.
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows, and so on. This can be a nice way to make certain tables easier to read.
Download 200+ Excel Shortcuts
Comments welcome! Read this before posting a question.
