Hello everyone! I hope you are all well and well. Today I will talk about How to solve errors in excel when you insert columns or rows. The error message box is just like this. To prevent possible loss of …
Lesson#145: How to solve errors in excel when you insert columns or rows Read more »
Hello friends, after a long time I am going to make a post for you. Here I am going to discuss the Find and Replace option in Excel. Suppose I have a worksheet filled with data. There may be some …
Lesson#144: How to find linked values in Excel from other Worksheets Read more »
I will discuss here how to print all sheets of excel files at a time. For that, we need to first set the print area for all sheets as I have done in the example. After that, we need to …
Lesson#142: How to take print of all sheets at a time Read more »
Sometimes when we work in excel we forget to save the file and we exit excel. But it is possible to recover the last unsaved file very easily if needed. Here I will show you the way. How to recover …
Lesson#138: How to recover unsaved files in Excel Read more »
We know about errors in excel. We face different types of errors when working in excel. Today I will discuss different types of errors and why it shows. What is #DIV/0! in Excel? Its meaning is division by zero. When …
OK, I am having a sheet here which calculates the age when the birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also …
Lesson#121: How to make some cells unprotected when protecting a sheet Read more »
What is an Input Box? In VBA Input Box is a function that allows you to request information from the user who can type it in a text field of a dialog box. The basic syntax of this function is: …
What is a Message Box? A message box is a special dialog box used to display a piece of information to the user. The user cannot type anything in the message box. There are usually two kinds of message boxes …
Have you seen this Conditional Formatting option – Format only cells that contain? If not then you must remember that this option makes many works of yours easier with Conditional Formatting. Then you need to go to Conditional Formatting>New Rule Then …
Lesson#118: Format only cells that contain Conditional Formatting Read more »
This post will teach you the basic concept of Name Manager. Here I will show how to name a range in excel. You can also create names for the range, reference, or formula to work in the spreadsheet easily. Above …