Tag: spreadsheet

77 How to create a formula for every row in a column in Google SpreadSheet? 2011-03-21T21:03:19.213

57 Excel Conditional Formatting Escaping a Question Mark 2010-05-24T21:04:28.853

22 What is in LibreOffice Calc the equivalent to Excel's "Paste Special > Value"? 2011-12-29T08:04:46.363

20 How to sort an Excel spreadsheet columns by row contents? 2011-08-01T14:57:19.677

19 OpenOffice: Delete rows based on cell value 2009-09-09T13:07:20.240

15 Select each nth row in Excel 2009-11-11T22:10:59.887

14 How to Label / Tag Items in a Spreadsheet 2012-03-27T09:23:13.277

12 How to scale a long LibreOffice Calc sheet to fit on two pages when exporting to PDF? 2013-10-31T19:50:33.720

12 Disable prompts in Microsoft Excel when saving a CSV file 2014-02-03T22:32:11.643

10 Using excel, how can I count the number of cells in a column containing the text "true" or "false"? 2010-05-09T22:48:57.140

9 Can't insert cells in Excel 2010 - "operation not allowed" error message 2012-04-26T15:16:31.280

8 Too much text for an Excel cell -- how to make the cell scrollable 2012-05-25T00:06:44.740

8 How to compare two Excel spreadsheets? 2018-01-25T11:54:01.683

7 In Open Office, make 1st row of data "scroll lock" so it is always visible as you scroll down? 2009-11-12T19:48:44.703

7 Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm 2011-08-09T16:27:22.000

7 Formula to add X months to a date? 2013-02-20T21:37:10.187

7 Dynamically filtering data before importing from SQL Server in Excel 2013-05-02T14:48:52.083

7 Is it possible to access and edit Google documents directly from Libreoffice? 2013-05-28T19:03:53.390

7 Spreadsheet (Excel, Google Docs etc), extracting value separated by comma 2017-05-16T17:42:11.060

6 How do I test if a cell in OpenOffice Calc contains #N/A? 2010-03-02T09:57:42.013

6 Swap rows in gnumeric 2011-07-05T11:05:56.747

6 How can I print Excel spreadsheet files automatically? 2011-09-07T16:50:43.593

6 How to sum cells depending on the content of a neighbor cell 2011-11-21T16:37:16.787

6 Does any spreadsheet allow you to create your own functions? 2012-08-30T17:49:50.657

6 How to view large spreadsheet in Windows 2012-11-20T10:02:38.587

6 Is it possible to copy & paste a pivot table in a spreadsheet? 2013-05-23T12:11:46.913

6 how to highlight the cell with the max value 2015-05-20T19:54:52.317

5 Where can I find some dummy data to teach my friend how to use a spreadsheet? 2009-09-29T09:01:04.500

5 Excel annoyance: How to maintain formulas in a ledger? 2009-12-14T19:14:37.853

5 Make Excel 2003 Open Spreadsheets in new instances 2008-10-17T17:42:06.027

5 Excel spreadsheet bogged down, Is there an alternative software? 2011-05-19T21:10:33.853

5 How can I enable the creation and editing of hyperlinks in shared Excel worksheets? 2012-01-04T17:35:52.817

5 Deleting multiple selected rows in Excel 2012-11-15T10:19:47.963

5 Excel 2007 - changes on one sheet affecting other (without cell references) 2013-03-07T03:56:19.657

5 Apple numbers: How can I create a filtered column (B) with only unique values from column (A)? 2016-09-18T16:06:19.100

4 What's the difference between "vlookup" and "lookup" in Excel? 2009-09-12T04:19:32.037

4 Is it Possible to not copy all 65,537 cells when copying a column in Open Office 2009-10-27T21:23:04.417

4 Count cells based on text content (Gnumeric) 2010-01-10T04:04:33.147

4 How do I open or convert a Microsoft Works .XLR spreadsheet to an Excel compatible format? 2010-01-13T07:58:11.223

4 Read data from separate CSV file in OpenOffice Calc 2010-02-24T09:49:21.813

4 how to find lowest 2 or more values 2010-09-09T17:40:42.607

4 Custom CSV (.csv) filter for OpenOffice.org or LibreOffice? 2011-01-29T13:51:44.497

4 Spreadsheet forumula questions to pick a random DVD 2011-01-30T15:36:54.090

4 Edit spreadsheet object in Word document with protection 2011-04-28T17:07:58.167

4 How do I delete excess cells in Excel 2007? 2011-09-02T16:52:49.863

4 OpenOffice Calc - how to insert BLANK in a formula? 2011-10-15T12:13:34.420

4 Can you use infinity in a cell reference in LibreOffice (or any other spreadsheat)? 2011-10-21T16:42:00.930

4 How to break a spreadsheet containing CSV into multiple columns? 2011-12-04T19:33:31.470

4 Turn Excel spreadsheet into a formula 2012-03-30T14:07:29.360

