Naming cells

L

Louja

In order to help with formulas I was going to name cells. This is because the info is in horizontal rows but I am using it to create a journal which will be vertical.

There are various names on each row.

There are lots of rows is there any short cut so that all the cells on row 1 are name1, age1 etc then the second row it would be name2, age2. Apart from me manually changing everything?
 
L

Louja

Looks like the VBA course I want to go on should be sooner rather than later.

Once the spreadsheet has been set up I shouldn't be adding more rows. Just need to do it for the set up.

Thanks!
 
L

Louja

Hi,

Thanks for your help. If there is a way better than naming I am happy to use it.

With my limited excel knowledge I thought that would be the best way to do it.

Thanks for your help. I will have a look.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving cells 5
How to find columns which contain less than x null values 1
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Need to alphabetize data from separate cells within same row 2
Consolidating with empty-string ("") cells removed 7
putting 2 long columns into multiple columns in excel page and sor 1
Incrementing cell references slower than by 1 2
Naming non-contigent cells with vba 5

Top