Select cell by row & column names
I'd like to know if it is possible to select a cell by the header / row name?
I know I can select the number of working days using B2, but is there something more elegant like Days[Work] ?
A B C
1 Class Days
2 Work 220
3 Sick 5
microsoft-excel microsoft-excel-2010
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
add a comment |
I'd like to know if it is possible to select a cell by the header / row name?
I know I can select the number of working days using B2, but is there something more elegant like Days[Work] ?
A B C
1 Class Days
2 Work 220
3 Sick 5
microsoft-excel microsoft-excel-2010
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
For interest, see the wiki article on Lotus Improv, which was an attempt to base spreadsheet entry on this paradigm. Unfortunately, it didn't take off. en.wikipedia.org/wiki/Lotus_Improv
– Lord Peter
Nov 22 '12 at 12:32
@DaveRook no I know about named cells, but realistically I am working with tables, would be easier / cleaner.
– M Afifi
Nov 22 '12 at 12:42
add a comment |
I'd like to know if it is possible to select a cell by the header / row name?
I know I can select the number of working days using B2, but is there something more elegant like Days[Work] ?
A B C
1 Class Days
2 Work 220
3 Sick 5
microsoft-excel microsoft-excel-2010
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
I'd like to know if it is possible to select a cell by the header / row name?
I know I can select the number of working days using B2, but is there something more elegant like Days[Work] ?
A B C
1 Class Days
2 Work 220
3 Sick 5
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
asked Nov 22 '12 at 10:52
M AfifiM Afifi
12617
12617
For interest, see the wiki article on Lotus Improv, which was an attempt to base spreadsheet entry on this paradigm. Unfortunately, it didn't take off. en.wikipedia.org/wiki/Lotus_Improv
– Lord Peter
Nov 22 '12 at 12:32
@DaveRook no I know about named cells, but realistically I am working with tables, would be easier / cleaner.
– M Afifi
Nov 22 '12 at 12:42
add a comment |
For interest, see the wiki article on Lotus Improv, which was an attempt to base spreadsheet entry on this paradigm. Unfortunately, it didn't take off. en.wikipedia.org/wiki/Lotus_Improv
– Lord Peter
Nov 22 '12 at 12:32
@DaveRook no I know about named cells, but realistically I am working with tables, would be easier / cleaner.
– M Afifi
Nov 22 '12 at 12:42
For interest, see the wiki article on Lotus Improv, which was an attempt to base spreadsheet entry on this paradigm. Unfortunately, it didn't take off. en.wikipedia.org/wiki/Lotus_Improv
– Lord Peter
Nov 22 '12 at 12:32
For interest, see the wiki article on Lotus Improv, which was an attempt to base spreadsheet entry on this paradigm. Unfortunately, it didn't take off. en.wikipedia.org/wiki/Lotus_Improv
– Lord Peter
Nov 22 '12 at 12:32
@DaveRook no I know about named cells, but realistically I am working with tables, would be easier / cleaner.
– M Afifi
Nov 22 '12 at 12:42
@DaveRook no I know about named cells, but realistically I am working with tables, would be easier / cleaner.
– M Afifi
Nov 22 '12 at 12:42
add a comment |
2 Answers
2
active
oldest
votes
You can name a cell or a range.
Select a single cell or highlight a range of cells
Click into the box directly left of the formula bar which normally has the cell address (like A1). This box is called the “Name Box.”
Pick a name, type it in, then hit Enter (aka return) (Note: The name you select has to start with a letter or an underscore and no spaces are allowed)
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
add a comment |
You can select that cell by almost exactly that method, with a tiny bit of setup on your worksheet.
For Excel 2007 - 2010: you can convert the data into a Table. Select the range and from the Home tab choose Format as Table. Pick a style (you can change or remove this formatting later), verify the selected data and choose "My table has headers".
How you then reference that data point depends on how complex your table is. In an empty cell try typing = then clicking the cell you want to refer to. You will get a formula like
=Table1[@Days]
For older versions of Excel (and new ones too!): you can define range names for this data. This is as simple as selecting a range and typing in the name box which is found to the left of the formula bar. A more efficient way is to select the range and go to Formulas > Create from selection (shortcut CTRL SHIFT F3). This will create a whole stack of range names for you to play with. These can be browsed from the Name Manager dialogue. Usage could then be something like
=Sick
answered Nov 22 '12 at 11:04
GaryGary
32316
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%2f509150%2fselect-cell-by-row-column-names%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can name a cell or a range.
Select a single cell or highlight a range of cells
Click into the box directly left of the formula bar which normally has the cell address (like A1). This box is called the “Name Box.”
Pick a name, type it in, then hit Enter (aka return) (Note: The name you select has to start with a letter or an underscore and no spaces are allowed)
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
add a comment |
You can name a cell or a range.
Select a single cell or highlight a range of cells
Click into the box directly left of the formula bar which normally has the cell address (like A1). This box is called the “Name Box.”
Pick a name, type it in, then hit Enter (aka return) (Note: The name you select has to start with a letter or an underscore and no spaces are allowed)
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
add a comment |
You can name a cell or a range.
Select a single cell or highlight a range of cells
Click into the box directly left of the formula bar which normally has the cell address (like A1). This box is called the “Name Box.”
Pick a name, type it in, then hit Enter (aka return) (Note: The name you select has to start with a letter or an underscore and no spaces are allowed)
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
You can name a cell or a range.
Select a single cell or highlight a range of cells
Click into the box directly left of the formula bar which normally has the cell address (like A1). This box is called the “Name Box.”
Pick a name, type it in, then hit Enter (aka return) (Note: The name you select has to start with a letter or an underscore and no spaces are allowed)
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
answered Nov 22 '12 at 11:00
DaveDave
23.4k74363
23.4k74363
add a comment |
add a comment |
You can select that cell by almost exactly that method, with a tiny bit of setup on your worksheet.
For Excel 2007 - 2010: you can convert the data into a Table. Select the range and from the Home tab choose Format as Table. Pick a style (you can change or remove this formatting later), verify the selected data and choose "My table has headers".
How you then reference that data point depends on how complex your table is. In an empty cell try typing = then clicking the cell you want to refer to. You will get a formula like
=Table1[@Days]
For older versions of Excel (and new ones too!): you can define range names for this data. This is as simple as selecting a range and typing in the name box which is found to the left of the formula bar. A more efficient way is to select the range and go to Formulas > Create from selection (shortcut CTRL SHIFT F3). This will create a whole stack of range names for you to play with. These can be browsed from the Name Manager dialogue. Usage could then be something like
=Sick
answered Nov 22 '12 at 11:04
GaryGary
32316
add a comment |
You can select that cell by almost exactly that method, with a tiny bit of setup on your worksheet.
For Excel 2007 - 2010: you can convert the data into a Table. Select the range and from the Home tab choose Format as Table. Pick a style (you can change or remove this formatting later), verify the selected data and choose "My table has headers".
How you then reference that data point depends on how complex your table is. In an empty cell try typing = then clicking the cell you want to refer to. You will get a formula like
=Table1[@Days]
For older versions of Excel (and new ones too!): you can define range names for this data. This is as simple as selecting a range and typing in the name box which is found to the left of the formula bar. A more efficient way is to select the range and go to Formulas > Create from selection (shortcut CTRL SHIFT F3). This will create a whole stack of range names for you to play with. These can be browsed from the Name Manager dialogue. Usage could then be something like
=Sick
answered Nov 22 '12 at 11:04
GaryGary
32316
add a comment |
You can select that cell by almost exactly that method, with a tiny bit of setup on your worksheet.
For Excel 2007 - 2010: you can convert the data into a Table. Select the range and from the Home tab choose Format as Table. Pick a style (you can change or remove this formatting later), verify the selected data and choose "My table has headers".
How you then reference that data point depends on how complex your table is. In an empty cell try typing = then clicking the cell you want to refer to. You will get a formula like
=Table1[@Days]
For older versions of Excel (and new ones too!): you can define range names for this data. This is as simple as selecting a range and typing in the name box which is found to the left of the formula bar. A more efficient way is to select the range and go to Formulas > Create from selection (shortcut CTRL SHIFT F3). This will create a whole stack of range names for you to play with. These can be browsed from the Name Manager dialogue. Usage could then be something like
=Sick
answered Nov 22 '12 at 11:04
GaryGary
32316
You can select that cell by almost exactly that method, with a tiny bit of setup on your worksheet.
For Excel 2007 - 2010: you can convert the data into a Table. Select the range and from the Home tab choose Format as Table. Pick a style (you can change or remove this formatting later), verify the selected data and choose "My table has headers".
How you then reference that data point depends on how complex your table is. In an empty cell try typing = then clicking the cell you want to refer to. You will get a formula like
=Table1[@Days]
For older versions of Excel (and new ones too!): you can define range names for this data. This is as simple as selecting a range and typing in the name box which is found to the left of the formula bar. A more efficient way is to select the range and go to Formulas > Create from selection (shortcut CTRL SHIFT F3). This will create a whole stack of range names for you to play with. These can be browsed from the Name Manager dialogue. Usage could then be something like
=Sick
answered Nov 22 '12 at 11:04
GaryGary
32316
answered Nov 22 '12 at 11:04
GaryGary
32316
answered Nov 22 '12 at 11:04
GaryGary
32316
answered Nov 22 '12 at 11:04
GaryGary
32316
32316
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%2f509150%2fselect-cell-by-row-column-names%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
For interest, see the wiki article on Lotus Improv, which was an attempt to base spreadsheet entry on this paradigm. Unfortunately, it didn't take off. en.wikipedia.org/wiki/Lotus_Improv
– Lord Peter
Nov 22 '12 at 12:32
@DaveRook no I know about named cells, but realistically I am working with tables, would be easier / cleaner.
– M Afifi
Nov 22 '12 at 12:42