Category Archives: Excel 365 English

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet?

Microsoft Excel Blog Banner

Many times, I believe, when we are selecting multiple Cells or Ranges of Cells in a Microsoft Excel Spreadsheet, we accidentally select on or more that we didn’t mean to do. What did we usually do? We started all over again, wishing that we would be more accurate and luckier this time. Well, we do not have to worry any more. We can Deselect any Cells within the Selected Range by simply pressing the Ctrl Key button on our keyboard. We just press the Ctrl Key, and click, or click and drag to deselect Cells or Ranges of Cells. Just on keep on reading the post below to find out, how it can be done.

How To Deselect Multiple Selections in a Microsoft Excel Spreadsheet

Read the rest of this entry

How To Use The XLOOKUP Function in a Microsoft Excel Spreadsheet?

Microsoft Excel Blog Banner

There are many Functions available in Microsoft Excel. There are Functions, combination of Functions, more than what we can think of. Remember when we were looking for a Function to lookup and retrieve data within a Table, and we used to use the VLOOKUP function. VLOOKUP Function that I described in a previous post of mine and you can find here. Well now the successor of the VLOOKUP Function is the XLOOKUP Function. It is named like this because it can search bother vertically and horizontally. It allows us to search for an item in a Range or Table and return the matching result.

The XLOOKUP Function has Five Arguments, where the first three are required and the last two are optional. The first three necessary arguments are the following:

  • lookup_value: What we are looking for.
  • lookup_array: Where to find it.
  • return_array: What to return

How To Use The XLOOKUP Function in a Microsoft Excel Spreadsheet

Read the rest of this entry

How To Use The VLOOKUP Function in a Microsoft Excel Spreadsheet?

Microsoft Excel Blog Banner

There are many Functions available in Microsoft Excel. There are Functions, combination of Functions, more than what we can think of. When we are looking for a Function to lookup and retrieve data within a Table, this is where the VLOOKUP function appears. The V, stands for vertical, meaning that the Data in the Table must be arranged vertically, with Data in Rows. We use the VLOOKUP Functions when we are in need to find things in a Table or a Range by Row. We can use the VLOOKUP Function when we have a well- organized Table, with all the information arranged Vertically and a Column on the left, which we can use to match a Row. To find out more and to learn how to use the VLOOKUP Function in an Excel Spreadsheet, just keep on reading the post below.

How To Use The VLOOKUP Function in a Microsoft Excel Spreadsheet

Read the rest of this entry

How To Create A Data Validation Rule in Microsoft Excel?

Microsoft Excel Blog Banner

Data Validation is a feature in Microsoft Excel that is used to control what a user can or cannot enter in a Cell of the Spreadsheet. It means that we can check the accuracy and quality of the Source Data before using it, importing it or otherwise processing the Data. We can use different types of Validation depending on what we want to accomplish. In this post, I have created something simple enough for everyone to understand what Data Validation is about.

How To Create A Data Validation Rule in Microsoft Excel

Read the rest of this entry

How To Use The Goal Seek Feature in Microsoft Excel?

Microsoft Excel Blog Banner

Sometimes we know the result we want from a Formula and we need to find out the input value that produces the Formula result, then we must use the Goal Seek feature in Microsoft Excel. The Goal Seek feature calculates a value by performing What-If Analysis on a given set of Values. The Goal Seek feature lets us adjust a Value that is used in a Formula so we can achieve a specific Goal. It allows us to see how one Data item in a Formula impacts on another. It is a very useful feature, because we can adjust one Cell Entry to see the Result that we needed. To find out how to use the Goal Seek Feature in Microsoft Excel just keep on reading the post below.

Keep in mind, that for the Goal Seek feature, we need to have the following:

  • Formula Cell
  • Target/Desired Value
  • The Cell To Change In Order To Achieve The Target

How To Use The Goal Seek Feature in Microsoft Excel

Read the rest of this entry

How To Maximize Printing Options in An Excel Spreadsheet?

When we look on a Spreadsheet in Excel on a Monitor, everything looks just perfect. Sometimes though, when we want to Print it, if we are not careful we will be ending up wasting a lot of Paper and we will not have a clue what has been Printed. Data here, Columns there, Rows everywhere. Everything will just be Printed out of order. This is where the Backstage Printing Options comes along, where we can adjust the Paper Size and even the Orientation of the Page. To find out how to Maximize the Printing Options in an Excel Spreadsheet, just keep on reading the post below.

How To Maximize Printing Options in Excel

Read the rest of this entry

How To Insert A Watermark in an Excel Spreadsheet?

Watermark is an image or text that appears usually behind the main Document or Spreadsheet. For example, Watermarks usually displays the status of the Document or Spreadsheet such as “Confidential”, “Copyright” among others. Watermark can either be text or even images, such as our logo or other pictures. Inserting a Watermark is an easy procedure and has been describe in a previous post of mine, but inserting a Watermark in an Excel Spreadsheet is a bit tricky and will be described in the post below, so just keep on reading.

How To Insert A Watermark on a Spreadsheet in Excel

Read the rest of this entry

How To Insert A Sheet Background in An Excel Workbook?

In Microsoft Excel, we can set a Picture as a Sheet Background. This Sheet Background will be used only for display purposes and cannot be printed. Because a Sheet Background cannot be printed, therefore cannot be used as a Watermark. In a next post of mine I will describe how to insert a Watermark in an Excel Spreadsheet. For now, I will be describing How To Insert A Sheet Background in An Excel Spreadsheet. Just keep on reading the post below.

How To Insert A Background on a Spreadsheet in Excel

Read the rest of this entry

How To Modify The Calculation Options in a Microsoft Excel Workbook?

In Microsoft Excel, all the currently open Workbooks, use the same of Calculation no matter in which mode we have saved them. For to use different Calculation Modes, we must use different procedures to work with Workbooks that use different Calculation Modes. By default, the mode set to recalculate in an Excel Workbook is automatically. If we make any changes in a cell that is referenced in a Formula, Excel will automatically recalculate the Formula so that it returns a correct result based on the changes. Keep in mind, that if the Formula that it recalculates and is used as a Cell Reference in other Formulas, all the other Formulas that is dependent on the recalculated Formula will also be recalculated. To find out how to Modify the Calculation Options in an Excel Workbook just keep reading the post below.

How To Modify Calculation Options in Excel

Read the rest of this entry

%d bloggers like this: