scroll

I have a macro assigned to a shape and I would like it to follow the page as I scroll down is this possible? Thanks

HI all I use excel for a staff rota. The dates are from D4 across to FF4 or whatever D4 plus 365 is......but it is a long way to scroll across! Columns AB&C are for names, information etc....these don't scroll as they are frozen(freeze panes) I was wondering this: I would like to enter a...

I can't edit formulas within the formula bar. Whenever I move my mouse cursor to the formula bar, there's a scroll bar that pops up. Here's a picture of it. This is happening with all files, not just a single particularly file. Does anyone know how to fix this? Attaching a picture...

I have a dashboard that I would like to add some customer detail to but I don't want to take up to much space. If i do a top 20 a lot of meaningful customers are left out. Is there any way to lock the size of a pivot table at 20 rows but include a scroll option so that all customers can be...

Excel 2016 MSO (16.0.4639.1000) 32-bit This is a macro enabled workbook with several modules in Visual Basic. Also, every spreadsheet has Worksheet_BeforeDoubleClick sub routines. One spreadsheet is "Summary Report". "Summary Report reads values (via if statements and simple = formulas) on...

Hi, I would like to add a tab in excel so you can go directly to a cell. I have an example but unsure how to post it in this forum. It was called a "scroll to week"i n the project mngt template I found online. ny help would b appreiated.

deleted, sorry found answer.

What's up experts! I just downloaded Microsoft Excel 2016 on my MacBook Pro and I am having trouble figuring out simple worksheet grouping tricks that I used to use on my Excel 2011. I track data on college football and I have tabs on every team. 127+ tabs in total. In Excel 2011 when I...

I have created a macro to scroll to the row that begins with the letter selected. I had this working great before lunch. I copied the macro and the activeX field over to another workbook. Now the part where it scroll to the selected letter row does not work. If the search cell is blank, it will...

Hi all, I already have a scroll bar that increases profit value of all my products sold uniformly on a quoting spreadsheet. However I require some products to have a higher profit applied as they are more expensive to produce. What happens at the moment is my SS works out the base cost, uses a...

I have a form that has several subforms on it. When I open the form I have to use the scroll bars to scroll up to the top and then over to the left. it never opens up to where you can see the top or far left. how can I get it to open where the user doesn't have to use the bars to see the top...

Hi all. I would like to create a macro which would scroll through a table if there are too many rows to fit on the display. For example, if the table had more than 25 rows, scroll until the last row is displayed. Once the end of the table is reached, the scroll would return to the first entry...

Hello Excel Gurus, I am running the following code to do a simple task which is to bring all the sheets in the Workbooksheet to Position A1 and if there are scroll in the other sheet bring them to original scroll position with Columns like A... B...C ....D....E... etc etc. I am getting the...

I was just curious if it's at all possible to make column 1 (or actually 0) in a multicolumn listbox always visible as you scroll right. Similar to how freeze pane works on a spreadsheet. If not, that's ok. I'm just curious.

I'm trying to create a worksheet for my students to practice locating the position of a fraction on a number line I am using a scroll bar (Form control) for the students to drag the "marker" to the correct position under a number line I have a second scroll bar below that one that shows the...

Hi, In excel 2016 it looks like you can't scroll to the furthest-most right or left tab by clicking on the arrow in the bottom left corner of excel. Is there any way to get this feature back? I have a spreadsheet with about 30 tabs and I don't want to scroll one at a time. Thanks

Hi Can I get a script to scroll the vertical scrollbar to the bottom of the list of a listbox? I load the listbox each time I add data . So I will like to see the last item. Thanks

I wonder if it is possible to have similar to a dashboard or menu, where I have a list of sheets to choose from ( it might be as many as 30 ) when I click on the sheet name it takes me to the sheet instead of needing to scroll along to find the sheet I need. The sheets are very low data, a few...

I am trying to add a scroll bar to a dashboard in my Excell workbook. This seems relatively easy. My question is if I end up adding more colums of data than originally anticipated is there a way to set the scroll bar to automatically catch that extra data. So say I have a scroll bar linked to 50...

Hi All, If i use List Box then there is scroll bar come with List box(by default). It only work if I click by mouse on downward direction of pointer. If I scroll by mouse on that List box, it wont work..So do I have that facility on this..