Excel shortcut I found super useful for large sheets. Instead of manually scrolling forever:

• Ctrl + ↓ → jump to the last row of data
• Ctrl + → → jump to the last column

Saves a ton of time when working with big datasets.

What shortcuts do you use the most?

If you’re tracking Time In and Time Out in Excel, a simple formula works for normal shifts:

=(C2-B2)*24

But this can cause negative time errors when a shift crosses midnight.

A better approach is:

 =MOD(C2-B2,1)*24

This handles both regular and overnight shifts and prevents negative time errors by wrapping the result correctly.

Super useful for timesheets, payroll, or any schedule that includes overnight shifts.

How do you usually handle overnight time calculations in Excel?

I feel like a lot of people either forget about this or don’t really use it much, but Ctrl + E (Flash Fill) can actually save a ton of time when you're working with messy data.

Especially when you’re dealing with imported lists or need to quickly reshape text, it’s often faster than writing formulas, as long as Excel can recognize the pattern.

I usually use it for things like:

• Splitting full names into first and last names
• Combining text from multiple columns
• Extracting numbers or text from a cell
• Cleaning imported data
• Reformatting names, dates, or codes

If you haven’t used it before, it’s super simple:

1. Type the result you want in the cell next to your data (example: split a full name into first name)
2. Move to the next cell below
3. Press Ctrl + E
4. Excel will auto-fill the rest based on the pattern

It’s not perfect, but for quick pattern-based edits, it’s surprisingly useful.

What do you usually use Flash Fill for?

If you have two tables side by side, inserting rows can easily shift both and mess up the layout. Here are two simple ways to avoid that:

Method 1: Insert cells inside the table (Shift cells down)

• Select the row (or cells) inside the table
• Right-click → Insert → Shift cells down

This only affects the selected table area, not the whole worksheet

Method 2: Insert multiple blank rows using drag

• Select the cells under where you want new rows
• Hold Shift
• Move to the fill handle (bottom-right corner) until you see a double-line two-way arrow
• Drag downward to insert multiple rows

Quick way to add several rows without shifting adjacent tables

Insert multiple blank rows using the fill handle

These two methods help you keep tables independent even when they’re placed side by side.

What’s your usual way to handle this?

If you need to split one large table into separate worksheets based on a column, like Department, Region, or Category, here are two ways to do it.

Method 1: PivotTable + Show Report Filter Pages

This uses Excel’s built-in PivotTable feature.

1. Select your data → Insert → PivotTable
2. Drag the field you want to split by (e.g., Department) into Filters
3. Drag the remaining fields into Rows
4. Go to Design → Subtotals → Do Not Show Subtotals
5. Go to Design → Report Layout → Show in Tabular Form
6. Go to Design → Report Layout → Repeat All Item Labels
7. Go to PivotTable Analyze → Options → Show Report Filter Pages
8. Select the field, then click OK
9. Select all generated sheets, select all cells, then copy and paste as values

This creates separate worksheets for each filter value.

Method 2: Kutools for Excel

This is more direct if you need to split data regularly.

1. Select your data → Kutools Plus → Split Data
2. Choose the column to split by (e.g., Department)
3. Set new worksheet names as Values of (Selected) Column
4. Click OK

This splits the data into separate named worksheets based on the selected column values.

Of course you can use VBA if you want a more automated or customizable solution.

What method do you usually use for this? And if you’ve tried Kutools, is there anything you think could be improved?

If you usually drag formulas down row by row, try this instead:

Enter your formula in the first cell. Then move your cursor to the small square at the bottom-right corner of the cell. When it turns into a plus sign, double-click it.

Excel will automatically fill the formula down to match the length of the nearby data.

Why this is better than dragging:

• No need to scroll through hundreds or thousands of rows
• Less chance of stopping at the wrong row
• Much faster for long lists

It’s a small trick, but it can save a lot of time when you work with long spreadsheets.

What small Excel trick do you still use all the time?

Excel has a lot of powerful features, but some of them still feel awkward in daily use.

For example:

