Results 1 to 23 of 23

Ability to auto-highlight entire row and column of selected cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2010
    Location
    Shreveport, LA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Ability to auto-highlight entire row and column of selected cell

    Friends and Experts,

    My colleguaes and I work with a rather large data entry/archiving Excel 2007 spreadsheet on a daily basis. It contains several columns and rows that will not easily fit on one viewable screen. We have searched for the ability to highlight the entire data set across the row and down the column of the selected cell. This would allow us to navigate with the directional keys quickly and enter data assuring us we are on the correct row and column with a simple visual indication.

    I know that the number and letter of the row and column highlight on their own, but what we are needing is for the entire row and column of data to highlight as well.

    I have attached an example of what we would like to see.

    Does anyone know of a setting/function/method to accomplish this? I have searched around to no avail.
    Attached Images Attached Images
    Last edited by stephenminton; 05-20-2010 at 04:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1