Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Floating cells
Hi boys and girls
I have a sheet where i put my bills, and have a list with the accounts I need to put them in, and want that list to follow me on my way down on the rows with bills. A1 B1 C1 D1 F1 Date Text on bill Account Amount Account and explenation There are 20 accounts in column F that I want to "float" as i use the rows for putting in bills I have frozen row 1, so its easy to se where to put the date, text on bill, account and amount Any suggestions?? Rock -- Just a regular user |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Floating cells
Hi,
Why not highlight the column and choose Data, Validation from the Allow drop down pick List and in the source box enter = and the range where you choices are (column F) when you move to any cell in that column you will have a drop down list with all the choices. If this helps, please click the Yes button Cheers, Shane Dvenshire "Rockbear" wrote: Hi boys and girls I have a sheet where i put my bills, and have a list with the accounts I need to put them in, and want that list to follow me on my way down on the rows with bills. A1 B1 C1 D1 F1 Date Text on bill Account Amount Account and explenation There are 20 accounts in column F that I want to "float" as i use the rows for putting in bills I have frozen row 1, so its easy to se where to put the date, text on bill, account and amount Any suggestions?? Rock -- Just a regular user |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Floating cells
Hi
They wanted also the text from the account in the col. G to be in the list they can choose from, is that possible in any way? F is accountnumber, G is the explaining text of the account in F Ex: 5340 Cost repairing office machines Can one do in any way? Rock -- Just a regular user "Shane Devenshire" wrote: Hi, Why not highlight the column and choose Data, Validation from the Allow drop down pick List and in the source box enter = and the range where you choices are (column F) when you move to any cell in that column you will have a drop down list with all the choices. If this helps, please click the Yes button Cheers, Shane Dvenshire "Rockbear" wrote: Hi boys and girls I have a sheet where i put my bills, and have a list with the accounts I need to put them in, and want that list to follow me on my way down on the rows with bills. A1 B1 C1 D1 F1 Date Text on bill Account Amount Account and explenation There are 20 accounts in column F that I want to "float" as i use the rows for putting in bills I have frozen row 1, so its easy to se where to put the date, text on bill, account and amount Any suggestions?? Rock -- Just a regular user |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Floating Cells? | Excel Discussion (Misc queries) | |||
Floating Cells | Excel Worksheet Functions | |||
FLOATING CELLS | New Users to Excel | |||
FLOATING CELLS HELP!!! | Excel Discussion (Misc queries) | |||
FLOATING CELLS | Excel Worksheet Functions |