Course Content

If you are facing any issue in playing video please use Firefox browser.

Course Content

FAQs

Grouping worksheets is a powerful but often-overlooked feature of Excel that offers a number of benefits, from making it easier to find information, to automating your daily reports. Create a new group in Excel by clicking on the empty cell to the right of the desired worksheet. Drag the selected sheet to this position in order to make it part of your new group.

A sheet is an application that can contain multiple worksheets. Each sheet has its own name and location in the workbook. By default, each sheet starts out with an empty data set. To insert data into the first row of a worksheet, type values in column A. To insert data into other rows, click cell A1 and start typing the name of the column that contains your values or use the arrow keys to move to different cells where you want to type text. To create columns between cells, hold down Shift while clicking on any blank cell in row 1 and then click on any blank cell in row 2 which will cause columns B through X to be created between them

When you have a sheet with data, you may need to link it to another for easier referencing. There are two methods to link a sheet in Excel: The first method is using the References utility and the second is using the Link Sheets tool. Both methods require us to specify which worksheet we want to link our sheet to. The References utility: This is the easy and most straightforward method. We select our desired sheet and click on "References" at the top of that worksheet, then we choose "Link Sheet". This will create a new sheet that links back to our original worksheet. These steps can be repeated for as many sheets as needed. The Link Sheets tool: This one requires us to select both sheets and click on "Link Sheets" at the top.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere