Questions tagged [column]
The column tag has no usage guidance.
45
questions
0
votes
0
answers
53
views
Excel Discrete column-wise selection from area
I'd like to be able to select an area column-wise (as individual columns). Manually holding down CTRL works fine for a few columns but when you've got 200 to select it becomes tedious. I'd like to be ...
1
vote
1
answer
44
views
How do I indicate nested data groups side-by-side in an Excel stacked column chart?
I am preparing a chart for an academic journal and am struggling with formatting.
In the original chart I am trying to reproduce, nested data for two year periods, 2017 and 2020/21, are displayed ...
0
votes
0
answers
49
views
Excel Sortby formula on alpha numerics e.g. A1 to A100 to return 4 rows of associated data
I have used this formula to sort the column A1 to A100 so that A
=SORTBY(A1:A206,COLUMN(INDIRECT(A1:A206)),1,ROW(INDIRECT(A1:A206)),1)
thanks to one of your posts: Advanced sorting of alphanumeric ...
0
votes
2
answers
100
views
MS Excel Convert column data into row
I have all data in a column in MS excel.
Please see the attached picture: .
I am trying to covert data with its corresponding heading and other data associated with its "Acct No.". as sample ...
0
votes
1
answer
33
views
MS Outlook Sortable User-defined Columns
In response to the question "How do I get rid of the "External" label in Outlook?", user Lilienthal posted a response on Jan 20, 2023 by creating a custom column using the formula ...
0
votes
0
answers
71
views
column -x: how to specify the number of columns?
For column -x, how to specify the number of columns (say, 4)?
Is it possible at all?
Extra: from man column:
-x, --fillrows
Fill rows before filling columns.
0
votes
1
answer
528
views
Windows Explorer: change default columns of the media-variant set of columns (photos, videos...)
When a folder contains photos and videos, explorer switches automatically which columns are displayed. I'm not questioning here whether I like the feature or not, so let's assume I liked that feature.
...
2
votes
1
answer
506
views
How to create a stacked column chart where each category has unrelated subcategories
I have the following set of data
I want to create a column chart with 3 stacked columns(one for each category). The sum of amounts for each category equals 100. The issue I'm having is that the ...
0
votes
0
answers
26
views
Word: Autonumbering IF other column not empty
I am at a little loss currently.
I simply want word (MacOSX) to auto number in column two (See picture attached) if there is text in column three.
My Table is basically one line with four columns ...
0
votes
0
answers
48
views
How do I extract a single list of 3D spatial coordinates across 2 different sheets that link the 3 cartesian planes?
I am using Excel to draw an ellipsoid that is rotated by 15 degrees. What I want is not a 3D plot of it, but I want to get a list of all the coordinates that share a certain criteria. An example is ...
1
vote
0
answers
29
views
How to add additional column types in Windows Explorer's column quick menu permanently? [duplicate]
I want to add some useful column types in the quick menu of Windows Explorer to not go through very long and bothersome process of scrolling through thousands of types in Choose Details window.
I want ...
0
votes
1
answer
51
views
Excel Formula that copys Column Title based off related data within row
I am looking for a formula to represent what is in the highlighted section of the excel sheet. For example, for invoice 4/1/2022, i would like a formula for "payable for" that lists (1)...
0
votes
0
answers
254
views
Different text column shading in MS Word
I'm trying to shade columns in different colors but just can't make it.
It's either that last line of one column is part of the next paragraph, so it picks up the color of the next column:
Or it's ...
2
votes
2
answers
3k
views
How to tell Outlook not to auto resize the columns of a table
I'm having a very frustrating experience with MS-Outlook, while creating a table inside an e-mail:
I have some text, separated by pipe characters, and I've chosen the "Convert text to table" ...
0
votes
1
answer
319
views
How do I use a cell reference as a column in a table reference?
Say I have a table "Data" (created with the "Format as table" button, with headers). In another table (say "Table"), I have a column ("Target column") that has ...