Some things i would like to see implemented in Excel

[Mightystomp]

I would like to be able to colourcode the tabs for sheets. In addition it would be nice to be able to group theese tabs.

 

[Richard Schollar]

There's a kind of workaround here.

Richard

 

[Mightystomp]

lol that one is nice. Still would like to see a easier way though.

 

[Von Pookie]

What version of Excel do you have? If you have 2002 or newer, you can change the color of the tabs easily--just right-click the tab and choose the "color" option.

 

[Greg Truby]

I would like to be able to colourcode the tabs for sheets.

In addition to von pookie's method, from the menu Format | Sheet | Tab Color...

In addition it would be nice to be able to group theese tabs.

If you mean be able to impact more than one sheet, then you can hold down your shift key and click a second tab to select two or more adjacent sheets. To select 2+ nonadjacent sheets hold down your Ctrl key while clicking tabs. To select all you r-click the tabs and pick "Select All Sheets" from the popup. When you have multiple sheets selected, if you right-click on the tab, the top option becomes "Ungroup Sheets". "Grouping" does not create a lasting "group" like you used to be able to do in Quattro Pro (if memory serves, it has been nine years since last I used Quattro); nor does it create a line below the tabs. It is a transient "selection" activity.

HTH

 

[DauntingGecko]

Sorry to hijack your thread, but I and many others here at work want an option to add more than one row or column at a time.

We want a box that will allow you to choose how many to insert rather than adding one at a time.

Any ideas?

 

[Mightystomp]

Oh noes I have been hijacked

You can add more than one row/column in Excel selecting more than one row/column and then pressing Ctrl and +. You could also rightclick and select "insert".


When it comes to the grouping of sheets I know how to select multiple sheets. What I wanted was a way to group sheets in the same way as group rows/columns works. i.e. hide/unhide subsheets.

 

[Greg Truby]

We want a box that will allow you to choose how many to insert rather than adding one at a time.
-DauntingGecko

That would only take a 1-line macro.

Sub InsertRows()
    ActiveCell.Resize(InputBox("How many rows do you want to insert", "Insert Rows", 2)).EntireRow.Insert
End Sub

Jus' toss it in yer personal WB, tie it to a custom button and yer done. But like mStomp said all's ya gotta do is just select x rows 'n' tap the Ctrl & + and it's done anyway.
<hr />

What I wanted was a way to group sheets in the same way as group rows/columns works. i.e. hide/unhide subsheets.
-MightyStomp

I can see where that might come in handy from time to time. You could probably do a work-around using custom buttons and VBA if you really, really wanted it. But always nicer to have such things built in.