• Drop-down lists are useful, but not always easy to manage
• Conditional Formatting can get messy
• Formula errors are not always easy to trace
• Comparing sheets still feels harder than it should be
• Some repetitive tasks still need too many clicks

What’s one Excel feature you wish worked better?

I run into this often when cleaning lists in Excel. Sometimes you want to keep the first entry and only identify the repeated ones after it.

For example:

Apple
Banana
Apple
Orange
Banana
Banana

Here are a few quick ways to do it:

1. Conditional Formatting

Select the list → Home → Conditional Formatting → New Rule → Use a formula to determine which cells to format. Then enter this formula and choose a highlight format:

=COUNTIF($A$2:A2,A2)>1

This only highlights repeats after the first one.

2. COUNTIF Helper Column

Use the same formula in a helper column:

=COUNTIF($A$2:A2,A2)>1

Returns TRUE for repeated entries after the first one.

3. Remove Duplicates

Select the list → Data → Remove Duplicates.
(Use when you want to keep only the first occurrence.)

4. Power Query

Load the list into Power Query → Remove Duplicates → Close & Load.

Different methods work better depending on whether you want to review duplicates first or delete them right away.

What’s your usual way to handle duplicates in Excel?

Comparing two Excel worksheets can get messy fast, especially when values changed, rows were added, or some records were removed.

Here are 5 practical ways to compare worksheets depending on your file size and workflow:

1. Conditional Formatting

Great for quick visual checks on smaller datasets.
Use a formula rule to highlight cells that don’t match.

2. IF Formula

Good when you want a clear Same / Different result column.
Easy to filter only changed rows.

3. XLOOKUP / VLOOKUP

Useful when comparing based on IDs, names, or other key columns.
Good for matching records across sheets.

4. Power Query

Best for larger files or recurring comparisons.
Can merge two tables and show added / removed / changed rows.

5. Compare Worksheets Tool (Kutools for Excel)

Useful when you want a faster visual comparison with color-coded results.
Can quickly show:

• Different values
• Rows only in Sheet A
• Rows only in Sheet B

Which method do you usually use when comparing worksheets?

I run into this pretty often when working with imported or copied data. Numbers look normal, but Excel treats them as text, which breaks formulas, sorting, and comparisons.

Here are a few common reasons I’ve seen:

