Simon Patenaude
New Member
Hey all,
I have a sheet to record all the network switches we have in our facility. This sheet is 5 columns wide.
Columns "$A$1:$E$1":
Device|Port|IP Address|Password|Device Location
I have set this row as "rows to repeat at top" under page setup. That was the easy part.
Row A2:E2, A50:E50, A66:E66 (and others) contains:
Switch name|location|IP range|gateway.
Also note that i did not use $ as these rows may change as i enter or delete data from the spreadsheet.
As I scroll I want A1:E1 to always remain on top, however I want A2:E2, A50:E50 and A66:E66 to display under the top row when looking at the relevant information.
I have looked all over for this feature, however i can't find exactly what i'm looking for. Perhaps I'm not asking the right questions.
Can this be done with multiple print areas? can i do this with pivot tables? I want this to be as simple as possible since multiple people will be using this sheet.
Thank you,
Simon
I have a sheet to record all the network switches we have in our facility. This sheet is 5 columns wide.
Columns "$A$1:$E$1":
Device|Port|IP Address|Password|Device Location
I have set this row as "rows to repeat at top" under page setup. That was the easy part.
Row A2:E2, A50:E50, A66:E66 (and others) contains:
Switch name|location|IP range|gateway.
Also note that i did not use $ as these rows may change as i enter or delete data from the spreadsheet.
As I scroll I want A1:E1 to always remain on top, however I want A2:E2, A50:E50 and A66:E66 to display under the top row when looking at the relevant information.
I have looked all over for this feature, however i can't find exactly what i'm looking for. Perhaps I'm not asking the right questions.
Can this be done with multiple print areas? can i do this with pivot tables? I want this to be as simple as possible since multiple people will be using this sheet.
Thank you,
Simon