Ctrl + D - Fill Down in One Second

@ms.tips94

138.7K followers · usually 18.9K views a post

Views

1.3M

Likes

40.6K

Comments

150

Shares

14.9K

SoundTikTok sound · original sound - ms.tips94

Promoted product

Microsoft Excel

Create and edit spreadsheets online with Microsoft Excel for the web. Easy formatting, analysis, and real-time collaboration from any device.

29 videos16 creators

Why it worked

The video provides high-utility, bite-sized educational content that solves a common pain point for office workers, making it highly shareable and saveable.

Summary

The video demonstrates a series of keyboard shortcuts for Microsoft Excel to perform common tasks like filling cells, hiding rows, and formatting tables more efficiently. Each shortcut is shown in action on a physical keyboard alongside the corresponding result in the software.

Structure

1Introduction to Excel shortcuts
2Demonstration of data manipulation shortcuts
3Demonstration of formatting and calculation shortcuts
4

Original caption

10 + Excel shorctuts that will save you time! #excel #exceltricks #exceltips

More from @ms.tips94

Product placement

Microsoft Excel: (a) it ACTS — the creator demonstrates its interface and functionality by applying various keyboard shortcuts to manipulate data and tables. Removing it would change the video entirely as it is the sole subject of the demonstration. CosmicByte: (b) it merely APPEARS — the brand name is visible on the physical keyboard used to perform the shortcuts. Removing it would not change the video.

On-screen text

Ctrl + D - Fill Down in One Second Ctrl + R - Fill Right in One Second Ctrl + 9 (Hide the Selected Rows) Ctrl + T (Beautify the Table in 1 Second) Alt + = (Automatically Sum in 1 Second) Ctrl + '+' (Insert Blank Rows) Ctrl + (Find Differences in 1 Second) Ctrl + (Jump to the End of Data) Ctrl + T (Beautify the Table in 1 Second) Ctrl + ; (Inserts the Current Date in 1 Second) Ctrl + Shift + ; (Inserts the Current Time in 1 Second) Alt + = (AutoSum 1 Second) Ctrl + Shift + L (Filter Table in 1 Second) Ctrl + Shift + (Select everthing till End of Data) Keep learning, growing.

Transcript

Ctrl + D to fill down. Ctrl + R to fill right. Ctrl + 9 hides the selected rows in one second. Alt + F1 to instantly create a chart. Alt + equals to automatically sum your numbers. Ctrl + plus inserts new rows in one second. Ctrl + backward mark to find differences. Ctrl + down arrow to jump to the end of data. Ctrl + T to quickly format your table. Ctrl + semicolon inserts the current date in one second. Ctrl + shift + semicolon inserts the current time in one second. Alt + equals to automatically sum your numbers. Ctrl + shift + L to filter your table in one second. Ctrl + shift + down arrow to select everything till end of data.