+ Reply to Thread
Results 1 to 2 of 2

How to insert a row by hitting tab with filter applied in a table

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    USA
    MS-Off Ver
    Excel 2005
    Posts
    1

    How to insert a row by hitting tab with filter applied in a table

    I am using MS Excel 2007. My problem is with inserting rows in a table when a filter is applied.

    I created a table in excel 2007 with no Excel 2007 specific table styles assigned. I applied an auto filter. The table automatically adds a new row when I hit the tab key irrespective of any filter applied. However, when I add a "Total Row" to the table, and apply a filter, I get the following message when I try to add a new row by hitting the TAB key "Cannot shift cells in a filtered range or table".

    This would not be a problem only if I did not have other tables that I personally created returning this error message. Now even the new tables from scratch return this error unless I remove "Total row". Without the "Total row", the table acts as expected. I can add rows by hitting the tab button whether or not there is a filter applied.

    I already checked if there was some kind of protection, hidden cells, or some formatting that would generate such strange behavior. I did not have this issue before. Can anyone assist me fixing this annoying issue?

  2. #2
    Forum Expert
    Join Date
    08-27-2008
    Location
    England
    MS-Off Ver
    2010
    Posts
    2,561

    Re: How to insert a row by hitting tab with filter applied in a table

    You must either remove the filter (seems more sensible) or the total.
    CC


    If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1