Ctrl + Shift + 1

@dataanalytics.07

139.0K followers · usually 3.6K views a post

Views

19.1K

Likes

813

Comments

2

Shares

145

SoundTikTok sound · original sound - dataanalytics.07

View velocity

+3.8K views over 9.0d · ~428/day · 8 observations

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.

26 videos13 creators

Why it worked

The video provides a quick and practical demonstration of useful Excel shortcuts, making it highly shareable for users looking to improve their spreadsheet skills.

Summary

The video demonstrates how to quickly format data in Microsoft Excel using keyboard shortcuts. It shows how to apply currency, percentage, date, and time formats to columns of numbers.

Structure

1Select number column
2Apply currency format
3Select percentage column
4Apply percentage format
5

Original caption

Excel formatting in seconds 🤯 #exceltips #spreadsheets #office

More from @dataanalytics.07

Product placement

Microsoft Excel ACTS - its interface is operated to format data, changing numbers into currency, percentages, dates, and times. Removing it would change what happens in the video.

On-screen text

Ctrl + Shift + 1 Ctrl + Shift + $ Ctrl + Shift + % Ctrl + Shift + # Ctrl + Shift + @ Quickly formatting data Number Currency Percentage Date Time 100 200 400 600 300 800 500 1000 600 1200 700 1400 800 1600 900 1800 1000 2000 0.6 0.62 0.64 0.66 0.68 0.7 0.72 0.74 0.76 0.78 46248 46249 46250 46251 46252 46253 46254 46255 46256 46257 0.375 0.5 0.0625 0.625 0.875 0 0.125 0.25 100.00 200.00 400.00 600.00 300.00 800.00 500.00 1000.00 600.00 1200.00 700.00 1400.00 800.00 1600.00 900.00 1800.00 1000.00 2000.00 60% 62% 64% 66% 68% 70% 72% 74% 76% 78% 14-Aug-26 15-Aug-26 16-Aug-26 17-Aug-26 18-Aug-26 19-Aug-26 20-Aug-26 21-Aug-26 22-Aug-26 23-Aug-26 09:00 10:30 12:00 01:30 15:00 18:00 21:00 00:00 03:00 06:00

Transcript

Ctrl + Shift + $ Ctrl + Shift + % Ctrl + Shift + # Ctrl + Shift + @