+ Reply to Thread
Results 1 to 2 of 2

Inserting row does not take on the formatting of row above it

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,666

    Inserting row does not take on the formatting of row above it

    hi , please see enclosed file as it has examples of what i am seeing.....

    basically, i am trying to insert a row and have the new inserted row take on the cell formatting of the row above that inserted but it does not seem to work in a specific case which i show in the file.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,940

    Re: Inserting row does not take on the formatting of row above it

    convert your range of data to a Table (Control + T) and the formatting will follow. Your data is currently only in a Range and not a Table.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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 row with formula and formatting from above row
    By fride360 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2022, 05:38 PM
  2. Inserting rows with same formatting
    By ImranBhatti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2020, 12:42 AM
  3. [SOLVED] Help with Copy Above Row Formatting and Inserting new Row Below
    By brennonsmith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2017, 05:27 PM
  4. Inserting new rows and formatting
    By stryder1587 in forum Excel General
    Replies: 0
    Last Post: 06-11-2012, 01:20 PM
  5. Inserting a row with conditional formatting
    By thetrickster in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-29-2011, 07:55 PM
  6. Conditional Formatting when inserting a row
    By zahoulik in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2006, 11:10 AM
  7. Conditional formatting and Inserting Text
    By Link Strife in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 10:53 AM

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