![]() |
A Crosshair to Highlight the Entire Row/Column Prior to active cel
Occassionally, a worksheet needs to be viewed in a very low zoom. I had to do
this when I had many columns of data and needed to see most of them all at once. I could not freeze the pains because I would lose coverage of the required columns. When I zoomed out, it was very had to track back on the same row that the data was on. For example, I needed to look at data M221and I221 and then look at data on A221. I found it difficult to stay on the same line when moving back to column A (at-a-glance), because the data was so small. If there was a crosshair feature that one could enable, this would eliminate inaccuracy. The prior cells in the column would be faintly highlighted and the prior cells in the row would be faintly hghlighted, making it simple to track back along the same line. I am currently using the newest version of Microsoft Excel. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming |
A Crosshair to Highlight the Entire Row/Column Prior to active cel
Maybe you could use Chip Pearson's rowliner addin:
http://www.cpearson.com/excel/RowLiner.htm Or maybe you could use: window|new window window|arrange (horizontal??) And view both areas of your worksheet in different windows. Josh Lakien wrote: Occassionally, a worksheet needs to be viewed in a very low zoom. I had to do this when I had many columns of data and needed to see most of them all at once. I could not freeze the pains because I would lose coverage of the required columns. When I zoomed out, it was very had to track back on the same row that the data was on. For example, I needed to look at data M221and I221 and then look at data on A221. I found it difficult to stay on the same line when moving back to column A (at-a-glance), because the data was so small. If there was a crosshair feature that one could enable, this would eliminate inaccuracy. The prior cells in the column would be faintly highlighted and the prior cells in the row would be faintly hghlighted, making it simple to track back along the same line. I am currently using the newest version of Microsoft Excel. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...el.programming -- Dave Peterson |
All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com