Cookies help us deliver our services. By using our services, you agree to our use of cookies.
Learn more
Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

Sharing Tips and Tutorials for Excel

Using these add-ins can really save your time:

Kutools for Excel: It includes 300+ handy features and functions to free you from time-comsuming operations in Excel. Free Trial

Office Tab: Bringing a handy tabbed interface in your Microsoft Office. Free Trial

How-Tos for Office, Excel, Word, Outlook, Visio

Filters
List of articles in category Tips & Tricks for Excel
Title
How to rank data with multiple references in Excel?
How to compare two lists of email addresses in Excel worksheet?
How to vlookup values across multiple worksheets to return sheet names in Excel?
How to check if the first letter in a specified cell is capital in Excel?
How to calculate original price from percentage discount in Excel?
How to create appointment from Excel sheet to Outlook calendar?
How to split at any number in Excel?
How to remove border from text box in Excel?
How to click on alphabet letter to go to cell which starts with that letter in Excel?
How to keep borders while sorting in Excel?
How to quickly convert time to text or number of hours/minutes/seconds in Excel?
How to compare two columns and count differences in Excel?
How to automatically create borders if a cell has contents in Excel?
How to concatenate letter and number into one cell in Excel?
How to print every other row in Excel？
How to find the first numeric cell in an Excel range?
How to calculate item percentage of total in Excel?
How to convert all tables to ranges in active Worksheet?
How to open an excel file by using browse window?
How to filter all cells with line break or carriage return in Excel?
How to toggle between sheets by shortcut keys in Goolge sheet?
How to convert scientific notation to x10 format in Excel?
How to count strings with leading zeros in Excel?
How to find the largest letter in a range in Excel?
How to lock specific columns always visible in a sheet or across workbook?
How to calculate midpoint between two dates in Excel?
How to prevent or stop converting text string to number in Excel?
How to insert company logo into worksheet?
How to quickly convert Excel table to PDF file?
How to add tick and cross symbols into drop down list in Excel?
How to add/sum two numbers then multiply in one formula in Excel?
How to reverse domain name by notation in Excel?
How to calculate the percentage of yes and no from a list in Excel?
How to find and extract maximal / minimal string based on alphabetic order in Excel?
How to lock a sheet position for always visible in Excel Workbook?
How to never show information about blocked content in Excel?
How to use data validation to force percentage in Excel cells?
How to quickly insert space between each row in Excel?
How to remove tab color in Excel?
How to convert yyyy-mm-dd-to standard date in Excel?
How to fill sequence dates without weekends and holidays in Excel?
How to find the first duplicate value in Excel column?
How to calculate percentage of total in Excel?
How to calculate interval days/weeks/months/years between two dates in Excel?
How to average data based on weekday or weekend in Excel?
How to convert time difference between two times to number (hours/minutes/seconds) in Excel?
How to remove trailing zeros from number in Excel?
How to get current time zone and display in cell in Excel?
How to create a list of unique values from multiple worksheets in Excel?
How to create a Pivot Table from Text file in Excel?
How to quickly create mailing list template in Excel?
How to run VBA macro when open or close workbook?
How to count cells with specific text and fill/font color in Excel?
How to group data by half an hour or 15 minutes in Excel PivotTable?
How to export multiple columns into individual text files in Excel?
How to change default gridline color to others in Excel?
How to find all possible sums of two numbers in a list in Excel?
How to convert time to integer hours or minutes in Excel?
How to mass delete specific word in Excel?
How to conditional formatting based on date in Excel?
How to export all macros from one workbook to another workbook?
How to merge sheets into one and remove the duplicates in Excel?
How to get week start and end date based on a specific date in Excel?
How to display system time or date in Excel?
How to calculate the median in visible cells only in Excel？
How to calculate the percentage of year or month passed in Excel?
How to do instant filtered search as you type in a cell in Excel?
How to remove duplicates but keep blank rows in Excel?
How to use data validation to only allow SSN number entered in Excel?
How to merge two columns into one with alternating values in Excel?
How to highlight row if cell contains date in Excel?
How to numbering the cells with alphabetical letters in Excel?
How to run multiple macros from right click menu in Excel?
How to get the last business day of previous month in Excel?
How to find specific value in merged cells in Excel?
How to combine the first initial and last name into one cell in Excel?
How to keep running total in one or a single cell in Excel?
How to group data by half a year in Excel PivotTable?
How to return the previous working or business day in Excel?
How to find the position of the first lowercase letter from text strings?
How to copy cell format from one cell (one sheet) to another cell (sheet)？
How to sort numbers or texts and remove the duplicate records directly in Excel?
How to merge cells without centering the contents in Excel?
How to batch convert multiple Excel files to CSV files in Excel?
How to repeat rows a specified number of times based on another column in Excel?
How to use data validation to limit number of digits while typing in Excel?
How to validate cells to only accept IP address in Excel?
How to conditional inserting page breaks in Excel?
How to open specific Outlook folder from Excel?
How to expand or close all group rows and columns in Excel?
How to fill a default value if cell is blank in Excel?
How to import text files to Excel as separate sheets with original names in Excel?
How to round to nearest 1000s/100s/10s/1s/0.1s numbers in Excel?
How to only combine selected worksheets into one in Excel?
How to display default value based on anther cell in Excel?
How to auto display a default value while deleting value in drop-down list in Excel?
English English
en Englishaf Afrikaanssq Shqipar العربيةhy Հայերենaz Azərbaycan dilieu Euskarabe Беларуская моваbg Българскиca Catalàzh-CN 简体中文zh-TW 繁體中文hr Hrvatskics Čeština‎da Dansknl Nederlandset Eestitl Filipinofi Suomifr Françaisgl Galegoka ქართულიde Deutschel Ελληνικάht Kreyol ayisyeniw עִבְרִיתhi हिन्दीhu Magyaris Íslenskaid Bahasa Indonesiaga Gaeligeit Italianoja 日本語ko 한국어lv Latviešu valodalt Lietuvių kalbamk Македонски јазикms Bahasa Melayumt Malteseno Norsk bokmålfa فارسیpl Polskipt Portuguêsro Românăru Русскийsr Српски језикsk Slovenčinasl Slovenščinaes Españolsw Kiswahilisv Svenskath ไทยtr Türkçeuk Українськаur اردوvi Tiếng Việtcy Cymraegyi יידיש