What are the steps to rename a worksheet?

Double-click the sheet tab and type a new name in the box. Right-click the sheet tab and select Rename, then type a new name. Type the new name using the keyboard shortcut Alt+H > O > R.

How do I hide sheets in Excel?

Choose the sheet(s) you want to hide from view. Select Format from the Cells group on the Home tab. Select Hide Sheet from the Hide & Unhide menu under Visibility.

Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

What is IF Condition and How to Use it

6m 25s

What is VLOOKUP and How to Use It

5m 59s

What is VLOOKUP Exact

4m 9s

How to Use COUNT IF

4m 23s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

How to Create Pivot Table in MS Excel

11m 6s

How to Manipulate Pivot Table

8m 19s

How to Add Slicers

4m 36s

How to Perform Grouping of Pivot Table

4m 39s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

How to Use Rename Insert hide unhide sheets

MS Excel in Bangla Multiple work books

Enroll Now For Free

Discussion

Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

What is IF Condition and How to Use it

6m 25s

What is VLOOKUP and How to Use It

5m 59s

What is VLOOKUP Exact

4m 9s

How to Use COUNT IF

4m 23s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

How to Create Pivot Table in MS Excel

11m 6s

How to Manipulate Pivot Table

8m 19s

How to Add Slicers

4m 36s

How to Perform Grouping of Pivot Table

4m 39s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

FAQs

Double-click the sheet tab and type a new name in the box.
Right-click the sheet tab and select Rename, then type a new name.
Type the new name using the keyboard shortcut Alt+H > O > R.

To see the whole tab name and any other tabs, click and drag the arrow to the right. The worksheet is not visible. Unhide a worksheet by right-clicking on any visible tab and selecting Unhide from the menu. Click the sheet you want to unhide in the Unhide dialogue box, then click OK.

Choose the sheet(s) you want to hide from view.
Select Format from the Cells group on the Home tab.
Select Hide Sheet from the Hide & Unhide menu under Visibility.

Click the Insert Worksheet tab at the bottom of the screen to rapidly insert a new worksheet at the end of the existing worksheets. Select an existing worksheet and then, on the Home tab, in the Cells group, click Create, and then click Insert Sheet to insert a new worksheet in front of it.

Click Header & Footer from the Insert tab. Excel switches to the Page Layout view automatically. Select the desired page number format from the Header & Footer tab. Page numbers for the header and footers show at the top and bottom of the printed page, respectively.