How to select every alternate row in excel Many times we have required to select every alternate row for highlight or delete it. even sometimes we download data from where row after…
Tag: excel tips
How to Solve #DIV/0! Error in Excel?
How To Solve Error #DIV/0! in Excel? If you have been working in Mircosoft Excel then I am sure you have many face error #DIV/0! error. In this tutorial, I will show…
How to Get Day Name from Date in Excel
Sometimes while we are working with Dates in Excel you want to know the day on that date is Tuesday or Friday. This could be mainly required when we are planning for…
How to Quick Copy Worksheet in Excel
How to Quick Copy a Worksheet in Excel During work on a Microsoft Excel lot of times we need to make a copy of a worksheet in Excel. Maybe we want to…
How to Sum alternative Rows or Column
From this article, you will learn how to sum alternative rows/ columns in Excel with help of SUMIF Function. Excel has various functions, including functions to calculate the inverse cosine of a…
How to Quick Repeat Action In Excel
Hey, Have you ever required to repeat the same action multiple times in excel? I have often required to Repeat Action during my routine work. Excel has some inbuilt functions which help…
How to Print Top Row on Every Page in Excel
When we work with data in Excel, we all know that there is a feature that allow us to freeze the top row or sheet or first column of the the…
How to Stop Excel to make auto hyperlink
How to Stop Excel to make auto hyperlink?? Microsoft excel by default convert text into a hyperlink if your data match with url or email address format.This is actually unwanted things for…
How to use LEFT Function in Excel
When to Use Left Function ? When you want to Extract Specific Number of Character from Cell or String from the First Character of Left Side. How to Use Left Function ?…
Top 5 Method To Convert Negative Number Into Positive Number
Have you ever need to convert Positive number from Negative in Excel ?? If there is one or Two Number need to convert then we manually write same number without negative sign….