Questions tagged [column]
The column tag has no usage guidance.
21
questions with no upvoted or accepted answers
2
votes
0
answers
81
views
How can I set the column width on a given column in multiple opened Excel files at once?
I have 10 opened Excel files. Each of them contains one spreadsheet. How can I set the column width on a given column in multiple opened Excel files at once? I use Excel 2205 on Microsoft Windows 10.
1
vote
0
answers
64
views
How create increment column in visidata from a set value, not for 1?
If I have I frame with 10 rows, and I create a new column with za and then use gi I get a range column from 1 to 10, but instead of that I want to get a range column from 15 to 25.
How can I get that?
1
vote
1
answer
517
views
Excel Pivot Table - Change Columns using Filter
I have a pivot table and values separated by a signal flag (0 or 1). I many different signal types (columns) to use.
Question: Instead of creating a new pivot table for each signal, is there a '...
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 ...
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
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.
...
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 ...
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 ...
0
votes
0
answers
123
views
What is the strongest means to force MS Word to not underrun a minimum table column width
As is generally known, desired column widths in a Word table can be set in the table properties individually for each column in centimeters or percent:
However, experience shows that Word does not ...
0
votes
1
answer
57
views
highlight row with different colors after date is entered in different column cells
We have a spreadsheet that tracks items by date in different columns. Item sent in column L, we would like it to be one color. but once the second date in entered column R. I am needing the row to ...
0
votes
0
answers
61
views
How to fill a column getting a substring of another one with a rule
I'm trying to play with the functions LEFT, RIGHT and SEARCH to fill a column with the name of a function extracted from another column, but I don't get any good result.
I have a list of functions ...
0
votes
1
answer
104
views
Why doesn't the left column come down in ms word 2016?
I want the left column to be full.
Why does the left column not come down? Any Suggestions?