Excel Magic Trick 1060: Double Click To Copy Formulas Down Column, 5 Examples (Some Empty Cells)

Показать описание

See how to use the Mouse (Cross Hair or Angry Rabbit) and the "Fill Handle" to copy a formula down a column quickly in these five situations:
1. Formula is copied with data/formulas to the Left
2. Formula is copied with data/formulas to the Right
3. Formula is copied with data/formulas Below
4. There is a complete data set with Field Names, but the column to the Left has some empty cells
5. There is a complete data set with Field Names, but the column to the Left is completely empty!!

Рекомендации по теме

Комментарии

Excel Magic Trick 1060: Double Click To Copy Formulas Down Column, 5 Examples (Some Empty Cells)

Cool Excel 2013 Copy Formula With Empty Column Next To it!!

excelisfun

Amazing discovery ! Especially the one with a whole empty column !

ExcelStrategy

alright but is there a keyboard shortcut instead of double-clicking the small box in the corner?

saadalshehri

Thanks for the video.
I believe, copying formula with empty column next to it, works like this since 2010 version of Excel :)

pmsocho

I really enjoy your videos and I reference back to them often! I have a specific question, but this may not be the place to ask.
I am looking to make a macro the can add a random number column to the start of a data set. and I was to send down the formula based on the variable size of the data. when I recorded the macro the VBA only registered the 25 rows in my test file, my live data could be between 100, and 80, 000 rows. Do you have a video that addresses this, or can someone comment to help? I thought the action of double clicking the black cross would have recorded.

Thank you.

albert

I am trying to do this with a percentage cell in another part of the sheet. Excel seems to look for the next range of numbers and I get value all over the sheet

Ozipeter

Is there a keyboard shortcut that does the same thing as double clicking to expand the vLookup down?

MrBobbyBrown

Hi Mike do you have a Lottery Number Generator & Result Checker?

MrDavidcaldwell

thanx for the video
it's amazing video

ekosastra

Nice, I think it uses the Current Region code of VBA to calculate the number of rows. But great development!

Maartenmarsje

Sometimes I double click and nothing happens why ?

samkab

Excel Magic Trick 1060: Double Click To Copy Formulas Down Column, 5 Examples (Some Empty Cells)

Excel Magic Trick 1060: Double Click To Copy Formulas Down Column, 5 Examples (Some Empty Cells)

Excel Magic Trick 1060 Double Click To Copy Formulas Down Column, 5 Examples Some Empty Cells

Excel Magic Trick 1061: Copy Formulas Quickly With Name Box and Shift Key (Horizontal or Vertical)

Excel Magic Trick 1059: Conditionally Format Top 5 Numbers That Are Also Greater Than 65

Excel Magic Trick 1062: SUMIFS: Year Over Year Sales Calculations From Transactional Data Set

Excel Magic Trick 1240: Double Click To Copy Formula Down When Formula Is Not Next To Data Set

Excel Magic Trick 1032: Add Record Count Column To Filtered Table (Fix SUBTOTAL Filter bug)

Excel Magic Trick 1064: Copy Formulas Even More Quickly With F5 Key and Shift + Enter

Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable

Excel Magic Trick 1061 Copy Formulas Quickly With Name Box and Shift Key Horizontal or Vertical

Excel Magic Trick 1067: Displaying Fractional Percent in Excel like: 33 1/3 % or 3/10%

Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR

Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month

Excel Magic Trick 1018 CEILING Function To Round Up To The Nearest $1000 Increment (nowtelugu.com)

Excel Magic Trick 1028: Create Hyperlinks to Duplicate Text Titles In Column A On Different Sheet

Excel Magic Trick 1241: Keyboard To Copy Formula Next To Data Set Down A Column

Excel Magic Trick 1064 Copy Formulas Even More Quickly With F5 Key and Shift + Enter (nowtelugu.com)

Excel Magic Trick 1020 What Lens Do You Look Through When Solving Excel Problems (nowtelugu.com)

Excel Magic Trick 1057: Calculate Hours Worked From Text Time Values, Including Night Shift

Excel Magic Trick 1049 Copy Page Setup From One Sheet To Another (nowtelugu.com)

Excel Magic Trick 1021: Implicit Intersection or #VALUE Error: No Ctrl + Shift + Enter

Excel Magic Trick 1066: PivotTable: Month Over Month Sales Calculations From Transactional Data Set

MS Excel - Double Click to Copy Formula to Bottom

Excel Magic Trick 1029 DON'T Use IFERROR, Use IF and Logical Test If Possible (nowtelugu.com)