Logo Inserting Symbols in Excel
EXCEL TRICKS

How to Insert Symbol in Excel Numbers?

Have you ever faced the challenge while using special character symbols in number formatting or any customized number formatting? It is an easy method to insert any symbol in numbers i.e Delta Symbol or Special Character Symbols in Excel Number Formatting.  You may easily do this by following below steps: …

Read More
Delta Symbol
EXCEL TRICKS
1

Usage of Delta Symbol in Excel – Complete Guide

The Greek Capital Alphabet letter Delta (▲) and  is commonly discussed topic in Excel. This is being used for various purposes i.e. changes in quantity, insert the symbol in excel etc. Though inserting Delta (▲) is very easy in any of the MS Office Applications i.e. Excel, Word, Power Point …

Read More
Logo Inserting Symbols in Excel
EXCEL TRICKS

How to Insert Symbol in Excel

I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may insert any kind of special characters in Excel via using this method. So lets start Excel Symbol Dialog Box Here I …

Read More
42.5 Remove Duplicates
EXCEL TRICKS

Remove Duplicates in Single Column

When you see duplicate data in single column, you may follow this article to remove these duplicates with few clicks. If you see below screenshot, I have duplicates available in my Column A which are highlighted in yellow: Highlight/Select the Column A, similar to shown in below screenshot: Go To …

Read More
EXCEL TRICKS

Few Simple Excel Tips – Excel Learner Should Know

1. Change Direction When You Press Enter Whenever you press enter, you must be thinking why my cell selection shifts down. Why it can’t go UP, Down, Left. Surprised This is very simple. Do you want to change the direction? So let’s do it Click on below highlighted button “File”: …

Read More
Excel Tricks
EXCEL TRICKS

Impress your Clients by Hiding these Simple Features

While preparing many projects, my clients always want me to make professional, good looking dashboards. So I hide few things like Gridlines, Column & Row headings and Formula Bar. This can give WOW experience to your bosses, clients because after hiding these features, you excel sheet looks like a software …

Read More
EXCEL TRICKS

Lock Cells to avoid editing, Hide Formulas

Sometimes you create amazing projects, dashboards however people can make mistakes and edit the calculations, formats what you have made. Still you can protect the sheets, workbooks and prevent users to make any editing via “Protect Workbook” Option However you need an additional feature along with the “Protect Sheet” to …

Read More
EXCEL TRICKS

Protect Sheets, Share Workbook, Protect Workbook

Creating beautiful and professional dashboards, projects always lead you to success however there are places when you wanted to protect your dashboards, sheets, cells to prevent users to make unnecessary editing because it can change calculations, sheets and sometimes, finish the essence of the project So here we are talking …

Read More
Excel Tricks
EXCEL TRICKS

Hide Excel Sheet/Tab – Complete Guide

When I was creating an excel dashboard, there were multiple sheets which I used for calculation purpose and never wanted anybody to make any changes on it. So I found very awesome feature to hide an excel tab: Though there are multiple ways to hide the excel sheet tab: 1. …

Read More
EXCEL TRICKS

TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use this amazing excel formula to remove these spaces: Excel Formula: =Trim(text)   Below is an …

Read More
EXCEL TRICKS

How to Create dropdown List in Excel

Excel is an awesome Microsoft utility which most of the professionals are using for their day to day office use as Excel is blood of our daily office lives. Hence it has lots of amazing feature which can ease our data gathering requirements in excel. So here will be talking …

Read More

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn