+ Reply to Thread
Results 1 to 3 of 3

Inserting rows with specific properties

  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2010
    Posts
    2

    Inserting rows with specific properties

    I have a sheet where, starting at row 4, each row will follow the same format. Like so:

    Please Login or Register  to view this content.
    I have cells that will have data validation and cells that are calculated based on other cells in the same row. When I go to add a new entry, I want to push all of the entries down (row4->row5) and have the new row be blank but behave the same as before. What's the easiest way to do this? I feel like it should be super easy but I couldn't find anything like this when I searched the forums, so sorry if it's obvious or the thread exists 1000 times.

    Thank you.
    Last edited by beebe; 10-02-2013 at 02:11 PM. Reason: spacing for clarity

  2. #2
    Forum Contributor
    Join Date
    10-01-2013
    Location
    Cameron, Mo
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: Inserting rows with specific properties

    Use the format painter create the row where you want it then use the format painter on the row below it (the one that was 4 but is now 5). If that is not an option you could create a blank row 4 with the proper formatting and then hide it. Each time you created a new row (in row 5 now) it would take on the formatting of the hidden and blank row 4. These are the quickest easiest ways I can think of. Good luck!

  3. #3
    Registered User
    Join Date
    10-02-2013
    Location
    Missouri
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Inserting rows with specific properties

    Thank you. I just found tables for the first time and I think it'll do the trick. If not I'll try what you suggested.

+ 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. Inserting Blank Rows after Specific Dates
    By Undy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 04:15 PM
  2. Inserting Rows after Specific Entries
    By sigma1113 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2011, 09:56 AM
  3. Lock specific rows while inserting new rows
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2008, 10:00 AM
  4. Inserting 10 rows after a specific row
    By stabilo in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-04-2005, 12:05 PM
  5. inserting specific # of rows
    By cwinters in forum Excel General
    Replies: 1
    Last Post: 06-06-2005, 03: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