Can I insert Blank Lines when using: Fill, Series, Columns, Date?


  1. Posts : 751
    Microsoft Windows 7 Professional 64-bit 7601 Multiprocessor Free Service Pack 1
       #1

    Can I insert Blank Lines when using: Fill, Series, Columns, Date?


    I need to replicate a Form 52 times for each year.

    It needs to have two blank lines between each Date Line.

    Is there any way to do it.

    It is currently very tedious and error pron.

    Your help is appreciated.

    I have attached two examples: one the Form and the other the Excel Screen.

    The Excel Sheet was converted to a PDF so it could be uploaded.

    A Spreadsheet format was not one of the Upload Formats available.

    Best regards,

    Mike Lynch
    Attached Thumbnails Attached Thumbnails Can I insert Blank Lines when using: Fill, Series, Columns, Date?-capture-excel.png  
    Can I insert Blank Lines when using: Fill, Series, Columns, Date? Attached Files
      My Computer


  2. Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       #2

    This website will explain how to do what you want with an existing weekly spreadsheet.

    Insert Alternate Blank Rows in Excel | PCMag.com

    You might like to look at using an Excel Template for this job. This website could help you with this.

    Excel templates - how to make and use templates in Microsoft Excel
      My Computer


  3. Posts : 751
    Microsoft Windows 7 Professional 64-bit 7601 Multiprocessor Free Service Pack 1
    Thread Starter
       #3

    Thank you Ranger4!


    It worked and it has saved me hours and frustration.

    Best regards,

    Mike Lynch
      My Computer


  4. Posts : 9,746
    Windows 7 Home Premium 64 bit sp1
       #4

    Thanks for getting back & glad I could help.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 03:12.
Find Us