IDN Forums - Internationalized Domain Names  
Home | Advertise on idnforums | Premium Membership

Go Back   IDN Forums - Internationalized Domain Names > IDN Talk > Idners Clubhouse

Idners Clubhouse Idners Clubhouse is the place to hang out & chill when you just feel you've searched for IDN Domains a tad too much. General offtopic conversation. Please don't post SPAM here.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 22nd August 2009, 08:08 PM
Moderator
 
Join Date: Dec 2005
Posts: 7,880
iTrader: (60)
Rep Power: 2230
bwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enough
Excel question

Is there an easy way to add a column of the (same) word, or in this case "date" to excel vertical columns.

I have a couple of hundred entries in column A lets say that go from lines 1 to 300
In column "B" I want to put the same date next to all entries- ie. 8/22/2009 down the entire list of 300 entries.
Any quick way to do that? thanks....
Reply With Quote
  #2 (permalink)  
Old 22nd August 2009, 08:14 PM
jose's Avatar
Veteran
 
Join Date: Jan 2006
Posts: 8,725
iTrader: (49)
Rep Power: 5444
jose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nicejose is just really nice
Re: Excel question

What's wrong with copy paste?
__________________
Looking for the perfect, still free .com domain name, for your next endeavor? Ask me. $5 only. Here's my most recent, 101th story of success: CarRealtime.com
Reply With Quote
  #3 (permalink)  
Old 22nd August 2009, 08:59 PM
Administrator
 
Join Date: Jan 2006
Location: On the Road
Posts: 2,276
iTrader: (50)
Rep Power: 1246
thefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished road
Send a message via Skype™ to thefabfive
Re: Excel question

Fill down.

Put 08/22/2009 in the first two rows. Select the two rows. Double click on the bottom right corner of the selection to fill down.

You can also drag the bottom right corner of the selection down to how many rows you want filled.

Copy / paste works also.
__________________
IDN? What's an IDN?
Reply With Quote
  #4 (permalink)  
Old 22nd August 2009, 09:20 PM
Moderator
 
Join Date: Dec 2005
Posts: 7,880
iTrader: (60)
Rep Power: 2230
bwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enough
Re: Excel question

Quote:
Originally Posted by jose View Post
What's wrong with copy paste?
Thanks Jose and Mo. Copy paste is tough because some of my lists have 1200+ entries and that is a bit of a pain. I guess you could do that and multiply the effect....put in a few dates. and then keep cutting and pasting and creating even larger groups, then cut and paste and double again and again. But the system Mo suggests is definately the speediest solution.
Reply With Quote
  #5 (permalink)  
Old 22nd August 2009, 09:33 PM
Administrator
 
Join Date: Jan 2006
Location: On the Road
Posts: 2,276
iTrader: (50)
Rep Power: 1246
thefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished roadthefabfive is on a distinguished road
Send a message via Skype™ to thefabfive
Re: Excel question

I think what Jose meant was you copy the date you want. Then highlight all the rows you want to contain that date and click paste.

I think we're splitting microseconds here.
__________________
IDN? What's an IDN?
Reply With Quote
  #6 (permalink)  
Old 23rd August 2009, 02:44 AM
Moderator
 
Join Date: Dec 2005
Posts: 7,880
iTrader: (60)
Rep Power: 2230
bwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enough
Re: Excel question

Quote:
Originally Posted by thefabfive View Post
I think what Jose meant was you copy the date you want. Then highlight all the rows you want to contain that date and click paste. I think we're splitting microseconds here.
Duh...i missed what he was saying. thanks all.
Reply With Quote
  #7 (permalink)  
Old 23rd August 2009, 08:27 AM
Rubber Duck's Avatar
Veteran
 
Join Date: Sep 2005
Location: Czech Republic (For those of you from USA = Chechnya)
Posts: 15,929
iTrader: (59)
Rep Power: 4536
Rubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura aboutRubber Duck has a spectacular aura about
Re: Excel question

Sometime it is easier to select with the mouse by going to the bottom and click and hold then putting the arrow outside the frame at the top. That will take you very quickly to the top, but you will stop right there. If you go off the bottom of the frame you end up approaching infinity.
__________________
All offers to sell are void.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 06:34 PM.

Site Sponsors
Your ad here
buy t-shirt
מחיר הזהב

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright idnforums.com 2005

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54