User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » excel ??????????????? Page [1]  
TheBullDoza
All American
7117 Posts
user info
edit post

I am trying to create a spread sheet that has a column that is stricly dates that include the dates from now until 2 years from now. I want there to be 6 spaces or rows between each date, and i dont want to do it manually.....anyone know how i can do that?

does it make sense?

7/18/2007 1:57:59 PM

LimpyNuts
All American
16859 Posts
user info
edit post

[start date]
blank cell
blank cell
blank cell
blank cell
blank cell
blank cell
[next date]
blank cell
blank cell
blank cell
blank cell
blank cell
blank cell


1. highlight the above.
2. grab the handle in the lower right hand corner and extend.
3. profit

7/18/2007 2:01:11 PM

Arab13
Art Vandelay
45180 Posts
user info
edit post

that would probably do it...

7/18/2007 2:02:24 PM

qntmfred
retired
40726 Posts
user info
edit post

^^ that's what i was thinking too. didn't work in excel 2007 though

[Edited on July 18, 2007 at 2:04 PM. Reason : might work for 2003]

7/18/2007 2:03:53 PM

TheBullDoza
All American
7117 Posts
user info
edit post

hell yeah, man. You are the shit!

7/18/2007 2:04:16 PM

El Nachó
special helper
16370 Posts
user info
edit post

That worked for me in 2007. I didn't know you could do that. That's a hell of a lot easier then the way I would have done it.

7/18/2007 2:09:37 PM

TheBullDoza
All American
7117 Posts
user info
edit post

yup, for 03 it worked....limpynut's plan worked

7/18/2007 2:11:49 PM

qntmfred
retired
40726 Posts
user info
edit post

for 2007, it worked if typing date literals in A1 and A8, but not when A1 and A8 are references to other cells

7/18/2007 2:17:43 PM

El Nachó
special helper
16370 Posts
user info
edit post

Ah. yeah, I just typed in two dates.

Seriously though, I'm ashamed to admit how I would have solved this otherwise.

7/18/2007 2:22:20 PM

pilgrimshoes
Suspended
63151 Posts
user info
edit post

BRUTE FORCE

7/18/2007 4:00:34 PM

 Message Boards » Tech Talk » excel ??????????????? Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.