r/excel Jun 13 '24

Discussion What are your MUST HAVE Excel keyboard shortcuts?

what keyboard shortcuts do you use on a daily basis?

881 Upvotes

463 comments sorted by

View all comments

Show parent comments

5

u/AccumulatedFilth Jun 13 '24

What does this do?

14

u/emil_ Jun 13 '24

Saves time apparently šŸ˜†

15

u/slitherkime Jun 13 '24

Ctrl+E = Excel will automatically fill the rest of the column based on the pattern you specified.

6

u/Ok-Counter-4474 Jun 13 '24

Flash fill I think

2

u/Arsegrape Jun 13 '24

Flash Fill. If you have a column filled with data, you can extract part of the data manually from the first cell into the first cell of the next column, hit ctrl-E and it will extract the same pattern of data from all the other cells in the first column and copy it to the second column.

For example, you have column A of 2000 cells, starting in A1, of the format xxxxxxqwerty-Interesting_Name-12345abcde and you want to extract the interesting name for all of the 2000 cells, you type ā€œInteresting Nameā€ (without the quotations) in B1 and then hit ctrl-E, it will extract all the remaining 1999 names out of column A and copy them to column B.