Skip to content
Excel Unlocked

Let's Unlock the Power of Excel for You

  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us
Excel Unlocked
  • Functions
  • Tips and Tricks
  • Charts
  • VBA and Macro
  • About Us

Tips and Tricks

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

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
Add Macro to Quick Access Toolbar or Ribbon

Add Macro to Quick Access Toolbar and Ribbon

In the previous blogs, we had learned how one can start automation in excel by recording a macro and then running it. We had also… Read Article
Insert a Line Break in Excel

Insert Line Break in Excel – Add More Line in Cell

What happens when you type something in a Microsoft Office Word document and press the ‘Enter’ key? The cursor would go on the next and… Read Article
Record a Macro in Excel

Start Automation – Record A Macro in Excel

Many a time, while working with an Excel worksheet, you may do one or more tasks repeatedly each time you open a new worksheet. For… Read Article
Get Quarter from Dates in Excel

Convert Date To Quarter in Excel

Do you know how to convert a date or a month into the quarter in Excel? In this blog, unlock multiple ways to convert the… Read Article
Remove Spaces Between Words in Excel

Remove Spaces Between Words and Numbers in Excel

Many a time, when you copy and paste some data directly from an external source such as a web page or a .txt file into… Read Article
Watch Window in Excel

Watch Window in Excel – An Unrecognized Feature

If you are a regular excel user, it is probable that have you work on large excel workbooks having many worksheets with hundreds of records.… Read Article
Excel Tables - A Hidden Feature

How to Make A Table In Excel – A Hidden Functionality

A Table in Excel is an Amazing feature provided in Microsoft Excel. It has a bunch of features that make tasks in Excel very easy.… Read Article
Separate Names from Email Addresses in Excel

How to Get Name from Email Address in Excel

Many a time, you may have a list of email addresses in an Excel worksheet and you may wish to separate or get the name… Read Article
Quickly Select Columns with Blank Cells Between

Quickly Select Columns with Blank Cells in Between

Do you how to quickly select the columns with blank cells in between? In this blog, we would unlock the technique to quickly select the… Read Article
Show Negative Numbers in Bracket and in Red Color

Show Negative Numbers in Bracket and in Red Color

Have you ever wondered how can we show the negative numbers into the bracket and in red color? You can show the negative numbers into… Read Article
Older posts
Newer posts
← Previous Page1 … Page3 Page4 Page5 … Page7 Next →
Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

Recent Comments

  • Nilesh Patel on Excel DATEDIF Function – Find Difference Between Dates
  • daniel on Excel XNPV Function – NPV With Irregular Cash Flows
  • wout on How to Insert Picture or Image in Excel Comment

Archives

Categories

  • Charts (69)
  • Functions (281)
  • Tips and Tricks (73)
  • VBA and Macro (73)
  • Home
  • Privacy Policy
  • Terms of Use
  • About Us
  • Contact Us
  • Site Map
Copyright @ExcelUnlocked.com 2025