PDA

View Full Version : Excel question



stu120404
19-11-2004, 08:53 PM
Hello :)

In MS Excel I want to make a sheet up listing at lest 20 or 30 sites with different SEO (Search Engine Optimisation) information for example for the first column (A) I have :

URL to be submitted:

Title: (Site name)

Short Title(Site name):

keywords:

Short keywords:

Description:

Short Description:

Company name:

Name:

Address:

Phone number:

Fax:

E-mail:

NZ Or overseas Search engines or both?

Date late submitted:

Date submitted:

Then in the 2nd column I have all the information that is related to column A

Then I have to do that another 20 or so time with each of the sites different information

What would be the best way to do this?

A. Do it how I am doing it now?

B. Have Column A as number 1 & have the data coming from the top down ( I donít think this will work, due to the amount of data)

C. another way?

Any Ideas?

Mike
19-11-2004, 09:01 PM
Use Row 1 as the heading row, listing all those headings that you've listed for Column A. Bold them and freeze the pane (so those headings are always visible if you need them to be).
Enter the info for each site on each subsequent row - you shouldn't need to retype the headings for each site. You can fit much more info down the page than you can across it.

Mike.

HadO
19-11-2004, 09:02 PM
Instead of putting all the title information in a column put it on the top row and then all the info below it in the columns.

The sheet will obviously get very wide though and it will be hard to view at a low resolution...

HadO
19-11-2004, 09:03 PM
> freeze the pane

Good point Mike

Mike
19-11-2004, 09:06 PM
> The sheet will obviously get very wide though and it
> will be hard to view at a low resolution...

Word-wrap the cells to suit.

Mike.