Uploaded December 2025 | Updated September 2026, 2 weeks ago
Welcome to dptutorials, where you learn simple and powerful Excel tricks that save time and make your sheets look professional. In today’s video, you will discover a surprising Excel shortcut: converting text to uppercase without using any formula. That’s right — no UPPER(), no retyping, and no data transformation. You can convert your text into all caps instantly by simply applying the Copperplate Gothic font.
When you type lowercase text in Excel, selecting the cells and changing the font to Copperplate automatically displays the content in uppercase. The actual text inside the cell doesn’t change, which means your formulas, lookups, and references remain untouched. Only the appearance changes, making this perfect for headings, labels, dashboards, reports, and visually clean layouts.
This trick is extremely useful for users who want quick formatting without affecting the original data. You can apply it to entire tables or just specific columns where uppercase formatting looks better. If you enjoy discovering hidden Excel tricks that make your work faster and cleaner, make sure to subscribe to dptutorials for more easy, practical tips and productivity shortcuts.
#ExcelShorts #ExcelTips #ExcelFormatting
Welcome to dptutorials, where you learn simple and powerful Excel tricks that save time and make your sheets look professional. In today’s video, you will discover a surprising Excel shortcut: converting text to uppercase without using any formula. That’s right — no UPPER(), no retyping, and no data transformation. You can convert your text into all caps instantly by simply applying the Copperplate Gothic font.
When you type lowercase text in Excel, selecting the cells and changing the font to Copperplate automatically displays the content in uppercase. The actual text inside the cell doesn’t change, which means your formulas, lookups, and references remain untouched. Only the appearance changes, making this perfect for headings, labels, dashboards, reports, and visually clean layouts.
This trick is extremely useful for users who want quick formatting without affecting the original data. You can apply it to entire tables or just specific columns where uppercase formatting looks better. If you enjoy discovering hidden Excel tricks that make your work faster and cleaner, make sure to subscribe to dptutorials for more easy, practical tips and productivity shortcuts.
#ExcelShorts #ExcelTips #ExcelFormatting
