+ Reply to Thread
Results 1 to 3 of 3

Deleted extra rows, now I can't enter in that area?

  1. #1
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Deleted extra rows, now I can't enter in that area?

    I had the "this spreadsheet has 1 million empty rows, that's why your file is huge" issue today, and deleted the extra million blank rows to reduce the file size, but noticed that excel appears to have permanently deleted the rows....see screenshot.


    I can right click and insert rows that way but this is not a viable. I'm sure it's an easy fix but I've never seen it before


    Thanks!
    Attached Images Attached Images
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Deleted extra rows, now I can't enter in that area?

    Did you try to save the file and then reopen it?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Deleted extra rows, now I can't enter in that area?

    Figured it out. Row height 0, but not hidden.

+ 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. [SOLVED] Help: How to remove unwanted extra area
    By zaidu87 in forum Excel General
    Replies: 6
    Last Post: 11-17-2012, 05:42 AM
  2. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  3. [SOLVED] Prevent data being deleted after Enter & Save
    By Unca Wook in forum Excel General
    Replies: 3
    Last Post: 08-19-2012, 07:57 PM
  4. Replies: 0
    Last Post: 11-13-2007, 04:17 AM
  5. Extra Row in Defined Print Area
    By Harry Gordon in forum Excel General
    Replies: 3
    Last Post: 11-13-2005, 11:06 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