Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .