Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Need Excel Help - Blank Formulas
- Thread starter crs.one
- Start date
- Sort by reaction score
Sure, if I understand right, this can be easily done.
You want a formula (for example) in cell C1, C3, C5, C7 etc.
Cells C2, C4, C6 etc. should be empty, right ?
Enter the formula in cell C1, and make sure cell C2 is empty.
Then select BOTH cells, and click on the little blue box in the lower right corner of that selection, then drag the mouse down to copy the cell.
-t
You want a formula (for example) in cell C1, C3, C5, C7 etc.
Cells C2, C4, C6 etc. should be empty, right ?
Enter the formula in cell C1, and make sure cell C2 is empty.
Then select BOTH cells, and click on the little blue box in the lower right corner of that selection, then drag the mouse down to copy the cell.
-t
Brilliant, thank you so much.
If I may impose on your time again...
Are you familiar with Numbers? In the Inspector, under the Text tab, one can alter the spacing for line, before paragraph, after paragraph, etc.
I haven't been able to find a comparable setting in Excel to tweak the space between each line. Is there one?
Again, many thanks
Chris
Fair play. I wasn't sure if Excel was capable of adjusting the space between lines and paragraphs and such.
Thanks
Chris
There is, sort of. It basically consists of changing the row height of row in which the cell is located.
Unfortunately my Excel guru days ended four years ago, and I don’t even own Excel now. You can set up styles for cells so that the consistency would be there and you could adjust just the style instead of individual cells.
Last edited: