To list the index numbers of sheets in an Excel workbook, you can enter the … Read More
List sheet names with formula in Excel
To list worksheets in an Excel workbook, you can use a 2-step approach: (1) define … Read More
How to reference named range different sheet in Excel
This tutorials shows how to reference a named range on another sheet.
To achieve this, … Read More
Embed Excel worksheet in Word document
Embed an Excel worksheet in a Word document and work with Excel in Word. You … Read More
Protect and Unprotect Worksheet in Excel
When you share an Excel file with other users, you may want to protect a … Read More
How to Delete Cells, Row and Rows in Excel
To quickly delete a row in Excel, select a row and use the shortcut key… Read More
How to Insert Cells, Row and Rows in Excel
To quickly insert a row in Excel, select a row and use the shortcut keys … Read More
How to Break Worksheets into Pages in Excel
Insert a page break in Excel to specify where a new page will begin in … Read More
Group and Ungroup Worksheets in Excel
You can group worksheets in Excel if you want to edit multiple worksheets at the … Read More
View Multiple Worksheets at Once in Excel
If you want to view multiple Excel worksheets at the same time, execute the following … Read More
How to Consolidate(Merge) Records From Multiple Worksheets in Excel
You can use Excel’s Consolidate feature to consolidate your worksheets (located in one workbook or … Read More
Freeze and Unfreeze Panes in Excel
If you have a large table of data in Excel, it can be useful to … Read More
Split Worksheet Window in Excel
To view multiple distant parts on worksheet at once, you will need to split your … Read More
Things you find in Excel Status Bar
The quickest way to see the average, count, numerical count, minimum, maximum or sum of … Read More
Lock Cells in a Worksheet Excel
- Lock specific areas of a worksheet
You can lock cells in Excel if you want … Read More
Prevent invalid data entering in specific cells
— Set criteria in your worksheet to accept specific data.
Use data validation in Excel … Read More
Select, Insert, Rename, Move, Delete Worksheets in Excel
How To: Select, Insert, Rename, Move, Delete A Worksheet From A Workbook
A worksheet is … Read More