Super User Stack Exchange
Super User Stack Exchange

Questions tagged [spreadsheet]

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

689 questions
84
votes
3 answers

Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn all cells with at least one character in them red.…
kzh
  • 4,243
  • 7
  • 28
  • 33
81
votes
9 answers

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 column C for every row? I use it in both Google Docs…
Jonas
  • 26,874
  • 52
  • 105
  • 125
26
votes
4 answers

OpenOffice: Delete rows based on cell value

I've got a rather large spreadsheet that I need to filter some rows out of. In the spreadsheet, all rows whose M-Column doesn't equal "on" must be removed. I applied a filter, and re-saved the document, but that kept the unwanted rows - how can I…
Sampson
  • 7,348
  • 9
  • 56
  • 68
22
votes
1 answer

What is in LibreOffice Calc the equivalent to Excel's "Paste Special > Value"?

In my professional life, I'm limited to use Microsoft Office. In Excel there is an option ows to render the result of a formula to be pasted as a "fixed value". For instance A1 = "I",B1 = "ride", C1 = "a" and D1 = "bike" In E1, I can place a formula…
Rob Rijsdam
  • 221
  • 1
  • 2
  • 3
22
votes
1 answer

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 of a specific row. How can I do this?
Super Chicken
  • 587
  • 3
  • 8
  • 18
21
votes
5 answers

How to Label / Tag Items in a Spreadsheet

I'm a novice at spreadsheets, so I hope you'll forgive me if I'm asking a super obvious question. Is it possible to use tags in Excel/Google Spreadsheet? I'm creating a spreadsheet to log all the articles and books I'm reading. Say I'm reading "I,…
nusantara
  • 313
  • 1
  • 2
  • 5
17
votes
7 answers

Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new worksheet.) What's the easiest way to do that in Excel…
Patrick McElhaney
  • 923
  • 4
  • 13
  • 25
15
votes
1 answer

How to scale a long LibreOffice Calc sheet to fit on two pages when exporting to PDF?

I have Libreoffice and I want to export a long calc sheet to a pdf document with the fit-to-page function from the page preview in the file menu but it doesn't seems to work. I want to fit my sheet up to 2 pages because it's unreadable otherwise.…
Micromega
  • 1,914
  • 7
  • 33
  • 43
13
votes
1 answer

Disable prompts in Microsoft Excel when saving a CSV file

I have to download multiple csv reports from the Internet throughout the day, make a tiny change to them, and save the change. Excel adds 3 completely unnecessary dialogs to what should really be a 5-second operation. It makes you select a file…
Matthew S
  • 559
  • 1
  • 5
  • 19
11
votes
7 answers

Using excel, how can I count the number of cells in a column containing the text "true" or "false"?

I have a spreadsheet that has a column of cells where each cell contains a single word. I would like to count the occurrences of some words. I can use the COUNTIF function for most words, but if the word is "true" or "false", I get 0. A …
Jay Elston
  • 1,381
  • 2
  • 12
  • 24
11
votes
5 answers

How to fix Excel and prevent it from converting copy-pasted or imported strings to dates even when cells are formatted as text

Every time I copy-paste some numerical data written as fractions or separated by hyhens into Excel, it always converts numbers that could possibly be dates into dates. There's no way of getting them back to the original formatting (as copied). Even…
Turkeyphant
  • 328
  • 1
  • 3
  • 20
9
votes
3 answers

Cannot delete created excel table

I have created an excel table. However, I now want to delete or change it because my range changed. However I can't delete it in the excel Name Manager: Any suggestion why I cannot delete it? Would appreciate your answer!
Carol.Kar
  • 217
  • 1
  • 3
  • 11
9
votes
2 answers

Is it possible to access and edit Google documents directly from Libreoffice?

I'd like to work with a Google spreadsheet directly inside Libreoffice, without having to export and import it, in order to automatically reflect the changes on the online file. Basically, I'm looking for a way to use Libreoffice as a kind of…
Sekhemty
  • 9,166
  • 18
  • 60
  • 97
9
votes
4 answers

Too much text for an Excel cell -- how to make the cell scrollable

What do I do when I have more text in an Excel cell than I want to show in the allocated space? Something making it "scrollable" would be preferred.
Olav
  • 664
  • 3
  • 10
  • 29
9
votes
10 answers

Can't insert cells in Excel 2010 - "operation not allowed" error message

I was working on a spreadsheet in Excel 2010, and all of a sudden when I attempted to insert a new row of cells, I saw that the insert and delete options were grayed out. I attempted to copy a different row and insert it as a new row, but I got the…
Force Flow
  • 4,066
  • 8
  • 29
  • 40
1
2 3
…
45 46