+ Reply to Thread
Results 1 to 3 of 3

my problem is that Excel 2007 deletes hidden rows while deleting selected rows.

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    1

    my problem is that Excel 2007 deletes hidden rows while deleting selected rows.

    my problem is that Excel 2007 deletes hidden rows while deleting selected rows. while in other pc it does not delete hidden rows while deleting some selected row. what configuration change it required to correct it.

  2. #2
    Forum Contributor
    Join Date
    07-30-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: my problem is that Excel 2007 deletes hidden rows while deleting selected rows.

    Well yes, those cells will still be in a select if your clicking and dragging. You need to select rows using the control key to avoid the problem.

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: my problem is that Excel 2007 deletes hidden rows while deleting selected rows.

    Hi g45427

    Welcome to the forum

    One way round this is, having selected your area (including the hidden rows or columns), press Alt+; (semicolon). This will de-select any hidden cells.

    Let me know if it works for you

    Regards
    Alastair

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 06-07-2018, 04:16 PM
  2. Replies: 4
    Last Post: 06-11-2010, 03:29 PM
  3. [SOLVED] Excel 2007 : Deleting rows that end with some value
    By cde1983 in forum Excel General
    Replies: 3
    Last Post: 05-13-2010, 01:50 PM
  4. After autofilter, Excel is deleting even the hidden rows!
    By JKurz2008 in forum Excel General
    Replies: 4
    Last Post: 11-13-2009, 02:23 AM
  5. deleting hidden rows so i can print only the rows showing??????
    By jenn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 12:05 PM

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