Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Perform and Interpret Regression Analysis in Excel
  • How to sum a total in multiple Excel tables
  • How to Create Gantt Chart in Excel
  • How to count table columns in Excel
  • How To Create Pareto Chart in Excel

References

  • VLOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • To count total rows in a range in Excel
  • How to get first column number in range in Excel
  • How to use Excel MATCH Function
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Validations

  • Excel Data validation allow weekday only
  • Excel Data validation don’t exceed total
  • How To Create Drop-down List in Excel
  • Data validation must not exist in list
  • Excel Data validation with conditional list

Tag: Worksheets

How to reference named range different sheet in Excel

by

This tutorials shows how to reference a named range on another sheet. To achieve this, you can use the INDIRECT function with the required sheet syntax. Formula INDIRECT(“‘”&sheet&”‘!”&name) Explanation In the example shown, the formula in D6 is: =SUM(INDIRECT(“‘”&B6&”‘!”&C6)) Which returns the sum of the named range “data” on Sheet1. How this formula works The …

Continue Reading

List worksheet index numbers in Excel

by

To list the index numbers of sheets in an Excel workbook, you can enter the sheet names, then use a formula based on the SHEET and INDIRECT functions. The SHEET function then returns the current index for each sheet as listed. Formula =SHEET(INDIRECT(name&”!A1″)) Explanation In the example shown, the formula in C5 is: =SHEET(INDIRECT(B5&”!A1″)) How …

Continue Reading

List sheet names with formula in Excel

by

To list worksheets in an Excel workbook, you can use a 2-step approach: (1) define a named range called “sheetnames” with an old macro command and (2) use an INDEX formula to retrieve sheet names using the named range. Formula =GET.WORKBOOK(1)&T(NOW()) Note: because this formula relies on a macro command, you’ll need to save as a macro-enabled workbook …

Continue Reading

Freeze and Unfreeze Panes in Excel

by

If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet. Freeze Top Row To freeze the top row, execute the following steps. 1. On the View tab, in the Window group, click …

Continue Reading

Lock Cells in a Worksheet Excel

by

Lock specific areas of a worksheet You can lock cells in Excel if you want to protect cells from being edited. In this example, we will lock cell A2. Before you start: by default, all cells are locked. However, locking cells has no effect until you protect the worksheet. So when you protect a worksheet, all your cells (=worksheet) will …

Continue Reading

Group and Ungroup Worksheets in Excel

by

You can group worksheets in Excel if you want to edit multiple worksheets at the same time. Our workbook contains 3 similar worksheets (North, Mid and South) and a blank fourth worksheet. 1. To group worksheets, hold down CTRL and click the sheet tabs of the sheets you want to group. 2. Release CTRL. Now you can edit multiple worksheets at …

Continue Reading

How to Consolidate(Merge) Records From Multiple Worksheets in Excel

by

You can use Excel’s Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. Below you can find the workbooks of three districts. Before you start: if your worksheets are identical, it’s probably easier to create 3D-references (if you have one workbook) or External References (if you have multiple workbooks) to consolidate your data. As you can …

Continue Reading

View Multiple Worksheets at Once in Excel

by

If you want to view multiple Excel worksheets at the same time, execute the following steps. 1. Open a workbook. 2. On the View tab, in the Window group, click New Window. Excel opens a new window containing another view of the document. 3. On the View tab, in the Window group, click Arrange All. 4. Select …

Continue Reading

Split Worksheet Window in Excel

by

To view multiple distant parts on worksheet at once, you will need to split your worksheet. To split your worksheet (window) into an upper and lower part (pane), execute the following steps. 1. First, select a cell in column A. 2. On the View tab, in the Window group, click Split. 3. Notice the two vertical scroll …

Continue Reading

How to Delete Cells, Row and Rows in Excel

by

To quickly delete a row in Excel, select a row and use the shortcut key CTRL – (minus sign). To quickly delete multiple rows, select multiple rows and use the same shortcut. Delete Row To delete a row in Excel, execute the following steps. 1. Select a row. 2. Right click, and then click Delete. Result: Note: …

Continue Reading

How to Insert Cells, Row and Rows in Excel

by

To quickly insert a row in Excel, select a row and use the shortcut keys CTRL SHIFT +. To quickly insert multiple rows, select multiple rows and use the same shortcut. Insert Row To insert a row in Excel, execute the following steps. 1. Select a row. 2. Right click, and then click Insert. Result: Note: instead of …

Continue Reading

How to Break Worksheets into Pages in Excel

by

Insert a page break in Excel to specify where a new page will begin in the printed copy. To insert a horizontal page break, execute the following steps. 1. Select the first row of the new page. 2. On the Page Layout tab, in the Page Setup group, click Breaks. 3. Click Insert Page Break. Excel displays …

Continue Reading

Embed Excel worksheet in Word document

by

Embed an Excel worksheet in a Word document and work with Excel in Word. You can also embed files in Excel. 1. Select the Excel data. 2. Right click, and then click Copy (or press CTRL + c). 3. Open a Word document. 4. In word, on the Home tab, in the Clipboard group, click Paste. …

Continue Reading

Protect and Unprotect Worksheet in Excel

by

When you share an Excel file with other users, you may want to protect a worksheet to help prevent it from being changed. 1. Right click a worksheet tab. 2. Click Protect Sheet. 3. Enter a password. 4. Check the actions you allow the users of your worksheet to perform. 5. Click OK. Note: if you don’t check any …

Continue Reading

Things you find in Excel Status Bar

by

The quickest way to see the average, count, numerical count, minimum, maximum or sum of selected cells is by taking a look at the status bar. 1. Select a range of cells. 2. Look at the status bar at the bottom of your window to see the sum of these cells. 3. Right click the status …

Continue Reading

Select, Insert, Rename, Move, Delete Worksheets in Excel

by

How To: Select, Insert, Rename, Move, Delete A Worksheet From A Workbook A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets. Select a Worksheet in Excel When you open an Excel workbook, Excel automatically selects Sheet1 for you. The name of the worksheet appears on its sheet …

Continue Reading

Prevent invalid data entering in specific cells

by

— Set criteria in your worksheet to accept specific data. Use data validation in Excel to make sure that users enter only values that meet a set criteria into a cell. Steps to navigate to Data Validation icon in Excel Data Tab → Data Tools group → Data Validation Data Validation Example Create Data Validation Rule Input Message Error Alert …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • OR function Examples in Excel
  • Extract multiple matches into separate rows in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • Excel If, Nested If, And/Or Criteria Examples
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • DATEDIF function: Description, Usage, Syntax, Examples and Explanation
  • Convert date string to date time in Excel
  • How to get workdays between dates in Excel
  • Add workdays no weekends in Excel
  • Get work hours between dates in Excel

Grouping

  • Running count group by n size in Excel
  • Group numbers with VLOOKUP in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • Categorize text with keywords in Excel

General

  • AutoRecover file that was never saved in Excel
  • How to calculate total from percentage in Excel
  • Mark Workbook as Final in Excel
  • How to fill cell ranges with random text values in Excel
  • Check if multiple cells have same value in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning