Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

When reading larger spreadsheets, it would be helpful to highlight the row and column that the currently selected cell is in. I'm not talking about conditional formatting or anything in the spreadsheet itself, I'm just talking about a viewing option. I couldn't find a similar option anywhere.

share|improve this question
add comment

1 Answer

If I understand your question, Numbers does this by default - note the darkened row and column identifiers in the image below at AK50.

Numbers

Edit: ah, I see.. okay, I found an inconvenient hack:

  • Select the Column containing your target cell
  • Cmd click the cell above (or the Cmd Click the row index of the cell above)
  • Cmd click the Row containing your target cell
  • Cmd click to reselect the cell above your target

Like so:

Cmd Click the row index of the cell above

Cmd click the Row containing your target cell

Cmd click to reselect the cell above your target

Maybe you could use automator to make this less painful?

share|improve this answer
    
Sorry, I should have been clearer: I'm hoping to have the entire row and column highlighted, to make it easier to identify other cells in that row and column. In large spreadsheets it can be hard to tell for sure if a cell is in the same row as another. –  Virgil Disgr4ce Jan 10 '13 at 22:29
    
@VirgilDisgr4ce - I see - I've edited may answer above - but its a painful hack (its only one extra click to get the funny T shaped highlight) –  memeLab Jan 11 '13 at 23:41
    
Great instructions. This is easier than it sounds actually, albeit a bit awkward! –  NOTjust -- user4304 Mar 1 '13 at 18:57
    
Hm, I was thinking of something that's constant and automatic; highlighting the entire row and column makes it MUCH easier to read on a very large window. –  Virgil Disgr4ce Feb 28 at 16:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.