ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I creat scrol Bar in cell? (https://www.excelbanter.com/excel-discussion-misc-queries/109905-how-do-i-creat-scrol-bar-cell.html)

Sit Kumar

How do I creat scrol Bar in cell?
 
I mean, how we can creat scorl bar in cell of MS Excel?

Roar

How do I creat scrol Bar in cell?
 
Hi Sit,

Scrol bar = dropdown?

1 Some place in the sheet make a list of allowed values, text or numbers
2 Activate the cell where to insert the dropdown
3 Data/Validation =Alllow: List = source = area above
--
~roar


Sit Kumar skrev:

I mean, how we can creat scorl bar in cell of MS Excel?


Dave Peterson

How do I creat scrol Bar in cell?
 
There's a scrollbar on the Forms toolbar and a different scrollbar on the
Control Toolbox Toolbar.

show the toolbar with the scrollbar you want
click on the scrollbar
and click on the worksheet where it should be added.

You can resize later.

Sit Kumar wrote:

I mean, how we can creat scorl bar in cell of MS Excel?


--

Dave Peterson


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com