MS EXCEL 2016(Copy, Move Cell Range)

HELLO EVERYONE!

Let's Move on in our Excel Tutorial, In this Tutorial we will learn how to copy and move range of Excel to other location.

So Let's Start!

Starting With copying range-

To copy a range, select the first cell in your range. You will see the cell become active with a black box around it.

Now as you can see we have selected the cell C1.

And hold down the shift key and click on the last cell in the range, in our example we have clicked on the cell C9.

You will see the entire range will be highlighted.

Now to copy the cells, press CTRL+C. You will see a dotted border appear around the range of cells indicating that the cells are in the clipboard and ready to be pasted to another location in your spreadsheet.

Now you will need to select your destination. To do this, select the starting cell where you would like to paste the range. In this example, we have selected cell G1.

To Paste the range of cells press CTRL+V.

Now you can see the pasted range in the new location in your spreadsheet. In our example, G1:G9 now contains a copy of the data and formatting from the range B1:B9.

Now!

Moving The Cell Range-

To move a range, select the first cell in your range. You will see the cell become active with a green box around it. In our example, we've selected cell C1.

Now, hold down the shift key and click the last cell in the range. In our example we clicked on C9.

Now from the keyboard type CTRL+X ,To let the EXCEL know that you want to move the selected range to somewhere else. You will see a dotted border appear around the range of cells indicating that the cells are ready to be moved to another location in your spreadsheet.

Next, select your desired destination to paste the range. In our Example we have selected F1.

See!

Now you should see the range move to the new location in your spreadsheet. In this example, F1:F9 now contains the original data and formatting from the range C1:C9.


So, guys I guess I have demonstrated all the necessary topics of MS EXCEL 2016 in brief.
If You have any query plz let me know, I will try to answer them.

And this was our last topic for Excel.

So try them out personally and let me know!

Stay Updated!

MS EXCEL 2016 (HYPERLINK CREATION & DELETE)

Hello Everyone!

So, Let's move further in our tutorial of MS EXCEL. Today we are going to talk about the Hyperlink Creation in EXCEL SHEETS.

This Excel tutorial explains how to create a hyperlink to another cell in Excel 2016.

For Creating a hyperlink to another cell in your spreadsheet, right click on the cell where the hyperlink should go. Select Hyperlink from the popup menu.

Now the INSERT HYPERLINK WINDOW will appear click on the "Place In This Document" on the left. Enter the text to display.

Next enter the cell reference that the hyperlink points to.

Now when you return to the spreadsheet, you will see the hyperlink.

If you click on the hyperlink, your active cell will become sheet1;A

Now we are going to see how can we delete the create hyperlink:

Here we have a hyperlink in cell B2 which we want to remove.

To remove a hyperlink from a cell, right click on the cell that has the hyperlink and select Remove Hyperlink from the popup menu.

Now when you return to the spreadsheet, you will see the hyperlink has been removed. In this example, cell B2 appears as regular text and no longer has a hyperlink.

So this is it for Now!

I Will Keep Updating!

Stay Updated!

MS EXCEL 2016(DATA VALIDATION)

Hello Everyone!

In this tutorial of MS EXCEL we are going to talk about the Data Validation features of Excel.

This Excel tutorial explains how to set up data validation to restrict a maximum number of characters to be entered in the cell in Excel 2016.

Let's Go into this feature-

1.Select the cells that you wish to restrict to a certain number of characters.
  Select the Data tab in the toolbar at the top of the screen. Then in the Data Tools group, click on
 the Data Validation drop-down and select Data Validation.

When the Data Validation window appears, set up your criteria.

Next, click on the Error Alert tab.

Enter an Error message to appear when data entered does not conform to the validation rules.

Now if a value is entered in one of those cells that is not valid, an error message will appear:

That's it for Now!

I Will be Updating!

Stay Updated!

MS EXCEL 2016(PROTECTING THE CELLS & WORKSHEETS)

Hello Everyone!

Today we are going to have a look on the privacy feature of MS EXCEL which is protecting your  cells.
This feature was also in the other versions of MS EXCEL, so if you have explored other versions of EXCEL you would have been familiar to this feature.

