Align header with cells whose text is oriented at an angleAlign text boxes in Adobe Acrobat Pro XIReferencing...
Intersection of two sorted vectors in C++
Why are electrically insulating heatsinks so rare? Is it just cost?
Fully-Firstable Anagram Sets
Would Slavery Reparations be considered Bills of Attainder and hence Illegal?
Forgetting the musical notes while performing in concert
How to draw the figure with four pentagons?
Is there a hemisphere-neutral way of specifying a season?
Do I have a twin with permutated remainders?
I would say: "You are another teacher", but she is a woman and I am a man
Can a virus destroy the BIOS of a modern computer?
Assassin's bullet with mercury
Infinite Abelian subgroup of infinite non Abelian group example
If human space travel is limited by the G force vulnerability, is there a way to counter G forces?
In a Spin are Both Wings Stalled?
Does a druid starting with a bow start with no arrows?
SSH "lag" in LAN on some machines, mixed distros
A reference to a well-known characterization of scattered compact spaces
If a Gelatinous Cube takes up the entire space of a Pit Trap, what happens when a creature falls into the trap but succeeds on the saving throw?
Took a trip to a parallel universe, need help deciphering
Where does SFDX store details about scratch orgs?
Arrow those variables!
Doing something right before you need it - expression for this?
How can I make my BBEG immortal short of making them a Lich or Vampire?
When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?
Align header with cells whose text is oriented at an angle
Align text boxes in Adobe Acrobat Pro XIReferencing a cell in Excel using values from other cells in different worksheet (tab)How to give worksheet tab a color if range of cells contains textalign column with text and numbersHow can I 'align right' the results of Excel's “Text to Columns” feature?Align rows from different columns (which contain some cells that have identical values) using simple formula in ExcelHow to group range of conditional formatting with color scales by category?weird “number in text format” behaviorAuto-update Excel cell size in response to dynamic contentExcel, Return a color depending on two other cells text
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" headers are not aligned at all with the "category" cells under them.
microsoft-excel microsoft-excel-2010 cells alignment orientation
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
add a comment |
Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" headers are not aligned at all with the "category" cells under them.
microsoft-excel microsoft-excel-2010 cells alignment orientation
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
Merge the cells above where you want it to go and center it?
– Raystafarian
Oct 1 '14 at 10:42
That will go out of alignment as soon as the height of the row with the tilted text changes. Not to mention that the cell colour won't align nicely regardless (admittedly that is a secondary concern).
– Jean-François Corbett
Oct 1 '14 at 11:03
I always prefer "Center across selection" to merging cells. Have you trie that @Jean-FrançoisCorbett? select all the cells above your headers and format them in the color you need and select "Center across selection" in the horizontal alignment dropdown
– CallumDA
Oct 1 '14 at 12:05
from what I know, there is no automated way to do it. If you really want his layout you will have to perform some manual adjustment for Benefits row. Alternatively you can just switch the two rows, not what you asked for but conveys the same information clearly
– Joop
Oct 1 '14 at 12:13
add a comment |
Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" headers are not aligned at all with the "category" cells under them.
microsoft-excel microsoft-excel-2010 cells alignment orientation
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" headers are not aligned at all with the "category" cells under them.
microsoft-excel microsoft-excel-2010 cells alignment orientation
microsoft-excel microsoft-excel-2010 cells alignment orientation
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
asked Oct 1 '14 at 9:23
Jean-François CorbettJean-François Corbett
1,96931626
1,96931626
Merge the cells above where you want it to go and center it?
– Raystafarian
Oct 1 '14 at 10:42
That will go out of alignment as soon as the height of the row with the tilted text changes. Not to mention that the cell colour won't align nicely regardless (admittedly that is a secondary concern).
– Jean-François Corbett
Oct 1 '14 at 11:03
I always prefer "Center across selection" to merging cells. Have you trie that @Jean-FrançoisCorbett? select all the cells above your headers and format them in the color you need and select "Center across selection" in the horizontal alignment dropdown
– CallumDA
Oct 1 '14 at 12:05
from what I know, there is no automated way to do it. If you really want his layout you will have to perform some manual adjustment for Benefits row. Alternatively you can just switch the two rows, not what you asked for but conveys the same information clearly
– Joop
Oct 1 '14 at 12:13
add a comment |
Merge the cells above where you want it to go and center it?
– Raystafarian
Oct 1 '14 at 10:42
That will go out of alignment as soon as the height of the row with the tilted text changes. Not to mention that the cell colour won't align nicely regardless (admittedly that is a secondary concern).
– Jean-François Corbett
Oct 1 '14 at 11:03
I always prefer "Center across selection" to merging cells. Have you trie that @Jean-FrançoisCorbett? select all the cells above your headers and format them in the color you need and select "Center across selection" in the horizontal alignment dropdown
– CallumDA
Oct 1 '14 at 12:05
from what I know, there is no automated way to do it. If you really want his layout you will have to perform some manual adjustment for Benefits row. Alternatively you can just switch the two rows, not what you asked for but conveys the same information clearly
– Joop
Oct 1 '14 at 12:13
Merge the cells above where you want it to go and center it?
– Raystafarian
Oct 1 '14 at 10:42
Merge the cells above where you want it to go and center it?
– Raystafarian
Oct 1 '14 at 10:42
That will go out of alignment as soon as the height of the row with the tilted text changes. Not to mention that the cell colour won't align nicely regardless (admittedly that is a secondary concern).
– Jean-François Corbett
Oct 1 '14 at 11:03
That will go out of alignment as soon as the height of the row with the tilted text changes. Not to mention that the cell colour won't align nicely regardless (admittedly that is a secondary concern).
– Jean-François Corbett
Oct 1 '14 at 11:03
I always prefer "Center across selection" to merging cells. Have you trie that @Jean-FrançoisCorbett? select all the cells above your headers and format them in the color you need and select "Center across selection" in the horizontal alignment dropdown
– CallumDA
Oct 1 '14 at 12:05
I always prefer "Center across selection" to merging cells. Have you trie that @Jean-FrançoisCorbett? select all the cells above your headers and format them in the color you need and select "Center across selection" in the horizontal alignment dropdown
– CallumDA
Oct 1 '14 at 12:05
from what I know, there is no automated way to do it. If you really want his layout you will have to perform some manual adjustment for Benefits row. Alternatively you can just switch the two rows, not what you asked for but conveys the same information clearly
– Joop
Oct 1 '14 at 12:13
from what I know, there is no automated way to do it. If you really want his layout you will have to perform some manual adjustment for Benefits row. Alternatively you can just switch the two rows, not what you asked for but conveys the same information clearly
– Joop
Oct 1 '14 at 12:13
add a comment |
1 Answer
1
active
oldest
votes
Excel doesn't appear to have an easy way to use cell and border formatting to do what you are looking for. Only thing I could find was to no use the angle so they line up.
An alternate to that would be to insert a text box sized and formatted as you desire to fit the top of the angled headers. You can add a text box from the Insert tab, Text group.
You can then resize and format the text box as you wish.
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f819154%2falign-header-with-cells-whose-text-is-oriented-at-an-angle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Excel doesn't appear to have an easy way to use cell and border formatting to do what you are looking for. Only thing I could find was to no use the angle so they line up.
An alternate to that would be to insert a text box sized and formatted as you desire to fit the top of the angled headers. You can add a text box from the Insert tab, Text group.
You can then resize and format the text box as you wish.
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
add a comment |
Excel doesn't appear to have an easy way to use cell and border formatting to do what you are looking for. Only thing I could find was to no use the angle so they line up.
An alternate to that would be to insert a text box sized and formatted as you desire to fit the top of the angled headers. You can add a text box from the Insert tab, Text group.
You can then resize and format the text box as you wish.
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
add a comment |
Excel doesn't appear to have an easy way to use cell and border formatting to do what you are looking for. Only thing I could find was to no use the angle so they line up.
An alternate to that would be to insert a text box sized and formatted as you desire to fit the top of the angled headers. You can add a text box from the Insert tab, Text group.
You can then resize and format the text box as you wish.
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
Excel doesn't appear to have an easy way to use cell and border formatting to do what you are looking for. Only thing I could find was to no use the angle so they line up.
An alternate to that would be to insert a text box sized and formatted as you desire to fit the top of the angled headers. You can add a text box from the Insert tab, Text group.
You can then resize and format the text box as you wish.
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
answered Oct 1 '14 at 12:32
CharlieRBCharlieRB
20.6k44493
20.6k44493
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f819154%2falign-header-with-cells-whose-text-is-oriented-at-an-angle%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Merge the cells above where you want it to go and center it?
– Raystafarian
Oct 1 '14 at 10:42
That will go out of alignment as soon as the height of the row with the tilted text changes. Not to mention that the cell colour won't align nicely regardless (admittedly that is a secondary concern).
– Jean-François Corbett
Oct 1 '14 at 11:03
I always prefer "Center across selection" to merging cells. Have you trie that @Jean-FrançoisCorbett? select all the cells above your headers and format them in the color you need and select "Center across selection" in the horizontal alignment dropdown
– CallumDA
Oct 1 '14 at 12:05
from what I know, there is no automated way to do it. If you really want his layout you will have to perform some manual adjustment for Benefits row. Alternatively you can just switch the two rows, not what you asked for but conveys the same information clearly
– Joop
Oct 1 '14 at 12:13