Questions about spreadsheet software in general and interoperability between spreadsheet programs.

**10**

votes

**1**answer

20k views

### How to sort an Excel spreadsheet columns by row contents?

How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...

**0**

votes

**1**answer

170 views

### Make a differentiated barchart using numbers

I have a question about Numbers.
I want to make a bar chart that shows the membership of my organisation.
I want to divide between unitary organisations and membership organisations, so i want ...

**1**

vote

**1**answer

256 views

### How to sum the multiplications of rows, being the multiplier variable in a spreadsheet

I have this spreadsheet:
I want to calculate the total income, but since the different rows are in different currencies the conversion must be done first. The currency values are mapped to codes in ...

**0**

votes

**0**answers

38 views

### Chart from groupings

Given such a spreadsheet:
col1 | col2 | col3
-----+------+----
alfa | foo | 10
beta | foo | 20
gamma| bar | 12
delta| bar | 42
I'd like to generate a chart grouping values from col2 and ...

**6**

votes

**1**answer

268 views

### Swap rows in gnumeric

Is there any convenient way to swap two rows in gnumeric? Currently I'm doing it the hard way: insert an empty row, move rows, and remove empty row. I hope that there is a better way...

**0**

votes

**1**answer

88 views

### Add another worksheet in an Excel worksheet

Is it possible to include an additional set of worksheets (i.e. "tabs") into an already existing worksheet in Excel?

**3**

votes

**3**answers

3k views

### Adding a constant in LibreOffice Calc

How do you add a constant to a group of cells in LibreOffice Calc?
For example, here are four cells:
47 28 35 62
Now add 3 to each cell:
50 31 38 65

**1**

vote

**1**answer

131 views

### Not showing negative results in Numbers.app

How can I make iWork Numbers not show me negative results?
For example: The thing is that in A1 I have number 101 and I am doing -A1 from B1. B1 is empty (because I am waiting for the result) so in ...

**0**

votes

**5**answers

1k views

### Good tools to visualize spreadsheets?

I have a few CSV and XLS files that I would like to analyse or "visualize" online (like in charts etc).
I tried Google Fusion Tables, but I want to know if there are any alternatives.
Also suggest ...

**0**

votes

**2**answers

400 views

### Excel Pivot Table or VLOOKUP

Students have an ID, Name, and English Level in one spreadsheet. They have an ID and achievement on a standardized test on another spreadsheet.
I need to match the ID's and put the English level ...

**1**

vote

**2**answers

580 views

### Image file to spreadsheet

I want to take an image file (eg tiff) and convert it to a spreadsheet (csv, or whatever) such that each pixel becomes a cell with a numeric value for that pixel.
I have googled it, and everyone is ...

**2**

votes

**1**answer

585 views

### Copy only cell content in OOCalc

In OOCalc, when I copy a cell with ctrl-c ctrl-v, it copies everything, also the style, from source to destination.
However, I want to copy only the content, leaving the formatting of the destination ...

**2**

votes

**1**answer

5k views

### How to conditionally highlight cells in OpenOffice Calc?

I have a big chunk of data in an OpenOffice spreadsheet. To make real information standout more, I would like cells with an absolute value over a certain threshold to be highlighted in red.
Is there ...

**0**

votes

**1**answer

182 views

### Software to calculate average payments of the house

I want to calculate average payment of the house for every month, the average expense of each month. However, most of the fee is across months, they charge every 3 or 2 months. These are normal bills, ...

**5**

votes

**8**answers

3k views

### Excel spreadsheet bogged down, Is there an alternative software?

I work for an organization with a yearly budget that is an Excel spreadsheet consisting of about 25 large sheets that are linked to one another. There is a big summary sheet that draws it's numbers ...

**0**

votes

**2**answers

1k views

### How to add a line between every two rows in a spread sheet?

I was wondering in Openoffice Calc spreadsheet, how to add a line between every two rows? I want to print a spreadsheet, with a line separating every two rows.
Thanks and regards!

**0**

votes

**1**answer

6k views

### Excel formula to find frequency of occurrence of unique words in a column

I have a spreadsheet with a column with repeating number of different kinds of words like
A1
A2
A3
A1
AA
A2
A7
A8
A1
Now I want to plot a graph showing the frequency of occurrences of a word. The ...

