Skip to content
Excel Unlocked

Let’s Unlock the Power of Excel for You

  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us
Excel Unlocked
  • Home
  • Functions
  • Tips and Tricks
  • Charts
  • About Us

Tips and Tricks

This category is dedicated to covering all the tips and tricks of Excel.

Print All or Multiple Worksheets in Excel

How to Print All or Multiple Worksheets in Excel

When you are working with a large workbook having multiple worksheets in it, one concern that comes in mind is about printing all or selected… Read Article
Send Email From Excel Automatically

How to Send Email From Excel Automatically

Have you ever wondered that we can even send an email from excel using an excel formula by just a simple mouse click? In this… Read Article
Convert Numbers to Text in Excel

Change And Convert Number To Text in Excel

If you are a regular excel user with a large number of data in it, a day may come when you wish to change and… Read Article
Hide Zero Value in Excel

Multiple Ways to Hide Zero Value in Excel

Many a time, you may want to hide the zero value in a cell in Excel. In this blog, we would unlock the technique to… Read Article
Convert Decimal Number to Fraction

Convert Decimal To Fraction in Excel

Do you know how to convert a decimal number to a fraction in Excel? There are two ways using which you can display decimal numbers… Read Article
Count Number of Characters in Cell in Excel

Count Number of Characters in Cell or Range of Cells

Have you ever wondered how to count the number of characters, string, or words in a cell or multiple cells in Excel? In this blog,… Read Article
Insert Degree Symbol in Excel

Multiple Ways to Insert Degree Symbol in Excel

Have you ever wondered how to insert a degree symbol in an excel cell? If not, then you are in a right blog.… Read Article
Insert Tick and Cross Mark Symbol in Excel

Insert Tick Mark or Cross Mark in Excel

In this blog, we would learn multiple ways to insert a checkmark (tick mark) and cross mark symbol in excel. However, before learning it, it… Read Article
Find and Replace Cell Color in Excel

Find and Replace Cell Color in Excel

In this amazing tutorial, we would unlock the technique to find and replace the cell color in Excel. Let us take a small example to… Read Article
Using Wildcard Characters in Excel

Advanced Search Using Wildcard Characters in Excel

In this blog, we would learn what are the wildcard characters and how can you use the wildcard characters in Excel to filter your data… Read Article
Split Cells Diagonally in Excel

How to Split Cell Diagonally in Excel

Have you ever wondered how to split a cell diagonally in Excel? By split cell, it means, drawing a line from the bottom left corner… Read Article
Four Ways to Run A Macro in Excel

Four Ways to Run A Macro in Excel

In our previous blog, we had learned to create a macro by recording it. In this blog, we would learn multiple ways to run a… Read Article
Post navigation
Older posts
Newer posts
← Previous Page1 Page2 Page3 … Page5 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 298 other subscribers

Recent Comments

  • Parth Gupta on Show Negative Numbers in Bracket and in Red Color
  • Shailesh on Sparkline in Excel – Insert, Edit and Delete
  • Dhrunil Bhatt on Stack Data from One Column into Multiple Columns

Archives

Categories

  • Charts (67)
  • Functions (226)
  • Tips and Tricks (59)
  • Uncategorized (2)

Mission

ExcelUnlocked is dedicated to unlocking the power of Excel for professionals, students and all others who use Excel in their day to day activity.

  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ Excelunlocked.com 2022