Overclock.net › Forums › Software, Programming and Coding › Other Software › Grouping worksheets in Excel 2007?
New Posts  All Forums:Forum Nav:

Grouping worksheets in Excel 2007?

post #1 of 3
Thread Starter 
Hey guys,

I am trying to put a spreadsheet together, and I want to have groups of worksheets under a common tab, somewhat like organising folders (Music/1, 2, etc; Pictures/1, 2, etc)

Is there any way to do this? It'll make my life so much easier, I have ~60 worksheets to deal with but I want them all in one document.

I've had a quick poke around and couldn't find anything

Cheers!
LAF

EDIT: This seems to be confusing anyone I ask, basically I want "subsheets". Ie have one lot of information per sheet, but have them categorised while still having them all on the same workbook.
Edited by LAF - 4/7/11 at 4:46am
MiniCaptein
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 7700K MSI Z270I Gaming Pro Carbon AC mITX EVGA GTX980Ti SC+ 2x8GB G.Skill Ripjaws V 3200MHz 16-16-16-36 
Hard DriveHard DriveHard DriveCooling
120GB Samsung 840 EVO 500GB Samsung Spinpoint F3 (Storage) 2TB WD Caviar Black (Games) Corsair H80i 
OSMonitorKeyboardPower
Win7 Home Premium 64bit Dell U2711 2560x1440 60Hz Das Keyboard 4 Cherry Brown Seasonic X-Series 750W 
CaseMouseMouse Pad
Corsair Obsidian 250D Razer Taipan Razer Goliathus Fragged Extended Speed Edition 
  hide details  
Reply
MiniCaptein
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 7700K MSI Z270I Gaming Pro Carbon AC mITX EVGA GTX980Ti SC+ 2x8GB G.Skill Ripjaws V 3200MHz 16-16-16-36 
Hard DriveHard DriveHard DriveCooling
120GB Samsung 840 EVO 500GB Samsung Spinpoint F3 (Storage) 2TB WD Caviar Black (Games) Corsair H80i 
OSMonitorKeyboardPower
Win7 Home Premium 64bit Dell U2711 2560x1440 60Hz Das Keyboard 4 Cherry Brown Seasonic X-Series 750W 
CaseMouseMouse Pad
Corsair Obsidian 250D Razer Taipan Razer Goliathus Fragged Extended Speed Edition 
  hide details  
Reply
post #2 of 3
Not that I know of. Best you could do is apply a color to the tabs to color coordinate them... someone may know of a slick trick that I don't though. I'll be sub'd!
Paradise
(13 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II X6 1055T @ 3.7ghz Gigabyte GA-890GPA-UD3H XFX 5770 Crossfire 4x2GB G.Skill Ripjaws DDR3 1600 
Hard DriveOSMonitorKeyboard
64GB MC SSD, 2x320 7200.10, 2x2TB Green Caviar Windows 7 Ultimate Samsung 205BW & 32" Panasonic LCD G15 
PowerCaseMouse
Corsair HX620 (FTW) CoolerMaster HAF 932 MX518 
  hide details  
Reply
Paradise
(13 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II X6 1055T @ 3.7ghz Gigabyte GA-890GPA-UD3H XFX 5770 Crossfire 4x2GB G.Skill Ripjaws DDR3 1600 
Hard DriveOSMonitorKeyboard
64GB MC SSD, 2x320 7200.10, 2x2TB Green Caviar Windows 7 Ultimate Samsung 205BW & 32" Panasonic LCD G15 
PowerCaseMouse
Corsair HX620 (FTW) CoolerMaster HAF 932 MX518 
  hide details  
Reply
post #3 of 3
Thread Starter 
Alright well cheers anyway. I found that colour coding option, so maybe I will just have to do that

Mum showed me how she does it in OneNote, but I'm much happier using Excel
MiniCaptein
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 7700K MSI Z270I Gaming Pro Carbon AC mITX EVGA GTX980Ti SC+ 2x8GB G.Skill Ripjaws V 3200MHz 16-16-16-36 
Hard DriveHard DriveHard DriveCooling
120GB Samsung 840 EVO 500GB Samsung Spinpoint F3 (Storage) 2TB WD Caviar Black (Games) Corsair H80i 
OSMonitorKeyboardPower
Win7 Home Premium 64bit Dell U2711 2560x1440 60Hz Das Keyboard 4 Cherry Brown Seasonic X-Series 750W 
CaseMouseMouse Pad
Corsair Obsidian 250D Razer Taipan Razer Goliathus Fragged Extended Speed Edition 
  hide details  
Reply
MiniCaptein
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 7700K MSI Z270I Gaming Pro Carbon AC mITX EVGA GTX980Ti SC+ 2x8GB G.Skill Ripjaws V 3200MHz 16-16-16-36 
Hard DriveHard DriveHard DriveCooling
120GB Samsung 840 EVO 500GB Samsung Spinpoint F3 (Storage) 2TB WD Caviar Black (Games) Corsair H80i 
OSMonitorKeyboardPower
Win7 Home Premium 64bit Dell U2711 2560x1440 60Hz Das Keyboard 4 Cherry Brown Seasonic X-Series 750W 
CaseMouseMouse Pad
Corsair Obsidian 250D Razer Taipan Razer Goliathus Fragged Extended Speed Edition 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Grouping worksheets in Excel 2007?