✅ Top 30 Excel Tips and Tricks in Just 30 Minutes

Introduction

This tutorial will guide you through the top 30 Excel tips and tricks, designed to enhance your efficiency and productivity in Microsoft Excel. Whether you're a beginner or looking to refine your skills, these tips will help you become a smarter Excel user in just 30 minutes.

Step 1: Convert Text Into Uppercase Without Formula

• Select the cells containing text.
• Use the keyboard shortcut Shift + F3 to toggle between uppercase, lowercase, and capitalized text.

Step 2: Create Cell Messages

• Go to the cell where you want the message.
• Use the Data Validation feature under the Data tab.
• Select "Input Message" and type your message to appear when the cell is selected.

Step 3: Center Text in Selected Cells Without Merging

• Highlight the desired cells.
• Go to the Home tab.
• Click on "Align Center" to center the text without merging.

Step 4: Display Picture on Cell Hover

• Insert a shape or image in the worksheet.
• Right-click the shape and select "Format Shape."
• Under "Size & Properties," set the image to show when hovering over the cell.

Step 5: Smart Use of Clipboard

• Use Ctrl + C to copy and Ctrl + V to paste.
• Hold Ctrl while pasting to paste values only.

Step 6: Freeze Top Rows

• Go to View tab.
• Select "Freeze Panes" and choose "Freeze Top Row."

Step 7: Freeze Top Row Without Freeze Pane

• Use the View tab and select "Freeze First Column" to create a similar effect.

Step 8: Freeze Bottom Row

• Select the row just below the one you want to freeze.
• Go to View tab and select "Freeze Panes," then "Freeze Panes."

Step 9: Print Headers on Every Page

• Go to Page Layout tab.
• Click on "Print Titles" and set the rows to repeat at the top.

Step 10: Print Only Selected Data

• Highlight the area you want to print.
• Go to File > Print and select "Print Selection."

Step 11: Hide Data

• Select the rows or columns you want to hide.
• Right-click and choose "Hide."

Step 12: Move Data Without Copy Cut Paste

• Select the data and use Shift while dragging the selection to move it.

Step 13: Transpose Data

• Copy the data you want to transpose.
• Right-click on the destination cell and choose "Paste Special" > "Transpose."

Step 14: Fill Series of Dates Up to Nth

• Enter the first date in a cell.
• Drag the fill handle down while holding Ctrl to fill a series of dates.

Step 15: Insert Blank Row After Every Row

• Select the rows where you want to insert blanks.
• Right-click and select "Insert" to add blank rows.

Step 16: Highlight Blank Cells

• Use Conditional Formatting under the Home tab.
• Set a rule to highlight blank cells.

Step 17: Delete Blank Records

• Use the filter feature to display blanks.
• Select the blank rows and delete them.

Step 18: Fill Blank Cells

• Select the range with blanks.
• Use the Fill command under the Home tab to fill with surrounding data.

Step 19: Remove Duplicates

• Select the range of data.
• Go to Data tab and click on "Remove Duplicates."

Step 20: Highlight Duplicates

• Use Conditional Formatting to create a rule to highlight duplicate values.

Step 21: Move Sheet into New Workbook

• Right-click the sheet tab.
• Choose "Move or Copy" and select a new workbook.

Step 22: Insert Bulk Sheets in Workbook

• Right-click on an existing sheet tab.
• Choose "Insert" and specify the number of sheets.

Step 23: Protect Workbook

• Go to Review tab and select "Protect Workbook."
• Set a password for added security.

Step 24: Hide Zero Values

• Use the options in Excel Options to hide zero values under Advanced settings.

Step 25: Swap Rows and Columns

• Select the data.
• Use Copy and then Paste Special > Transpose.

Step 26: Data Entry Using Form

• Select your data range.
• Go to the Data tab and click on "Form" to enable data entry.

Step 27: Find Workbook Saved Location on Computer

• Go to File > Info to see the file location.

Step 28: Copy Visible Cells Only

• Select your data, then use Alt + ; to select visible cells.
• Copy and paste as needed.

Step 29: Fast Filter Trick

• Use the filter drop-downs in column headers to quickly filter data.

Step 30: Flash Fill

• Start typing the desired result next to your data.
• Excel will automatically suggest the fill; press Enter to accept it.

Conclusion

By incorporating these 30 Excel tips and tricks into your workflow, you can greatly enhance your Excel proficiency. Try implementing these techniques in your daily tasks to save time and improve productivity. Explore further tutorials for advanced techniques and continue refining your skills in Excel.