Breaking News

Microsoft Excel Spreadsheet Basics.

In this article, we will learn about Microsoft Excel spreadsheet basics. Where I have discussed the following topics.

  • Renaming, inserting, and deleting sheets.
  • Moving, copying, and grouping sheets.
  • Using formulas to link worksheets and workbooks.
  • Locating and maintaining links.

Excel-Spreadsheet-Basics

Renaming, inserting, and deleting sheets.

Click on the sheet.

Right, click on it.

Rename sheet.

Or.

Double click on the sheet and give the name of the sheet.

Or.

Format.

Sheet.

Rename sheet from Home Tab.

Insert the sheet.

Insert sheet

Right-click on the sheet.

Insert sheet.

Or.

Insert from Home tab.

Insert sheet.

Or.

Click on plus button beside the sheet.

 plus button

Delete the sheet.

Delete sheet

Right-click on the sheet.

Delete sheet.

Or.

Delete from Home Tab.

Delete sheet.

Note: if you delete then it will not come back (Undo).

Tab Color.

Right-click on the sheet.

Tab color.

Or.

Format from Home tab.

Tab color.

Hide and un-hide sheet.

Right-click on sheet use.

Hide or un-hide.

Or.

Format from Home tab.

Use hide or unhide.

Moving, copying, and grouping sheets.

Right click sheet and Move or Copy.

Or.

Format from Home Tab.

Move or Copy.

 Move or Copy

In the case of copy.

 navigate among the open workbooks

Or.

You can select more one sheet by pressing shift.

 by pressing shift

group sheet

If you make changes in one sheet than changes will be on every select sheet.

Even if you change the number or insert or edit the number of changes will be on every sheet.

For un-grouping sheets.

Click on any sheet.

Or.

Right-click on the sheet.

Un-group sheets.

Using formulas to link worksheets and workbooks.

If you have more than one sheet and you want to use formulas of each sheet and want to display the result on other sheets so, You have to use an equal sign like this.

 Using formulas to link worksheets and workbooks

Another way to do this.

 Using formulas to link worksheets and workbooks 2

In the above way, you have to use shift key from the keyboard when you click on any sheet or cell address.

To watch the formula.

Formula.

Shows formulas.

For creating formulas between or among the different workbooks.

So also you have to use the equal sign.

You can approach or access to the workbook by clicking view.

Switch windows.

 Switch windows

 for line break

Locating and maintaining links.

Data.

Edit Links for checking the links (destination and source).

Formulas.

 checking the links

Microsoft Excel

Spread the love

About imran

Avatar
My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Microsoft Excel Data Analysis Tools

Learning Microsoft Excel Data Analysis Tools. This article illustrates the Microsoft Excel Data Analysis Tools. …