Want to become an Excel expert in just 30 minutes? Whether you’re a student, professional, or just someone who uses Excel occasionally, learning a few smart tips can save you tons of time. In this blog, we’ve gathered 30 powerful Excel tricks that are easy to learn and super useful. From shortcuts to formulas, these tips will help you work faster and smarter. Let’s dive in and make Excel your new best friend! ✅📊
TRICK 1 – Change Excel Data to Upper Case Letters
- Select the Excel Data
- Go to the Font group in the Home tab of Excel
- In the Theme Font, you will find fonts related to capital letters
- In this way, you can automatically change the entire data from small letters to capital letters
TRICK 2 – Data Entry Information
This trick will give you information about the data you want to fill in the cell.
- Select the cells in which information is to be shown
- Go to Data tab → Data Tools → Data Validation
- Click on Input Message and type Title and Message
- Now, whoever enters the data will see the cell-related instructions
- You can remove it anytime
TRICK 3 – Centralizing Data Without Merging Cells
- Type in the cell
- Select the cells you want to merge and Right-click → Format Cells
- Click on Alignment
- Change General → Center Across Selection → OK
- Your data will look centered without merging cells
TRICK 4 – Insert Picture in Excel
If you want to insert Aadhaar or ID images into Excel:
- Go to Review Tab → Comments → New Comment
- Remove the text in the comment
- Double-click the comment border
- Click Format Comment → Colors and Lines
- Choose Fill Effects → Picture → Select Picture
- Resize if needed
- You can add multiple images like this
TRICK 5 – Paste Particular Excel Data to Another Sheet
- Click the Clipboard arrow in the Home tab
- Select data and press CTRL + C
- Open the sheet where you want to paste
- Click Paste All from Clipboard
- Your copied data will appear in the new sheet
TRICK 6 – Set Print Area
- Select the data to print
- Go to Page Layout → Print Area → Set Print Area
- Press CTRL + P to print
TRICK 7 – Hide Data in Sheet
- Select the data → Right click → Format Cells
- Go to Custom and type
;;; - The data will be hidden but still present
- To unhide, remove the semicolons
TRICK 8 – Drag Excel Data
- Select the data
- Drag from the corner to move the data to another position
TRICK 9 – Transpose Data (Vertical → Horizontal)
- Select data → CTRL + C
- Right-click where to paste → Paste Special → Transpose → OK
TRICK 10 – Create Space Between Data Rows
- Create a helper column and number the rows
- Copy and paste numbering below
- Press CTRL + SHIFT + L to apply filter
- Sort numbers Smallest to Largest
- Rows will get spaced
- Remove helper column afterward
TRICK 11 – Highlight Blank Cells
- Click one blank cell → Press F5
- Click Special → Blank → OK
- Now format and color the highlighted cells
TRICK 12 – Remove Duplicate Data
- Select data → Go to Data Tab → Remove Duplicates → OK
- Unique data will remain
TRICK 13 – Highlight Duplicate Values
- Select data → Home Tab → Conditional Formatting
- Click Duplicate Values
- Duplicates will highlight
TRICK 14 – Protect Excel Sheet
- Go to Review Tab → Protect Workbook
- Enter password
- To unprotect, repeat and enter password again
TRICK 15 – Swap Columns
- Select the column → Drag from border to move
TRICK 16 – DATA ENTRY SMART TRICK
- Select data → Press CTRL + T to create table
- Add Forms from Customize Quick Access Toolbar
- Use forms for easy data entry
TRICK 17 – Filter Selected Cell
- Select cell → Right click → Filter
TRICK 18 – Flash Fill
- Extract numbers/letters in first cell
- Press CTRL + E
- Excel auto-fills pattern
TRICK 19 – Copy Only Visible Data
- Press F5 → Special → Visible Cells Only → Copy → Paste
TRICK 20 – Create Multiple Sheets Automatically
- Create Pivot Table → Filters → Show Report Filter Pages
- Multiple sheets will be created automatically
TRICK 21 – Print All Data in One Page
- Go to Page Layout → Scale to Fit → Width = 1 Page, Height = 1 Page
TRICK 22 – Create All Borders
- Select data and press ALT + H + B + A
TRICK 23 – Freeze Rows and Columns
- Go to View → Freeze Panes
TRICK 24 – Smart Freeze with Table
- Convert data to Table (CTRL + T)
- Header row will always remain visible
TRICK 25 – Hide Sensitive Data
- Use formula:
=LEFT(C3,3)&"***"&RIGHT(C3,3)
TRICK 26 – Add +91 Before Phone Numbers
- Select data → Press CTRL + 1
- Custom Format → Type:
+91 0000000000
TRICK 27 – Select Large Range Quickly
- Click starting cell → Press F5
- Enter range reference → OK
TRICK 28 – Copy/Paste Row and Column
- For Row → CTRL + R
- For Column → CTRL + D
TRICK 29 – Colored Text Without Conditional Formatting
- Select cell → Press CTRL + 1
- Go to Custom and type:
[GREEN][>=45];[RED]
