Share via

Excel ignores applied filter when using Ctrl+enter

Francisco Gil 0 Reputation points
2023-03-29T07:09:32.6933333+00:00

Today I noticed a change in the behavior of using Ctrl+Enter to enter a value in a range of filtered cells.

Up until today, when i did it, it entered the value only in the cells shown by the filter. And it did it in all cells at once.

Today I noticed that when I use Ctrl+Enter it enters the value going 1 cell at a time and it does it in every cell of the range (ignoring wether the cell is visible or hidden).

Is this change in behavior intentional or is it a bug?

If it is intentional, how can I make it work the way it used to? It slows me down a lot as of now.

Thank you for the support.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,705 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,812 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,636 Reputation points
    2023-03-30T03:01:47.6166667+00:00

    Hi @Francisco Gil

    To get this information, you may go to File > Account > Product Information.

    My Office version is 2302 (Build 16130.20202), and can not reproduce this issue.

    It's recommended to update your Office.

    • Does this issue occur with all workbooks?

    I suggest you create a new workbook, and use a simple sample to do a test.

    Then, try to select a range that applied a filter and you want to enter data in > Press CTRL+G to open the 'Go To' dialog > Click 'Special' > Select 'Visible cells only' > Enter data in formula bar, press Ctrl + Enter, please check whether the hidden cells are ignored.

    Besides, I suggest you try following steps to have a check.

    • Press Win + R > Enter excel /safe to run Excel in safe mode, open one workbook to check this issue. Safe Mode help us troubleshoot the COM Add-ins and start items.
    • Close Excel, locate to %Appdata%\Microsoft\Excel, find Excel15.xlb, please rename it and re-start Excel.
    • Perform an Online Repair for Office from Control Panel.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.