Have you ever rotated a Revit view on your sheet? Those pesky View Titles rotate as well. Jordan shows us how to keep them horizontal on our sheets.
The problem; you rotated your view 90 degrees but you want your view title to stay horizontal.
Scroll down the list of families in the project and under Annotation there will be the family View Title. Right Click on it and say Edit.
In the Family Editor, save it as a new View Title so that you retain your current view title. Turn on the reference planes in the Visibility / Graphic Overrides, select all three items. Rotate these items opposite of what you think to offset the rotation of the view. So if you are rotating the view on the sheet 90 degrees counterclockwise, you have to create a view title with these three items rotated 90 degrees Clockwise. You are counteracting the rotation of the view on the sheet to keep the view title horizontal. Be sure to uncheck "Keep Readable" under the instance properties of the text labels or Revit will try to make the text read up the page, not down. When rotating the number and the titles 90 degrees clockwise, it will flip everything around trying to keep it legible.
Load the family into the project. Select your current View Title, click Edit Type, and duplicate. For the new one, name it appropriately and next to Title under graphics, select the new view title that you created. Be sure to uncheck Show Extension Line. If you would like a line to show between the View Title and the scale, you will need to draw your own in the Family.
The bad news, you will need to follow the same process for views rotated the other direction. The positive, the view scale and Detail Number are retained and you can let Revit manage those pieces of information.