Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should feature a highlighted row/column cursor that scrolls
I would like to highlight a row or column with my cursor and have it scroll
as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should feature a highlighted row/column cursor that scrolls
maybe....
you may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm Indiana Jay wrote: I would like to highlight a row or column with my cursor and have it scroll as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...lic.excel.misc -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should feature a highlighted row/column cursor that scrolls
This has been previously posted here http://tinyurl.com/bhhnr
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" <Indiana wrote in message ... I would like to highlight a row or column with my cursor and have it scroll as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...id=50c21b19-ae 38-4a89-a0a9-b17ffcf73a30&dg=microsoft.public.excel.misc |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should feature a highlighted row/column cursor that scro
Well I hope you get your wish and sorry for trying to help.
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" wrote in message ... I don't want some workaround macro, I want the feature built in. "Bob Phillips" wrote: This has been previously posted here http://tinyurl.com/bhhnr -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" <Indiana wrote in message ... I would like to highlight a row or column with my cursor and have it scroll as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...id=50c21b19-ae 38-4a89-a0a9-b17ffcf73a30&dg=microsoft.public.excel.misc |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should feature a highlighted row/column cursor that scro
Thanks Bob for helping, I didn't mean for my response to sound ungrateful,
it's just that my intent was to suggest to Microsoft that this would be a very useful feature for all to have. I believe many people would use this feature, who have to work with large amounts of data that spreads across a page, and can be difficult to follow across with the naked eye. I would like to turn on my cursor highlighting bar the same way I freeze panes, or split screens. In fact, know that I think of it, the "highlighted cursor bar" feature would be appropriately added to the Window menu. All the best, Jay "Bob Phillips" wrote: Well I hope you get your wish and sorry for trying to help. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" wrote in message ... I don't want some workaround macro, I want the feature built in. "Bob Phillips" wrote: This has been previously posted here http://tinyurl.com/bhhnr -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" <Indiana wrote in message ... I would like to highlight a row or column with my cursor and have it scroll as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...id=50c21b19-ae 38-4a89-a0a9-b17ffcf73a30&dg=microsoft.public.excel.misc |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel should feature a highlighted row/column cursor that scro
Jay,
We see the notice at the foot that says that it is a recommendation for MS (and presumably they do take notice of these?), but we tend to assume that although the poster is putting forward a suggestion, they would still like a solution, at least until it does become a built-in. I absolutely agree it would be useful, as proven by Chip developing his add-in, and the number of times I have offered my solution to posters, but I am not so sure is up there in MS's priorities. Regards Bob "Indiana Jay" wrote in message ... Thanks Bob for helping, I didn't mean for my response to sound ungrateful, it's just that my intent was to suggest to Microsoft that this would be a very useful feature for all to have. I believe many people would use this feature, who have to work with large amounts of data that spreads across a page, and can be difficult to follow across with the naked eye. I would like to turn on my cursor highlighting bar the same way I freeze panes, or split screens. In fact, know that I think of it, the "highlighted cursor bar" feature would be appropriately added to the Window menu. All the best, Jay "Bob Phillips" wrote: Well I hope you get your wish and sorry for trying to help. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" wrote in message ... I don't want some workaround macro, I want the feature built in. "Bob Phillips" wrote: This has been previously posted here http://tinyurl.com/bhhnr -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" <Indiana wrote in message ... I would like to highlight a row or column with my cursor and have it scroll as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...id=50c21b19-ae 38-4a89-a0a9-b17ffcf73a30&dg=microsoft.public.excel.misc |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!: Excel should feature a highlighted row/column cursor
Dear Bob,
I tried this at work this morning and it was excellent! I really appreciate the tip. However, as I do not use macros much and am not familiar with event codes, when I went to print the highlight showed on the printout. ): Is there a way to turn this off for printing purposes? Thanks, Jay "Bob Phillips" wrote: Well I hope you get your wish and sorry for trying to help. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" wrote in message ... I don't want some workaround macro, I want the feature built in. "Bob Phillips" wrote: This has been previously posted here http://tinyurl.com/bhhnr -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" <Indiana wrote in message ... I would like to highlight a row or column with my cursor and have it scroll as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...id=50c21b19-ae 38-4a89-a0a9-b17ffcf73a30&dg=microsoft.public.excel.misc |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!: Excel should feature a highlighted row/column cursor
Yes that should be possible.
Change the highlighting code to this '---------------------------------------------------------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) '---------------------------------------------------------------- ThisWorkbook.Names.Add "'" & Me.Name & "'!_HiLite", True Cells.FormatConditions.Delete With Target With .EntireRow .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" With .FormatConditions(1) With .Borders(xlTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With With .Borders(xlBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With .Interior.ColorIndex = 20 End With End With With .EntireColumn .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" With .FormatConditions(1) With .Borders(xlLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With With .Borders(xlRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With .Interior.ColorIndex = 20 End With End With .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" .FormatConditions(1).Interior.ColorIndex = 36 End With End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. and add this printing code Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim hilite As Boolean With ActiveSheet hilite = False On Error Resume Next hilite = Evaluate(.Names(ActiveSheet.Name & _ "!__Hilite").RefersTo) On Error GoTo 0 If hilite Then .FormatConditions.Delete End If End With End Sub This is workbook event code. To input this code, right click on the Excel icon on the worksheet (or next to the File menu if you maximise your workbooks), select View Code from the menu, and paste the code -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" wrote in message ... Dear Bob, I tried this at work this morning and it was excellent! I really appreciate the tip. However, as I do not use macros much and am not familiar with event codes, when I went to print the highlight showed on the printout. ): Is there a way to turn this off for printing purposes? Thanks, Jay "Bob Phillips" wrote: Well I hope you get your wish and sorry for trying to help. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" wrote in message ... I don't want some workaround macro, I want the feature built in. "Bob Phillips" wrote: This has been previously posted here http://tinyurl.com/bhhnr -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Indiana Jay" <Indiana wrote in message ... I would like to highlight a row or column with my cursor and have it scroll as I move my cursor so that I can see what items are in the same row/column that my cursor is in. ---------------- 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...id=50c21b19-ae 38-4a89-a0a9-b17ffcf73a30&dg=microsoft.public.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Pivottable feature(?) in Excel 2003 SP-1 | Excel Discussion (Misc queries) | |||
Highlight 1 cell in Excel & move mouse-stays highlighted - stop? | Excel Discussion (Misc queries) | |||
MS Excel should have MS word feature. | Setting up and Configuration of Excel | |||
Excel Installing feature | Excel Discussion (Misc queries) |