Tell me more ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.
up vote 1 down vote favorite
1

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

1 Answer

up vote 1 down vote

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 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 at 23:41
Great instructions. This is easier than it sounds actually, albeit a bit awkward! – NOTjust -- user4304 Mar 1 at 18:57

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.