It is often difficult in large tables to
find the active selected cell. You want
to configure Excel in a way that this
cell always and automatically stands
out from the rest of the sheet.
When working on large tables, it becomes difficult to find the active cell. To solve this problem you can download a free add-in named RowLiner, which can be downloaded from http://www.cpearson.com/excel/rowliner.htm. Double click on the file to install it. Once installed, it can be accessed form the “Add-ins” tab from the menu bar. Once activated, it will highlight your active cell. To change its settings, click “RowLiner” in the “Add-ins” tab and select the “RowLiner Setup”. Here you have different options for rows and columns, as to where these are shown and how they should appear. To the right, you can control the structure of the active cell. Then confirm the configuration with “OK”. However, the “Undo” function is not available in active RowLiner. In case of extensive entries, you should deactivate RowLiner temporarily. For that, click “RowLiner” in the “Add-Ins” tab and deactivate the “Draw Lines” option.
When working on large tables, it becomes difficult to find the active cell. To solve this problem you can download a free add-in named RowLiner, which can be downloaded from http://www.cpearson.com/excel/rowliner.htm. Double click on the file to install it. Once installed, it can be accessed form the “Add-ins” tab from the menu bar. Once activated, it will highlight your active cell. To change its settings, click “RowLiner” in the “Add-ins” tab and select the “RowLiner Setup”. Here you have different options for rows and columns, as to where these are shown and how they should appear. To the right, you can control the structure of the active cell. Then confirm the configuration with “OK”. However, the “Undo” function is not available in active RowLiner. In case of extensive entries, you should deactivate RowLiner temporarily. For that, click “RowLiner” in the “Add-Ins” tab and deactivate the “Draw Lines” option.
0 comments:
Post a Comment
please write your comment
Note: Only a member of this blog may post a comment.