The video provides a quick and useful Excel tip that many users may not be aware of, making it highly shareable and informative.
Summary
The video demonstrates a quick way to format tables in Microsoft Excel. It shows how to select data, use a keyboard shortcut to open the AutoFormat menu, and then select a desired format to apply to the table.
Structure
1Show coworker's basic table formatting
2Show the improved formatting method
3Press Ctrl+A to select all
4Press Alt+O+A to open AutoFormat
Original caption
Stop wasting time manually formatting Excel tables. 🛑 This Excel hack can do it for you. 🤓 #excel #corporate
More from @miss.excel
More breakout videos from this creator.
5
Pick a format
6Show the final formatted table
Product placement
Microsoft Excel: it is used to create and format a table of data. It ACTS. Removing it would change what happens in the video.
On-screen text
I SAW MY
COWORKER DO
THIS
SO I SHOWED HIM
THIS
PRESS
CTRL + A
PRESS
ALT + O + A
PICK A FORMAT
DID YOU KNOW
THIS?