Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

06 Jul 2017   #1
Mike Lynch

Vista Ultimate 64 and Windows-7 both are 64 Bit
 
 
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 Images
Can I insert Blank Lines when using: Fill, Series, Columns, Date?-capture-excel.png 
Attached Files
File Type: pdf 2017 - A Master Payroll Sign In Sheet for 2017.pdf (172.6 KB, 6 views)
My System SpecsSystem Spec
.
06 Jul 2017   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

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 System SpecsSystem Spec
07 Jul 2017   #3
Mike Lynch

Vista Ultimate 64 and Windows-7 both are 64 Bit
 
 
Thank you Ranger4!

It worked and it has saved me hours and frustration.

Best regards,

Mike Lynch
My System SpecsSystem Spec
.

07 Jul 2017   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Thanks for getting back & glad I could help.
My System SpecsSystem Spec
Reply

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




Thread Tools




Similar help and support threads
Thread Forum
Outlook emails chopped short and sent date and recipient blank
Hi I am using Outlook 2007 and i keep about 2 years of all sent emails in the Sent emails folder. The automatic archive for this folder are set so that any emails older than 2 years, are moved to the archive folder. A number of months ago (been too busy to tackle this until now...
Microsoft Office
My Computer, HDD Fill Lines, Tourquoise versus Red ?
In My Computer, (arrived at via keystroke: Windows Key-E,) what is the significance of the different colored lines indicating how full the hard disk drives are? The colors I see are tourquoise and red. Based on a sample too small to be conclusive, I suspect red means the hard drive is...
General Discussion
File search (by date range) displays incorrect Mod Date in results
Searching for files modified in a specified date range (of the past 3 days) gets a search result list titled "date modified", and with the column heading "Date Modified" but the date listed against a file modified today is wrong. The date displayed matches the file creation date & is within the...
General Discussion
Date format using space as date separator rather than forward slash!
Hi all, I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control Panel I have the short date...
General Discussion
Unwanted blank lines in outgoing emails
Hello: Need help, please! My new laptop is running Win 7 Home Premium (64 bit) -- also, IE 9, Windows Live Mail and Windows Live Hotmail. Here's the problem: When composing a new email, it looks fine until it is sent. The recipient, however, recieves a message riddled with unwanted...
Browsers & Mail


Our Sites

Site Links

About Us

Find 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 17:12.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App