Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I don't know if this is a trivial problem but it is driving me nuts. I have two columns like this:

| A |B|
|   |5|
|   |3|
|   |5|
|   |2|
|   |3|

In column A all cells are merged and I use the values of column B to calculate a percentage. I have to select all cells in column B. As soon as I enter "=SUM(" and start clicking on the cells I need I have an overlap in column A which covers my values in column B so I can't see the cells in column B. Is there a way to prevent this?

share|improve this question
Increase column widths? – variant Aug 26 '11 at 13:53
Hmm. I have a lot of documents which are formatted that way. I'd rather not change the widths. – user48604 Aug 26 '11 at 13:55
manually typing the cell ranges? – Terry Aug 26 '11 at 14:50
up vote 0 down vote accepted

Go somewhere in column C and type the formula, but don't press Enter. When it's complete, press F2 to switch from enter mode to edit mode, then shift-Home to highlight the entire formula. Ctrl-X to cut it, Esc to cancel typing. Then just paste the formula where you want it.

share|improve this answer
ok. will try that thx. – user48604 Aug 29 '11 at 7:22

Your Answer


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.