I have a vehicle database and each cell has a list of vehicles. I have about 1000 rows of data and need to select all text in each cell to copy onto another sheet. How can I use the F2 function to select multiple cells rather than just 1
Welcome to the Board!
I am not quite clear on why you are trying to use F2. F2 gets you into the individual cell editor. If you want to copy a whole range of cells, why are you using F2, and not simply just selecting all the cells you want, and then choosing "Copy"?
Okay what so I have multiple rows with multiple text inside each each cell. I need divided into seperate rows. I can copy the text inside a cell and paste it (paste A)Welcome to the Board!
I am not quite clear on why you are trying to use F2. F2 gets you into the individual cell editor. If you want to copy a whole range of cells, why are you using F2, and not simply just selecting all the cells you want, and then choosing "Copy"?
Welcome to the Board!
I am not quite clear on why you are trying to use F2. F2 gets you into the individual cell editor. If you want to copy a whole range of cells, why are you using F2, and not simply just selecting all the cells you want, and then choosing "Copy"?
I want to bulk copy all text on each row and paste A into new rows bulkWelcome to the Board!
I am not quite clear on why you are trying to use F2. F2 gets you into the individual cell editor. If you want to copy a whole range of cells, why are you using F2, and not simply just selecting all the cells you want, and then choosing "Copy"?
Welcome to the Board!
I am not quite clear on why you are trying to use F2. F2 gets you into the individual cell editor. If you want to copy a whole range of cells, why are you using F2, and not simply just selecting all the cells you want, and then choosing "Copy"?