If you regularly work outside your workplace and complete tasks on the go, then DocHub is the document editing service you need. It’s a cloud solution that works on any internet-connected device, and you can use it from anyplace. The interface is intuitive yet powerful, so you’ll need only a few minutes to Add data in Blank and make other required adjustments.
Stop wasting time looking for an excellent document editor; explore DocHub today and complete your paperwork no matter where you are!
hi Excel us today Im going to show you how to insert a blank role in every other row of your data set this is something I get asked about quite a lot users seem to use it a lot and Im going to show you how to do this without formulas without macros you dont need to write any code and a really simple method of doing this so lets get started first thing you need to do is if your data is in column a you need to insert a new column because were going to use because were going to use the first column as a helper column now my data starts in column B so I dont need to do that and the first thing we need to do is just type 1 in the first row of our data we then can highlight down to row 16 where are they you could have 10 thousand lines 20 thousand lines but you can also use ctrl shift and the down arrow to select your column of data then what we want to do is use the fill series so in the Home tab go along to editing click fill start value is 1 and Ill stop value is 14 we have we hav