4 ADDRESS function nested in SUM returns Err: 502 2012-07-25T21:02:29.627

4 Automatically filling colors as per the values in the cell in spreadsheet 2012-11-08T13:37:14.710

4 Cannot delete created excel table 2014-04-08T06:26:46.893

4 Handle pasting of decimal with dot (1.7) when locale is expecting comma (1,7) 2018-01-02T23:52:50.163

3 How can I copy a formula multiple times and always refer to the same cell? 2009-08-07T21:37:56.037

3 Excel: #NAME? appearing when linking/referencing other spreadsheets/workbook cells 2010-10-01T09:47:14.590

3 In Excel, doing a "Freeze Panes" on the right-most column instead of the left-most? 2011-01-26T15:04:26.163

3 In Excel, copying cell *values* (not formulas)... yet keeping the cell formats 2011-01-26T20:12:22.553

3 Open Source Spreadsheet with Sensitivity Analysis 2011-02-10T16:15:13.220

3 How do I access the search functionality in Open Office? 2011-05-10T19:12:07.400

3 Adding a constant in LibreOffice Calc 2011-06-19T10:10:51.307

3 How do I make a random selection in a spreadsheet using more than one criteria 2011-08-15T15:26:31.630

3 Alternatives to Excel 2012-01-14T15:14:04.997

3 Excel-like software for XML data? 2012-03-02T14:41:34.390

3 Retrieve content of different cells based on input 2012-05-23T14:05:29.637

3 OpenOffice Calc - Highlighting the higest value in a column 2012-08-30T14:17:34.427

3 How do you find the maximum value in a column, skipping to every nth value? 2012-09-05T23:13:41.147

3 Numbers imported into Ubuntu Libreoffice calc from text or csv files are coming in as text 2012-10-13T13:27:53.790

3 Sum the first N elements in a spreadsheet column 2012-12-29T05:36:46.323

3 Excel Offset Function Returns #VALUE! Error When Combined with Row Function 2012-12-29T06:24:32.373

3 Numbers conditional formatting based on a different cell in the same row 2013-01-05T07:04:30.550

3 Lookup the nearest value in a column? 2013-03-01T14:56:28.547

3 How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel? 2013-03-26T15:19:16.007

3 Why is this simple Excel calculation not netting Zero? 2013-04-06T10:43:31.153

3 Split Text into Columns Function in Excel 2013-08-19T15:27:50.463

3 In a spreadsheet, is it possible to separate rows into groups that will not change order when filtered? 2013-08-30T14:31:52.957

3 Decimating rows in spreadsheet 2013-11-26T16:54:35.037

3 How to fold a horizontal series into a vertical one 2014-01-02T21:11:45.247

3 How can I combine two lists into one long list? 2015-02-04T10:27:40.910

3 Histogram of dates in Google Sheets or OpenOffice 2015-05-12T17:27:37.257

3 Sum values in specific rows based on whether the row has a value that belongs to a range 2015-09-23T04:02:26.163

3 How to delete multiple rows in Gnumeric 2015-12-02T17:43:00.997

3 Put a checkbox in a cell in Excel v15 for Mac 2016-03-11T05:07:30.893

3 How to create an array of values in LibreOffice Calc? 2016-09-23T16:51:33.253

3 libreoffice /open office calc - visualise formula 2016-11-08T11:35:25.260

3 Highlighting every other row in LibreOffice (or OpenOffice) without conditional formatting? 2016-12-01T07:55:00.890

3 Append three columns in LibreOffice 2017-06-05T20:47:20.320

3 How to fix Excel and prevent it from converting copy-pasted or imported strings to dates even when cells are formatted as text 2018-08-15T21:04:25.370

3 How to find cells that reference the current cell in LibreOffice Calc spreadsheet? 2019-01-21T18:22:06.777

2 In Google Docs, how to create a form that can store the data entered into it in an excel sheet automatically? 2009-09-26T17:22:46.580

2 AutoComplete interferes with Tab and Enter in the OpenOffice Spreadsheet 2009-11-05T17:16:08.450

2 Spreadsheet RDBMS 2010-05-29T00:07:05.423

2 Excel data representation: show me all people who did not pass the exam 2010-06-07T17:51:21.077

2 Conditional Formatting in Excel 2010-08-05T23:22:15.923

2 Rearrange cells in a column to a different column with same heading (Excel 2002) 2010-12-07T14:16:29.583

2 Two Spreadsheets, Merge Data? 2011-01-11T04:05:01.430

2 Excel - Dynamic row reference based on the row I paste a formula into? 2011-01-17T21:31:33.693

2 Big Excel File Freezing/Running Slowly 2011-02-17T22:50:30.557

2 How do I count the times each number appears in columns of numbers? 2011-03-06T05:42:37.247

2 How to conditionally highlight cells in OpenOffice Calc? 2011-05-24T09:00:13.843