Now let’s look at another similar feature. And I’ve also covered how Rows To Repeat At Top brings that same idea to printing. It's a pain and I think an unresolved bug Microsoft has still to address. I’ve talked before about using the Freeze Panes feature to keep rows in place at the top of an Excel worksheet (or column in place at the left side) so you can still see your headings as you scroll through a worksheet. So I do not tell you about instances where it is designed to be greyed out, purely my situation using Excel in everyday normal view mode. Whether this is a bug of the ribbon or of the code behind the function I do not know, but it remains a mystery. This refreshes the ribbon and it is working again. For example the Wrap Text and Group command buttons.īut whilst simply swapping out the old for the new solves those issues permanently, Freeze Pains remains unreliable, becoming disabled seemingly in random spreadsheet sessions.!Ĭurrently the only way I have found is to remove the function from the ribbon and immediately add it back. To freeze panes in Microsoft Excel 2010, select View > Arrange All > Freeze Panes. Select Freeze Panes to display a drop-down list. For example, to keep row 1, row 2, and column A on the screen when you scroll, select cell B3. My customised ribbon was made in a version a few years ago.is has been exported to later versions.then I found icons or functionality changed in some way or form. Select the cell to the right of the columns and just below the rows that you want to freeze in place. It's next to Arrange All and Split/Hide towards the right side of the toolbar. Whilst using the full downloaded client version of Excel 365 and particularly since ribbons came to fruition I have created customised ribbons, then this particular issue started occurring along with others. You can either open the program within Excel by clicking File > Open, or you can right-click the file in your file explorer. I have had the same situation happen frequently and as yet haven't read a satisfactory explanation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |