Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel to tab over to only certain cells
I have a database in which i input values. It has Surname, Forename, Date of
Birth, etc etc. How do i get excel to open up in cell 'Surname' as a default, then when i press the tab key i want it to go straight to DOB, then Forename ? i.e. to tab from, say cell B5 straight to D8 then to E1, hope this makes sense !! Also, i want to copy cell B1 in sheet 1 to B1 in sheet 2, but because it is a merged cell I just get #VALUE in sheet 2. How would i copy the text from B1 sheet 1 to B1 sheet 2 in my example ? Cheers Andy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
How do I password protect cells in a spreadsheet created in Excel | Excel Worksheet Functions | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |