Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

If I select row1-row10 as a group to create an outline, but there is no

formula in any row, then I have to create the outline manually and it

works. If I want to display level1 only, rows1-9 will be hidden and

row10 is visible.

The problem is that instead of row10, I want row1 to be visible and

hide row2-row10. Not knowing how to do it manually, I do the following-

- pick up any column not in use, say colmn G, and put =sum(G2:G10) in

cell G1. Now that I have a formula, I can create an outline of row1-

row10 "automatically" and have row1 in view and row2-row10 hidden. It

works.

My question is other than what I do (using an extra column and putting

a dummy formula there), is there any easier way to do it?

Go to menu option > Data > group and Outline > Settings, then toggle

off the "Summary rows below detail" option. That will give you the

summary row at the top.

Because I use this feature so often, I have the "Group" icon on my

normal toolbar. It makes it a lot easier to collect a bunch of rows

into a group. For my purposes, I usually include an empty row as my

first line and last line -- it make it a lot easier to insert

additional rows later if I so desire. I use this a lot for a "coding

notebook" -- snippets of code for VBA, PHP, or for stock screens, etc.

Didn't find what you were looking for?
Find more on Manually creating a row outline with no formula anywhere
Or get search suggestion and latest updates.

Related Topics:

- Populate Formula(Function) in rows
- How to detect formula where it is refrering same row
- Counting the rows If the next row value is same as the previous row
- Prime Nos
- Counting of Unique records from Repeative nos
- Delete Part of Row and move next Row Down Up
- Move data from a column of row couplets to multiple rows of colum
- Need help w/creating macro to delete rows
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- How to fold/unfold outline's level 1(or any level) in VBA?
- Using outline in excel
- VBA Formula prob
- Getting a formula to copy from inside VBA
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- R1C1 Formula
- Paste Formula help
- VBA or array formula?
- VBA code to add values in two cells which have formulas
- combining formula
- How to add several conditions for formula "SUMIF"
- formula help but not vba please
- Loop in formula
- Copy down formula with vba