Let's Take A look in brief:

To do this, select all of the rows and columns in your sheet. Right-click on then select "Format Cells" from the popup menu.

When the Format Cells window appears, select the Protection tab. Uncheck the "Locked" checkbox. Click on the OK button.

Next, select the cell(s) that you wish to protect. Right-click and then select "Format Cells" from the popup menu.

For the locking of the cells to take effect, you must also protect the worksheet. To do this, select the Review tab from the toolbar at the top of the screen. Then click on Protect Sheet button.

From the Review tab you can go for Protect Worksheets, Protect Workbook options according to your choice.

A "Protect Sheet" window will appear. You may enter a password to protect the sheet if you wish. The password is optional. Click on the OK button.

So this is it for this tutorial, You go and check out yourself for this and review your learning.

I hope this will help you out and if yes plz share your views by commenting, I will appreciate this;

That's It For Now!

I will Keep Updating!

Stay Updated!

MS EXCEL 2016(UNDERSTANDING THE FORMULA)

HELLO EVERYONE!

In This Tutorial We are going to talk about the most important feature of Excel which is Formula's

So Let's Start !

First of all we are going to understand the basics of the Formula,

Excel formulas are useful in all types of spreadsheet applications. This tutorial includes information on creating formulas and uses real-world scenarios for practice.

Formulas work almost exactly the same way in most spreadsheet programs, so you can work along with this tutorial even if you don't have Excel. These skills will work in Google Sheets, LibreOffice, OpenOffice, and many other spreadsheet programs.

One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide.

Simple Formula-

Mathematical operators

Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.


All formulas in Excel must begin with an equals sign (=). This is because the cell contains, or is equal to, the formula and the value it calculates.

Cell Reference

While you can create simple formulas in Excel manually (for example, =2+2 or =5*5), most of the time you will use cell addresses to create a formula. This is known as making a cell reference. Using cell references will ensure that your formulas are always accurate because you can change the value of referenced cells without having to rewrite the formula.

In the Above picture the Formula in Cell A3 refers to the value in cell A1 plus the value in the cell A2.

In the above picture ,the Formula calculates and displays the answer to the equation A1 plus A2.


Note-By combining a mathematical operator with cell references, you can create a variety of simple formulas in Excel. Formulas can also include a combination of cell references and numbers.


To Create A Formula-

1.Select the cell that will contain the formula.

2.Type the equals sign (=). Notice how it appears in both the cell and the formula bar.

3.Type the cell address of the cell you want to reference first in the formula.

4.Type the mathematical operator you want to use

5.Type the cell address of the cell you want to reference second in the formula. A red border will appear around the referenced cell.

6.Press Enter on your keyboard. The formula will be calculated, and the value will be displayed in the cell.

Note-If the result of a formula is too large to be displayed in a cell, it may appear as pound signs (#######) instead of a value. This means the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

Modify Values With Cell Reference-

The true advantage of cell references is that they allow you to update data in your worksheet without having to rewrite formulas.

Simply change the cell values simultaneously and you will see the instant change in the result too.

Its that simple.

Creating Formula Using Point & Click Method-

Rather than typing cell addresses manually, you can point and click on the cells you want to include in your formula. This method can save a lot of time and effort when creating formulas.

1.Select the cell that will contain the formula.

2.Type the equals sign (=).

3.Select the cell you want to reference first in the formula.

4.Type the mathematical operator you want to use.

5.Select the cell you want to reference second in the formula.

6.Press Enter on your keyboard. The formula will be calculated, and the value will be displayed in the cell.

Note-Formulas can also be copied to adjacent cells with the fill handle, which can save a lot of time and effort if you need to perform the same calculation multiple times in a worksheet.

Editing A Formula-

Sometimes you may want to modify an existing formula. In the example below, we've entered an incorrect cell address in our formula, so we'll need to correct it.

1.Select the cell containing the formula you want to edit.

2.Click the formula bar to edit the formula. You can also double-click the cell to view and edit the formula directly within the cell.

3.A border will appear around any referenced cells.

4.When you're finished, press Enter on your keyboard or select the

Enter command in the formula bar.

5.The formula will be updated, and the new value will be displayed in the cell.

That,s It For Now!

I Will Keep Updating!

Stay Updated!

MS EXCEL 2016(CELLS BASICS)

HELLO EVERYONE!

So Today in our MS EXCEL tutorial we are going to talk about the basics of Cells!

So  let's Start!

Introduction

Whenever you work with Excel, you'll enter information—or content—into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel.

Understanding cells

Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column—in other words, where a row and column meet.
Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name—or cell address—based on its column and row.



1.Cell range A1:A8

2.Cell range A1:F1

3.Cell range A1:F8

Note-If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel.

To select a cell:

To input or edit cell content, you'll first need to select the cell.

1.Click a cell to select it.

2.A border will appear around the selected cell, and the column heading and row heading will be highlighted. The cell will remain selected until you click another cell in the worksheet.

Note-You can also select cells using the arrow keys on your keyboard.

To select a cell range:

Sometimes you may want to select a larger group of cells, or a cell range.

1.Click and drag the mouse until all of the adjoining cells you want to select are highlighted.

2.Release the mouse to select the desired cell range. The cells will remain selected until you click another cell in the worksheet.

Cell content

Any information you enter into a spreadsheet will be stored in a cell. Each cell can contain different types of content, including text, formatting, formulas, and functions.

• Text: Cells can contain text, such as letters, numbers, and dates.

To delete (or clear) cell content:

1.Select the cell(s) with content you want to delete.

2.Select the Clear command on the Home tab, then click Clear Contents

3.The cell contents will be deleted.

You can also use the Delete key on your keyboard to delete content from multiple cells at once. The Backspace key will only delete content from one cell at a time.

To delete cells:

There is an important difference between deleting the content of a cell and deleting the cell itself. If you delete the entire cell, the cells below it will shift to fill in the gaps and replace the deleted cells.

1.Select the cell(s) you want to delete.

2.Select the Delete command from the Home tab on the Ribbon.

3.The cells below will shift up and fill in the gaps.

To copy and paste cell content:

Excel allows you to copy content that is already entered into your spreadsheet and paste that content to other cells, which can save you time and effort.

1.Select the cell(s) you want to copy.

2.Click the Copy command on the Home tab, or press Ctrl+C on your keyboard.

3.Select the cell(s) where you want to paste the content.

4.Click the Paste command on the Home tab, or press Ctrl+V on your keyboard.

5.The content will be pasted into the selected cells.

To access more paste options:

You can also access additional paste options, which are especially convenient when working with cells that contain formulas or formatting. Just click the drop-down arrow on the Paste command to see these options.



Instead of choosing commands from the Ribbon, you can access commands quickly by right-clicking. Simply select the cell(s) you want to format, then right-click the mouse. A drop-down menu will appear, where you'll find several commands that are also located on the Ribbon.

To cut and paste cell content:

Unlike copying and pasting, which duplicates cell content, cutting allows you to move content between cells.

1.Select the cell(s) you want to cut.

2.Right-click the mouse and select the Cut command. Alternatively, you can use the command on the Home tab, or press Ctrl+X on your keyboard.

3.Right-click the mouse and select the Paste command. Alternatively, you can use the command on the Home tab, or press Ctrl+V on your keyboard.

4.around them. dashed box. The cut cells will now have a F10:F11 the content.

5.The cut content will be removed from the original cells and pasted into the selected cells.

To drag and drop cells:

Instead of cutting, copying, and pasting, you can drag and drop cells to move their contents.

1.Select the cell(s) you want to move.

2.Hover the mouse over the border of the selected cell(s) until the mouse changes to a pointer with four arrows.

3.Click and drag the cells to the desired location.

4.Release the mouse. The cells will be dropped in the selected location.

To use the fill handle:

If you're copying cell content to adjacent cells in the same row or column, the fill handle is a good alternative to the copy and paste commands.

1.Select the cell(s) containing the content you want to use, then hover the mouse over the lower-right corner of the cell so the fill handle appears.

2.Click and drag the fill handle until all of the cells you want to fill are selected.

3.Release the mouse to fill the selected cells.

To continue a series with the fill handle:

The fill handle can also be used to continue a series. Whenever the content of a row or column follows a sequential order, like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the fill handle can guess what should come next in the series. In most cases, you will need to select multiple cells before using the fill handle to help Excel determine the series order. Let's take a look at an example:

1.Select the cell range that contains the series you want to continue.

2.Click and drag the fill handle to continue the series.

3.Release the mouse. If Excel understood the series, it will be continued in the selected cells.

So, This is it!

I will keep Updating!

Stay Updated!

MS EXCEL 2016(WORKING IN MULTIPLE WORKSHEETS)

HELLO EVERYONE!

So Let's Move on With our tutorial section!

In This Tutorial We are going to talk about The Working Environment of Multiple Worksheets simultaneously, So first of all let's go through the introduction of Multiple Worksheets-


Every workbook contains at least one worksheet by default. When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content. You can also group worksheets to quickly add information to multiple worksheets at the same time.

To Insert A New Worksheet-

1.Locate and select the New sheet button near the bottom-left corner of the Excel window.

2.A new blank worksheet will appear.

Note-By default, any new workbook you create in Excel will contain one worksheet, called Sheet1. To change the default number of worksheets, navigate to Backstage view, click Options, then choose the desired number of worksheets to include in each new workbook.


Copy The Worksheet-

If you need to duplicate the content of one worksheet to another, Excel allows you to copy an existing worksheet.

1.Right-click the worksheet you want to copy, then select Move or Copy from the worksheet menu.

2.The Move or Copy dialog box will appear. Choose where the sheet will appear in the Before sheet: field.

3.Check the box next to Create a copy, then click OK.

4.The worksheet will be copied. It will have the same title as the original worksheet, as well as a version number.

Note-You can also copy a worksheet to an entirely different workbook. You can select any workbook that is currently open from the To book: drop-down menu.

Rename A Worksheet-

1.Right-click the worksheet you want to rename, then select Rename from the worksheet menu.

2.Type the desired name for the worksheet.

3.Click anywhere outside the worksheet tab, or press Enter on your keyboard. The worksheet will be renamed.

Moving A Worksheets-

1.Click and drag the worksheet you want to move until a small black arrow appears above the desired location.

2.Release The Mouse And Your Worksheet will be Moved.

Change The Worksheet Tab Color-

1.Right-click the desired worksheet tab, and hover the mouse over Tab Color. The Color menu will appear.

2.Select The Desired Color.

3.The worksheet tab color will be changed.


Note-The worksheet tab color is considerably less noticeable when the worksheet is selected. Select another worksheet to see how the color will appear when the worksheet is not selected.


To Delete A Worksheet-

1.Right-click the worksheet you want to delete, then select Delete from the worksheet menu.

2.The worksheet will be deleted from your workbook.


Note-If you want to prevent specific worksheets from being edited or deleted, you can protect them by right-clicking the desired worksheet and selecting Protect Sheet from the worksheet menu.


Grouping And Ungrouping Worksheets-

You can work with each worksheet individually, or you can work with multiple worksheets at the same time. Worksheets can be combined together into a group. Any changes made to one worksheet in a group will be made to every worksheet in the group.

Grouping Worksheets-

1.Select the first worksheet you want to include in the worksheet group.

2.Press and hold the Ctrl key on your keyboard. Select the next worksheet you want in the group.

3.Continue to select worksheets until all of the worksheets you want to group are selected, then release the Ctrl key. The worksheets are now grouped.

Note-While worksheets are grouped, you can navigate to any worksheet within the group. Any changes made to one worksheet will appear on every worksheet in the group. However, if you select a worksheet that is not in the group, all of your worksheets will become ungrouped.


Ungrouping Worksheets-

1.Right-click a worksheet in the group, then select Ungroup Sheets from the worksheet menu.

2.The worksheets will be ungrouped. Alternatively, you can simply click any worksheet not included in the group to ungroup all worksheets.

So This Is it For Now!

Stay Updated!