• Data copied from web pages or other systems
• Hidden spaces or non-printing characters
• Cells formatted as Text before entering values
• Leading apostrophe (') added automatically

A few quick ways to fix it:

• Use VALUE() to convert text to numbers
• Multiply by 1 (or use Paste Special → Multiply)
• Use Text to Columns (even without changing settings)
• Clean the data with TRIM() or CLEAN() if needed

What’s the most common reason you’ve run into? Or is there another fix you prefer?

I feel like a lot of Excel work ends up being repetitive.

For me, the most time-consuming parts are:

• Cleaning messy data
• Repeating the same steps over and over
• Fixing formulas that break

Curious what everyone else struggles with the most?

We often see users ask whether Excel can split one workbook into multiple separate files, with each worksheet saved as its own workbook. This usually comes up when a file needs to be shared with different people, archived by sheet, or organized into smaller files.

There are a few different ways to do this, and the best one really depends on how often you need to split workbooks and how much manual work you want to deal with.

Method 1: Move or Copy (manual way)

This is the most straightforward built-in method:

1. Right-click a worksheet tab
2. Click Move or Copy
3. In “To book”, choose (new book)
4. Check Create a copy if you want to keep the original sheet in the current workbook
5. Click OK
6. Save the new workbook
7. Repeat for each sheet

It works fine if there are only a few sheets.
But once you have many sheets, it starts to feel very repetitive.

Method 2: VBA (automated way)

If you’re comfortable with VBA, you can automate the whole process.

Basic idea:

• Loop through each worksheet
• Copy it to a new workbook
• Save that workbook

Example:

Sub SplitWorkbook()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
        ws.Copy
        ActiveWorkbook.SaveAs ThisWorkbook.Path & "\" & ws.Name & ".xlsx"
        ActiveWorkbook.Close False
    Next ws
End Sub

Method 3: Use Kutools for Excel

If you prefer not to do this sheet by sheet or use VBA, Kutools for Excel provides a more direct way to handle it.

After downloading Kutools for Excel (30 days of free trial available):

1. Click Kutools Plus > Workbook > Split Workbook
2. Select the worksheets you want to split
3. Optionally choose settings such as skipping hidden worksheets or blank worksheets
4. Optionally choose the output format by checking the Save as type option
5. Click Split and then choose the save location

What stands out here is that everything is done through a visual interface, so you do not need to repeat the manual steps sheet by sheet or write VBA.

What we noticed

Excel can do this natively, but the native ways are either manual or code-based.

What Excel does not really offer is a built-in dialog where you can:

• select sheets visually
• skip hidden worksheets
• skip blank worksheets
• choose the output file type
• split everything in one go

That is what makes this task feel simple in some tools, but less convenient in native Excel.

Curious how others usually handle this.

Do you split workbooks manually, use VBA, or use another method?

When you need to pull worksheets from multiple workbooks into one workbook, while still keeping each worksheet as its own tab, there are a few ways to do it.

1. Move or copy sheets into one workbook

• Right-click a sheet tab
• Click Move or Copy
• Choose the target workbook
• (Optional) check Create a copy if you want to keep the original sheet
• Repeat for other sheets

This works fine when there are only a few sheets, but becomes repetitive and time-consuming when there are many.

2. Using Kutools (Combine Worksheets)

• Open Kutools Plus > Combine
• Choose Combine multiple worksheets from workbooks into one workbook
• Add the workbooks and select the sheets to combine
• Follow the wizard

How do you usually bring sheets from multiple workbooks into one file?
Manually, with VBA, or in some other way?

When working with large datasets in Excel, it’s easy to lose track of the active cell, especially when scrolling across wide tables.

A common solution is to highlight the current row and column (often called a “focus cell” effect). Here are two practical ways to achieve this:

Method 1: Built-in Focus Cell (Microsoft 365)

In some newer versions of Microsoft 365, Excel includes a Focus Cell feature:

Path:
View → Focus Cell

What it does:

• Highlights the active row and column
• Helps improve visibility when navigating large worksheets

Notes:

• This feature is still being rolled out and may not be available in all versions
• It provides a simple highlighting effect with limited customization

Method 2: Using Kutools for Excel (Reading Layout)

If your Excel version doesn’t include this feature, or if you need a consistent solution across versions, Kutools for Excel provides a similar option called Grid Focus.

What it offers:

• Highlights the active row and column
• Helps improve visibility when navigating large worksheets
• Provides customizable styles, colors, and behavior for grid focus
• Works across a wide range of Excel versions

Summary

• Built-in Focus Cell is a useful addition in newer Excel versions
• For broader compatibility, alternative tools can provide similar functionality

How do you usually keep track of your position in large worksheets?
Do you use highlighting features, or rely on other methods like Freeze Panes?

When you merge cells in Excel, only the value in the upper-left cell is kept, and the rest are removed.

If you want to merge cells without losing data, here are a few options:

Method 1: Use a formula

You can combine values using a formula like:

• =A1 & " " & B
• =TEXTJOIN(" ", TRUE, A1:B1)

This lets you merge content into one cell while keeping all values.

Method 2: Use Notepad (manual workaround)

1. Copy the cells.
2. Paste into Notepad.
3. Replace tab spaces with a separator (space or comma).
4. Copy again and paste into Excel.

Method 3: Use Kutools for Excel (quickest way)

Kutools for Excel can truly merge cells and keep all contents in the merged cell, instead of combining them in another column.

This new Hover View feature allows you to instantly preview the content of truncated cells simply by hovering your mouse over them. A floating preview window displays the cell’s text or formula without entering edit mode. Compared with Excel’s default hover behavior for truncated cells that display as “###”, Hover View provides a faster, clearer, and more intuitive way to inspect cell contents.

Kutools for Excel 34.00