**0**

votes

**3**answers

130 views

### Re-ordering data in a cell in spreadsheet

I have an Excel spreadsheet where data is time stamped, but the time stamp is as follows (in one cell):
Fri Mar 11
If it was 11 Mar Fri, the data would be easier to sort. How do I change the ...

**1**

vote

**3**answers

188 views

### Excel plot chart from data as given in the example

I have a huge spreadsheet with simple data as follows
13:04:28 A
13:04:37 A
13:06:56 B
13:07:03 B
13:07:10 C
13:07:18 C
13:07:23 C
13:07:28 C
13:07:33 C
Basically ...

**3**

votes

**2**answers

429 views

### How do I access the search functionality in Open Office?

I am very new to oo and plodding slowly; never used a spreadsheet, etc.etc.
I downloaded a document of botanical names for flowers/herbs, etc. The page was set in 3 columns and was 138 pages long (!) ...

**4**

votes

**1**answer

779 views

### Edit spreadsheet object in Word document with protection

I am trying to create a template in Word to be used on a SharePoint site. Using Word 2003, is there a way to enable protection on a document that has an Excel Spreadsheet (97-2003) object on it but ...

**0**

votes

**1**answer

420 views

### Excel filter by range

I am setting up a workout schedule. I have multiple rows with workout times, who is instructing the class, and who the class is suitable for. The suitable is a range, based on the following (anyone ...

**0**

votes

**3**answers

842 views

### Do multiple e-mail addresses need to be separated by a comma?

In CSV format, in an Excel spreadsheet or in a Word document, both having multiple email addresses with each address being in its own row and in a single column, is a comma REQUIRED after each ...

**20**

votes

**5**answers

63k views

### How to create a formula for every row in a column in Google SpreadSheet?

I use three columns. A, B and C.
In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2.
How can I do so I don't have to type in the new formula in ...

**1**

vote

**2**answers

1k views

### Data validation - populating a drop down menu using a defined name

I am using data validation to create a drop down list on a worksheet. What I'd like to be able to do is set up a list of values as a defined name (Insert > Name > Define...) and then enter that ...

**1**

vote

**1**answer

5k views

### How do I count the times each number appears in columns of numbers?

I am sure this must be easy, but I am inexperienced. About the best way to think of my problem is to think of it as trying to sort and then count lottery numbers. To stay simple, let's do a Pick 3 ...

**2**

votes

**1**answer

1k views

### Quick/Small Spreadsheet Software

There is some minimalist spreadsheet (excel-like) software? I imagine something like NotePad (small and quick) just to write some tabular data quickly. No toolbars, no font formatting, not "a lot" of ...

**1**

vote

**2**answers

8k views

### Big Excel File Freezing/Running Slowly

My co-worker has a very large Excel file (over 7 MB) that suffers from the problems of (A) running slowly (B) taking forever to open/save/close and (C) freezing the computer, requiring a restart.
I ...

**1**

vote

**3**answers

4k views

### Combine 3 columns into one in Excel 2011 for Mac

I am trying to manipulate a bunch of string elements I have put in columns in Excel. I then filled the preceding column with data, and then the following column as well. Now I want to delete the ...

**3**

votes

**1**answer

1k views

### Open Source Spreadsheet with Sensitivity Analysis

Is there any good Open Source spreadsheet program that has a solver for linear programs (either included or via an extension) that does a proper sensitivity analysis (shadow prices etc)? It seems like ...

**4**

votes

**4**answers

914 views

### Spreadsheet forumula questions to pick a random DVD

I have a list of my (279) DVD’s in an OpenOffice Spreadsheet (version 3.3.0) on my Windows 7 laptop and I want to create a formula to randomly pick a film to watch (for occasions when I can’t make up ...

**4**

votes

**1**answer

799 views

### Custom CSV (.csv) filter for OpenOffice.org or LibreOffice?

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and ...

**1**

vote

**6**answers

19k views

### In Excel, copying cell *values* (not formulas)… yet keeping the cell formats

I have an Excel spreadsheet with multiple worksheet tabs for collecting data... and a final tab with a lot of formulas, to summarize the other tabs for a given date range.
The goal is for the ...

**2**

votes

**1**answer

2k views

### In Excel, doing a “Freeze Panes” on the right-most column instead of the left-most?

My understanding of Excel's "Freeze Panes" feature is that you can only freeze the left-most column(s), or top-most row(s).
However, I have a table where a very important column needs to be located ...

**0**

votes

**3**answers

4k views

### How do I add content to Excel cells?

How can I add a T to the content of each cell in a certain column (that contains 10000 cells) without typing it manually?

**1**

vote

**3**answers

3k 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)?

**2**

votes

**2**answers

5k views

### Excel - Dynamic row reference based on the row I paste a formula into?

I have a simple, oft-used formula that I paste as plain text into spreadsheets I receive. It looks something like this:
=IF(D8="FOO", "BAR", "BAZ")
It looks in D8 for the word "FOO". If it finds it ...

**2**

votes

**1**answer

792 views

### Two Spreadsheets, Merge Data?

I was wondering what is the best way to merge two spreadsheets which have the name id's e.g:
One sheet has:
apple 5
dog 3
cat 2
Second sheet:
dog 4
apple 7
cat 3
I would ...

**1**

vote

**2**answers

154 views

### Versionable text spreadsheet format, ideally with GUI editor

I'm looking for a spreadsheet format that whose diffs won't look insane if I version it.
Ideally this would have a decent editor to go with it (GUI preferably), and should be available ...

**1**

vote

**1**answer

104 views

### How to visualize historical data

I have inherited a horrible spreadsheet with 4 years of data about when people participated in a given activity, by month. Each person would likely participate once every 18 months or so, but ...

**2**

votes

**1**answer

42 views

### Rearrange cells in a column to a different column with same heading (Excel 2002)

I need the values in one column to be rearranged for each set into another column.
This picture will help explain:
Follow the red lines, that is where I want my data to go.
This shouldn't be too ...

**0**

votes

**1**answer

77 views

### How do I select a set of specific cells and then copy their entire row?

Okay this is hard to explain.
I have a massive spreadsheet with sets of data in it. Each set has 'type' column (eg: system, memory, video card, etc). I need to be able to search within this column ...

**0**

votes

**1**answer

2k views

### Microsoft Excel Exercises for learning purposes

I'm not sure if it belongs this here, but if you feel it doesn't just please remove it. I'm looking for a good source of exercises in excel that is good in teaching a friend of mine that wants to ...

**0**

votes

**1**answer

1k views

### Autosort microsoft excel worksheet

Can I configure (possibly with scripts) Excel to automatically resort a table every time an entry is updated?

**0**

votes

**1**answer

434 views

### How do I simplify this if statement to just add 1 every time (and possibly go with no limit)?

=if(C24 ='Ability Base'!$A$2;sum('Ability Base'!$B$2);
if(C24 ='Ability Base'!$A$3;sum('Ability Base'!$B$3);
if(C24 ='Ability Base'!$A$4;sum('Ability Base'!$B$4);
if(C24 ='Ability ...

**3**

votes

**1**answer

5k views

### Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells

I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct.
The only way to overcome ...

**2**

votes

**2**answers

4k views

### how to find lowest 2 or more values

I have rows of data and would like to sum all but the lowest 2 or 3 or 4 entries.
What is the easiest way to do this? Does it involve a macro.
I prefer open office spreadsheet, but could also use ...

**2**

votes

**1**answer

177 views

### Conditional Formatting in Excel

I have a worksheet with a series of rows A1 - H1 etc and a drop down list which lives in H1, I would really like to change the cell styles of all the cells between A1 - H1 based on the value in H1.
...

**1**

vote

**2**answers

466 views

### Not counting values if strikethrough in iWork- Numbers

I'm building a holiday expense planner and I'm trying to get the sum of a column in a table, however as I pay things off I want to be able to strikethrough the amount and then it minus it from the ...

**2**

votes

**3**answers

637 views

### Excel data representation: show me all people who did not pass the exam

Background
I have an excel spreadsheet with the results of a pass/no-pass exam. Students are allowed to take the exam as often as they want until they either pass, or give up trying.
student ...