+ Reply to Thread
Results 1 to 8 of 8

Adding empty and narrow white row between each data row in my whole table in excel

  1. #1
    Registered User
    Join Date
    01-26-2021
    Location
    Saudi arabia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    5

    Adding empty and narrow white row between each data row in my whole table in excel

    dear All
    I have table in excel which includes more than 1000 rows of data and I am going to print it to be Beautiful shape.

    my plan was to add empty and narrow white row between each data row in my whole table to form a good shape in printing stage but I am facing latency problem. it took long time to follow whole table and add empty row, so my you help to automate this way to speed up this process either by excel feature or design special macro. excel forum question.png

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Adding empty and narrow white row between each data row in my whole table in excel

    ???

    Home format/format cells/Border and choose what way you want it to look

    ???
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    01-26-2021
    Location
    Saudi arabia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    5

    Re: Adding empty and narrow white row between each data row in my whole table in excel

    thank you Glenn too much

    it is worked with me but still I need to increase border thickness. is there any way to increase it.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Adding empty and narrow white row between each data row in my whole table in excel

    ??? Even if you select the thickest option??
    Attached Images Attached Images

  5. #5
    Registered User
    Join Date
    01-26-2021
    Location
    Saudi arabia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    5

    Re: Adding empty and narrow white row between each data row in my whole table in excel

    thank you so much

    yes I used this but I need to increase it little bit more

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Adding empty and narrow white row between each data row in my whole table in excel

    You will need VBA for that. If that is OK, let me know and i will move the thread.

  7. #7
    Registered User
    Join Date
    01-26-2021
    Location
    Saudi arabia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    5

    Re: Adding empty and narrow white row between each data row in my whole table in excel

    thank you very much

  8. #8
    Registered User
    Join Date
    01-26-2021
    Location
    Saudi arabia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    5

    Re: Adding empty and narrow white row between each data row in my whole table in excel

    I have other question in the same table.

    If I want to put a picture in cell as an evaluation (very good - good - bad) automatically after calculation of cell data.
    Is that possible.

    To clarify more: I have three pictures that represent (very good - good - bad) and I want to put it in cells after calculate.
    Attachment 715509

+ 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] Populating excel table with UserForm data witout empty rows
    By karolina1406 in forum Excel Programming / VBA / Macros
    Replies: 41
    Last Post: 11-26-2020, 11:48 AM
  2. Adding Page Numbers To The Pages With Narrow Margins
    By zanshin777 in forum Word Formatting & General
    Replies: 4
    Last Post: 06-13-2020, 06:51 PM
  3. Adding data from IBM Cognos to Excel pivot table
    By nicolew327 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-19-2017, 02:00 PM
  4. Adding a scroll bar to an Empty table
    By AdiK in forum Excel General
    Replies: 0
    Last Post: 03-02-2017, 10:50 AM
  5. Setting Margins to Narrow in Word before copying table
    By ERaasio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2013, 11:26 AM
  6. Adding Data to a word table using Excel VBA
    By gskMike in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2008, 08:39 AM
  7. [SOLVED] EXCEL workbook is off-white, goes white in edit mode
    By Joe in forum Excel General
    Replies: 0
    Last Post: 07-15-2006, 07:50 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