Click the Microsoft Office Button, and then click Excel Options. The embed loads, however there is no horizontal scrollbar. In the Advanced category, under Display options for this workbook, clear or select the Show horizontal scroll bar check box and Show vertical scroll bar check box to hide or display the scroll bars. The only way to get to the data to the right of the view port is to click on a cell and then use the right arrow key to scroll to the right. Unfortunately, due to tenant restraints, I can't share link to demonstrate the issue as there doesn't seem to be a way to 'anonymize' Microsoft 365 share links.īelow is a screenshot - you can see there is a vertical scrollbar, but no horizontal scrollbar. The left column and top row are frozen panes. I am expecting I should be able to 'scroll to the right', like I can in Excel online. This is the format of the embed code used: The Scrollbar Fixer add-in for Microsoft Excel will quickly and easily fix scrollbars that are too small to use. It is compatible with Microsoft Excel 2003. The scroll bar to move both across columns and rows in my excel online spreadsheets are too small. In the menu on the left side, go to Options (at the end of the list). Click on Scroll Bar (Form Control) button and click anywhere on your worksheet. I do not think this is an issue that can be resolved by wrapping the iframe in a div with some sort of overflow property on it - it seems the horizontal scrollbar within the iframe embed itself is not showing. There is quite a lot of data in this spreadsheet, a few hundred rows I'd say. And navigating my way around the spreadsheet is difficult when the smallest of movements on the scrollbar jumps thousands of rows, the same goes for columns. This will insert a Scroll Bar in the excel worksheet.
0 kommentar(er)
