Here are some interesting Operating system and softwares tips and tricks 4u.JUST CLICK ON THE PICTURE IN THE BLOG FOR ENALARGED VIEW.

sd

Thursday, March 8, 2012

Highlight the active cell in Microsoft Excel(Excel XP, 2003, 2007, 2010)

              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.

0 comments:

Post a Comment

please write your comment

Note: Only a member of this blog may post a comment.

THE WINDOWS TRICKS Headline Animator