Excel Shortcut Tips by Ditgrasi

To enhance digital productivity within the academic community of Universitas Sumatera Utara (USU), Ditgrasi shares a series of useful shortcuts accessible to everyone

Article

As an initiative to enhance digital productivity within the academic community of Universitas Sumatera Utara (USU), Ditgrasi shares a series of useful shortcuts accessible to everyone.

Here are some quick tips from Ditgrasi USU for efficient data processing:

1. Turn Data Into a Table Instantly organize data by pressing Ctrl + T. This transforms your data range into an organized and functional table.

2. Instant Charts Once data is selected, press Alt + F1 to immediately generate a standard chart from that data.

3. Auto-Fit Rows and Columns

• Auto-Fit Row Height: Use the shortcut Alt + H + O + A. Row heights will adjust automatically.
• Auto-Fit Column Width: Use the shortcut Alt + H + O + I. Column widths will adjust automatically.

4. Chart Customization To modify the chart appearance, press Ctrl + 1 to open the Format Pane. You can easily change colors and styles via the Chart Design Tab and Format Pane.

By mastering basic tools like Excel (via these quick shortcuts) and developing independent problem-solving skills, the academic community is expected to reduce work bottlenecks, save time, and produce more accurate and professional academic and administrative outputs.