A column is a vertical line of something within a program. It can be a column of cells in excel, or a column of text in a text editor or document. Columns are vertically positioned and are generally read top-to-bottom.
-1
votes
0answers
21 views
multiply cells in a column with results dragged horizontally in another sheet
I want to multiply a cell in 1 column by another cell lower down in the same column but have the answer come out on another sheet and I want to drag this formula horizontally so that the answers to ...
0
votes
1answer
26 views
Individual Columns Password Protected
Can individual columns be password protected for separate people, so that others can view information, but only change data in their column?
0
votes
3answers
45 views
Move every 7 columns into new row in Excel [duplicate]
I have a very large data set in Excel; all of the outcome scores are in a single column. I need these scores to be separated into rows so that every set of 7 scores (i.e., scores 2-8, 9-16, etc) are ...
0
votes
1answer
46 views
How to properly align text between table columns in Microsoft Word?
I'm working with a large table in Microsoft Word 2010. It's a pretty simple table, consisting of two colums.
In the left column, I have keywords. Those keywords are linked to a specification (portion ...
0
votes
2answers
44 views
Split text file by whitespace
I have a very large text file with multiple columns of data.
I.e.
1312.4123 asdkofADkofaO213 dakofasdjodas Fri Mar 2013 15:23:11
..
..
..
etc.
I wish to split this text file into multiple subsets, ...
0
votes
0answers
70 views
How to get new data to automatically slot into correct column in Excel?
I am trying to move new data into an existing database with set columns. The existing database has a column for every possible type of data, but not all new entries contain all columns. So I can't ...
1
vote
2answers
87 views
Column width option not available in specific worksheets in excel
Hallo dear Superuser members,
I have the following problem. I have a excel document with several worksheets. In the february worksheet I can adjust the column width option. I get the double sided ...
9
votes
1answer
157 views
How to display a single terminal in two columns?
When viewing a PDF on a wide screen monitor, the viewer can display two pages one next to the other. Is it possible to do something like this for a terminal window so that I can meaningfully utilize ...
1
vote
1answer
123 views
Excel singlecolumn to multiple columns based on values
I have 1 column like below:
AAA
999888
BBB
1111
BBB
2222
AAA
999777
BBB
3333
AAA
999666
BBB
4444
CCC
Doit
...
Consider above up to a few thousand rows.
I want to convert it to below 3 column table ...
2
votes
0answers
71 views
tmux - how-to enable automatic switching from 80 to 132 columns and back
Currently in our terminal based accounting system, clients mostly use putty (0.61) and when a report is viewed in the terminal, an escape code is issued that kicks the screen from 80 to 132 columns if ...
1
vote
1answer
63 views
Removing “snap to column” in Excel 2007
I have a column in Excel 2007 whose width is set to 200. This means that it is longer than the width of my screen. If I scroll the worksheet from left to right, it will move column by column, which ...
0
votes
3answers
84 views
Calculating a sum on an integer column when another column includes the year criteria for the calculation
I have a spreadsheet where the columns contain values as follows:
Column(A) B C D E
NameA 01/02/2010 5 4 5
NameB 05/06/2011 4 3 ...
1
vote
1answer
64 views
Sort columns next to last column in Linux
I have multiple files:
File 1
a 1 2
b 3 2
File 2
a 2 2 3
b 4 3 3
File 3
d 3 1 2 4
e 4 1 1 2
I'd like to sort the files according to the column next to the last column, after sort:
File 1
...
0
votes
1answer
74 views
how to get column markers with free text editors
Can someone please provide some tips on getting column markers to show (vertical lines) when viewing text files with fixed width column based data. (not csv). Notepad++, wordpad any freebie will do. ...
1
vote
3answers
182 views
Terminal pager: How to display a list in columns?
I'm sure it's very simple, but I can't remember how to tell a terminal pager (more/less/pg/most) to display a long list in columns.
Since my input is just a list of short elements, displaying it the ...
1
vote
2answers
68 views
MS Excel: How to work with a column chosen by value in header (row1)
I am importing a large dataset from a website and I want to build some summary stats on a new sheet. The column order is not fixed, so I want to be able to (for example) count all the cells with the ...
1
vote
1answer
147 views
Mac Excel 2011: find Items in one column that are not in another column
Hi this is a repeat of the question: Excel: Find Items in one column that are not in another column
I have two columns in excel, and I want to find (preferably highlight) the items that are in ...
-2
votes
1answer
52 views
Automatically go to next row when certain number of characters is entered
I am creating an Excel sheet where there is a comments section where the column width is 58 characters.
Is it possible for someone putting in comments to have it automatically go to the next row ...
1
vote
1answer
274 views
How do you add Dimension columns in all folders on a Mac?
On my MacBook Pro 17" running Mountain Lion, in Finder I can go to the Pictures (and Movies) folder and, in column view, I can right click on the head of the columns and add 'Dimensions'. The problem ...
1
vote
1answer
510 views
Sorting two non-adjacent columns without affecting any other column
I have two different columns on Excel.
I want to create a script that will sort Column F, (Have a header) and will sort Column B based on where Column F's sort worked out. (Without affecting any ...
0
votes
0answers
62 views
How to create a text file from column and FTP that text file to server
I don't know much about VB and need to do the following tasks.
My question in short is "How to create a text file from a excel sheet column and FTP that text file to a server?"
Situation:
I have ...
0
votes
1answer
65 views
Column break in word - continously
Masters,
I need to PASTE my content in two different column in word. (I have 300 page of old content and 300 page of new content, i want to share my partners this information side by side to compare)
...
3
votes
1answer
553 views
How do I make Visio header rows behave like Excel header rows?
A few times when I was working in Excel with documents that had large amounts of data, as you scroll down, the header (first cell in the column) stayed visible. I don't remember telling it to do this, ...
2
votes
1answer
2k views
How to make a table span two columns?
I am making a two column document, but I have a large table that I want to make span the columns. How can I do this in Microsoft Word?
................................
TABLE
...
0
votes
1answer
178 views
Registry (possibly) error in Windows 7 : I can not resize columns in any program except explorer
I experimented with Winbuilder and after some time I noticed that
I cannot resize columns in uTorrent, move bookmarks and bookmark folders in Chrome,
then cannot resize columns in Comodo Programs ...
2
votes
2answers
7k views
How to merge two Excel columns into one?
Let's say we have two columns/ranges A1:A10 (group A) and B5:B50 (group B) and we need to merge the two into one column in C1:C60 (60 in C = 10 from A + 50 from B)
Data in group A & group B can ...
1
vote
0answers
136 views
format stdout as multicolumn text
I'm trying to take some single column data and display it in a tty as columns, much like ls does. Basically, you can think of this as trying to take the output from ls -1 and make it look like the ...
1
vote
0answers
45 views
Can I add a “tag” column to music files and “fill down” to enter the info for it
I want to add a column to Windows Explorer (in Windows 7) such as "Tag" and then fill in the data for that column by some sort of fill down technique (as in Excel) instead of adding info one file at a ...
0
votes
1answer
574 views
Creating a column of working days in LibreOffice Calc
In LibreOffice Calc, I would like to create a column of working days, for example:
[...]
2012-01-30 [Monday]
2012-01-27
2012-01-26
2012-01-25
2012-01-24
2012-01-23 [Monday]
2012-01-20
2012-01-19
...
3
votes
3answers
13k views
Use two columns in Microsoft Word separately
I want to do a two-column layout in Microsoft Word, but instead of the second column being written as a continuation of the first, I want the two columns to be written separately just like they were ...
1
vote
3answers
5k views
How do I separate a comma-separated list into two columns in excel?
I have a long, comma-separated list which looks like this in excel:
401.50,0.027
402.00,0.028
402.50,0.029
403.00,0.031
403.50,0.032
404.00,0.034
404.50,0.037
Is there a simple way to ...
0
votes
1answer
33 views
How to make something like that with columns in MS Word 07
It's following after this question: How do I create multi-line tabulations in Microsoft Word 2007?
I was told that I should make it with tables or columns. Yes I can make with tables but will it be ...
0
votes
2answers
150 views
Efficiently stripe incoming one-word lines onto columns?
Consider a stream of one-word lines such as the stdout of
$ echo foo bar baz quux xyxxy thud | tr ' ' '\n'
foo
bar
baz
quux
xyxxy
thud
I say "one-word" to indicate there is no whitespace other than ...
2
votes
1answer
163 views
Add 0's to values in column in Excel? [duplicate]
Possible Duplicate:
How do you add zero before values in excel document?
I am trying to edit product codes in Excel so that each product code is exactly 8 digits in length.
Currently the ...
5
votes
2answers
813 views
How can I set gvim's window width to 80 columns of text, plus the ones needed to show the line number
I use gvim with
set number
in my .vimrc so it shows the linenumber, plus a space, before every line.
If the document has less than 10 lines, this takes 2 columns, If it has more than 10, 3 ...
2
votes
1answer
414 views
Changing the order of columns displayed with `ls`
Is it possible to change the order of displayed columns when running ls -l on *nix (or dir on Windows)?
For example, I'd like to see the date modified, then the name, then other fields (or select ...
2
votes
1answer
3k views
Word 2010, Multiple Columns, Vertical center one column only
I am creating a document with two columns in Microsoft Word 2010. I want the first column to be centered vertically. I want the second column to be on the same page and the vertical placement to be ...
0
votes
3answers
504 views
Selecting all data in Excel column regardless of size
I have a repetitive process that I must do in Excel for test data collected. I have to do this process for every data point I collect. I collect over 200 data points each test.
My data is auto ...
4
votes
3answers
748 views
How can I automatically adjust the Gvim/MacVim window to the width of my vertical splits?
My overall goal here is simple, but the specifics are complex:
I want to maintain each vertical split in my MacVim window at exactly 115 columns, regardless of how many splits I add.
The story: I’m ...
1
vote
4answers
2k views
Excel 2007: “Format as Table” Increments Column Names
I love using the formatting styles for tables in Excel 2007, but in my data I'm using the same column name for multiple columns. When I format my table using the pre-defined styles, it automatically ...
1
vote
3answers
2k views
How can I compare columns in Excel?
If I have two columns of data with 10000 cells in each, and only three of the rows are not identical in both columns, how can I locate the different ones (without comparing each pair of cells)?
0
votes
1answer
109 views
Creating columns in OpenOffice.org Writer [duplicate]
Possible Duplicate:
How can I do two columns in OpenOffice.org Writer?
How do I create two columns in OpenOffice.org Writer so that I can type in and easily move back and forth between the ...
1
vote
2answers
3k views
Splitting concatenated Excel columns at spaces?
An application that I use generates data in the form of a text file, with the values separated by spaces. When I load this into Excel, a column of data I'd like to extract is melded to several other ...
14
votes
1answer
1k views
How to restore the Process Name column in Process Explorer?
Currently, Process Explorer's window does not show the process name:
(When I run Process Explorer as another user, the column displays correctly.)
I have tried dragging all the column handlers, ...
2
votes
2answers
1k views
Summing a column in the same column without a circular reference
In Excel you can sum a whole column with =SUM(B:B). But of course you can't use that formula in the column you want to sum, because you'll get a circular reference.
Is there an easy way of summing ...
18
votes
3answers
25k views
Howto expand all columns in Excel spreadsheet?
I have a spreadsheet with many columns. The columns are all a small standard width. Double-clicking the partition line between columns will expand the column width to encompass the longest string in ...
1
vote
2answers
40 views
2
votes
2answers
2k views
Excel row-wise multiplication
I would like to multiply, row-by-row, two columns in an Excel sheet (in order to take the median of the resulting column).
1 3
2 5
4 2
Should become
3
10
8
How can I do that in a formula ...
1
vote
2answers
10k views
Merge table columns in Word 2003 or Word 2010
How can I merge two table columns in Word 2003 or Word 2010?
4
votes
1answer
2k views
Change the format of the date column in Thunderbird
I want to change the format of the "Date"-column in the messagelist in Thunderbird.
For mails from today, I want to display only the time, not the date.
For mails from before today, I want to ...
