GatorManiac
New Member
- Joined
- Jun 14, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I apologize in advance for my ignorance; I learned how to create a text box and add the scroll bar function to it by changing the properties. But, I am trying to design an entire spreadsheet where the cells in several columns will have longer, text answers. I want to use scroll bars in the cells in those columns so that the spreadsheet maintains a uniform appearance, but you can type as much as you want when adding information to those cells. Is there a way to easily copy and paste a text box created in the Developer or is there a way to add scroll bar functionality to a cell without creating the text box and then copy and paste that cell to an entire column?
In the column "Corrective Action(s) To Be Performed" for example, the answers will be longer than the cell size allows. This is where I'd like to have some type of scroll bar function so that each row remains the same size, no matter the amount of information in each cell. Thanks very much in advance for any assistance that you can give!
In the column "Corrective Action(s) To Be Performed" for example, the answers will be longer than the cell size allows. This is where I'd like to have some type of scroll bar function so that each row remains the same size, no matter the amount of information in each cell. Thanks very much in advance for any assistance that you can give!