GetDotted Domains

At GetDotted, a 1 year .co.uk, .uk, .me.uk or .org.uk registration is now just £1.95 ex VAT.

Search Domains Now

Viewing Thread:
"Any Excel wizards out there?"

The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.

Tue 22/07/03 at 23:33
Regular
Posts: 787
I've got a list of my DVDs in Excel, and I have alternate lines hilited with a blue background.

I've been doing this manually, but as the list grows it's getting to be a pain - when I insert rows, everything including the backround colour moves and I have to fiddle around with the layout to correct it.

Is there any way I can automate this easily with a function?

Thanks.
Wed 23/07/03 at 01:11
Regular
"bing bang bong"
Posts: 3,040
You can make umpteen bazillion alternating colour rows by making two, selecting the rows by clicking on their row headers and auto-filling (select both rows, there should be a dark black box in the bottom-left corner of the selection rectangle, click on this and drag downwards). If you want to insert a row, your best bet is to select all the row that will get displaced, Cut them, then use Paste Special to paste them back a row below where they were cut from. If you paste in just the values, it won't muck up your alternating colours.
Tue 22/07/03 at 23:40
Regular
"MildlyAmusing.co.uk"
Posts: 5,029
Format -> Autoformat

Choose one from there?

I can see one that does grey and white, instead of blue. Don't know if you can change it, but surely it doesn't make too much of a difference...
Tue 22/07/03 at 23:33
Regular
"Wobble"
Posts: 264
I've got a list of my DVDs in Excel, and I have alternate lines hilited with a blue background.

I've been doing this manually, but as the list grows it's getting to be a pain - when I insert rows, everything including the backround colour moves and I have to fiddle around with the layout to correct it.

Is there any way I can automate this easily with a function?

Thanks.

Freeola & GetDotted are rated 5 Stars

Check out some of our customer reviews below:

Just a quick note to say thanks for a very good service ... in fact excellent service..
I am very happy with your customer service and speed and quality of my broadband connection .. keep up the good work . and a good new year to all of you at freeola.
Matthew Bradley
Wonderful...
... and so easy-to-use even for a technophobe like me. I had my website up in a couple of hours. Thank you.
Vivien

View More Reviews

Need some help? Give us a call on 01376 55 60 60

Go to Support Centre
Feedback Close Feedback

It appears you are using an old browser, as such, some parts of the Freeola and Getdotted site will not work as intended. Using the latest version of your browser, or another browser such as Google Chrome, Mozilla Firefox, or Opera will provide a better, safer browsing experience for you.