Accessible Excel (implementation guide)
The implementation aid Excel barrier-free serves as support for the Excel barrier-free checklist. The order of the aspects and the structure according to categories are the same.
Under the heading "What is meant by this? " you will find a detailed description of the aspect to be ticked off. The section "Why is it important?" describes which barriers you are removing with the respective aspect and for which groups of people this is essential. Finally, under the heading "How can I implement/check this?" you will find detailed instructions on how to implement or check the respective aspect.
3. Spreadsheet
3.8. Fixations
Fixations are set sensibly so that column and row headings are always visible.
What is meant by this?
Locking in Excel makes it possible to lock certain parts of a spreadsheet, such as rows, columns or areas, in order to keep them visible even when scrolling. When users scroll through the spreadsheet, the pinned areas remain in place, meaning that the headings or important data always remain visible. On the other hand, the unfixed areas that have not been specifically fixed can be moved normally while scrolling to allow a comprehensive view of the data, especially if the spreadsheet is large and cannot be displayed in full on the screen.
Why is it important?
The function of fixations in Excel is crucial for quickly maintaining an overview even in extensive tables and finding your way around efficiently. By fixing columns and rows, important headings always remain in view when scrolling, which makes it much easier to find your way around the table. This helps users to orientate themselves more quickly and find the desired data in the table quickly without losing the overview.
How can I implement/check it?
To set fixations in Excel and check that they work correctly, follow these steps:
- Click on "View" to display the view options.
- Select the fixation option you require from the various fixation options.
- To freeze a line, select the relevant area and select "Freeze top line".
- Then check whether the desired rows or columns have been fixed and whether they behave correctly when scrolling. Make sure that the fixed elements remain in position and that the unfixed areas can still be scrolled.