New Posts
Home / Computer 4 Beginners / Microsoft Excel Spreadsheet Basics.

Microsoft Excel Spreadsheet Basics.

Microsoft Excel Spreadsheet Basics.

In this article, we will learn about Microsoft Excel spreadsheet basics. Where I have discussed 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 unhide sheet.

Right click on sheet use.

Hide or unhide.

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.

 another way of copy sheet.

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 changes will be on every sheet.

For ungrouping sheets.

Click on any sheet.

Or.

Right click on the sheet.

Ungroup 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 sheet 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 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

About imran

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

Microsoft Excel Data Analysis Tools

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