Super User Stack Exchange
Super User Stack Exchange

Questions tagged [cells]

A cell is generally a reference to one point of data in a spreadsheet program. Every data point is within a cell and cells are then grouped into rows, columns or even ranges.

219 questions
44
votes
8 answers

Excel: How do I reference an entire row except for a couple of cells?

I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this: =sum(A3:A*infinity*) How do I do this?
Eddy
  • 3,337
  • 11
  • 42
  • 51
42
votes
6 answers

How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc?

I've imported a CSV file having the first column to be date-time values in ISO 8601 format like 2012-01-01T00:00:00.000Z for the first moment of the year 2012. Then, willing to make LibreOffice to recognize the format (as I was looking forward…
Ivan
  • 7,293
  • 28
  • 70
  • 99
21
votes
7 answers

How to delete MS Word table cell contents but not cells

I am running MS Word 2007. Is it possible to delete the contents of a table without deleting the actual cells? I've tried highlighting a bunch of cells and hitting the Backspace button but with this method the cells get deleted along with their…
John Sonderson
  • 3,496
  • 14
  • 49
  • 68
12
votes
1 answer

OpenOfficeOrg Calc: enter data into all selected cells?

I want to enter the same data (e.g. "superuser") into multiple cells in OpenOffice.Org Calc (version 3.3.0). In order to do so, I select all the cells I want the data to be entered in. However, only the cell selected last (i.e. when releasing the…
None
  • 635
  • 1
  • 6
  • 12
11
votes
1 answer

Make some cells in an Excel sheet password protected?

I have an Excel 2010 file that I do not want to have a password for, but I do want to lock certain cells so that I do not accidentally edit them. Can certain cells be made read-only without a password?
Mark Vig
  • 111
  • 1
  • 1
  • 3
10
votes
1 answer

Combining address function and cell function in Excel

In MS Excel 2013, when I write =CELL("contents",$B$1) It is okay, but when I write =CELL("contents",ADDRESS(1,2)) It results in error. I would like to access the contents of an address. I have done it before, but forgot for the moment. Correcting…
hossayni
  • 547
  • 5
  • 10
  • 24
8
votes
5 answers

How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the formula to exist in the cell I want to paste a…
Robert Jefferies
  • 101
  • 1
  • 1
  • 2
6
votes
3 answers

Add drop down list / combo box into excel cell

How would I add a drop down list (or combo box) into a cell on Excel 2010?
Adban
  • 245
  • 1
  • 6
  • 15
6
votes
3 answers

Excel: Custom number formatting

I don't know much about the rules on custom number formatting in Excel, and I need to learn more. When I open the related window (Format Cells > Numbers > Custom), there are some predefined formats consisting of various symbols. For example: _-*…
Mehper C. Palavuzlar
  • 55,164
  • 49
  • 193
  • 250
6
votes
1 answer

Why do cell phones disturb my speaker?

Sometimes when I receive a incoming call on my cell-phone which is kept very near to my speakers , it disturbs the speaker sound . why does this happen , isn't it safe to keep mobiles near my speakers ?
subanki
  • 7,566
  • 8
  • 44
  • 50
6
votes
4 answers

Prevent Excel to automatically "Wrap text" in a cell

Let's say we have a spreadsheet with all rows having the same default height. In a cell, let's write Hello ALT+ENTER World. I indeed sometimes need to enter multi-line text in a cell, to write some long notes, etc. Then this cell will automatically…
Basj
  • 1,489
  • 7
  • 47
  • 90
4
votes
4 answers

Can I recharge a cell phone battery using USB?

Is it possible to recharge a cell phone's battery even if USB is disabled or blocked on the system?
Sujoy
  • 43
  • 2
4
votes
2 answers

Outlook Table Relative Cell Reference Error

I'm getting a "!(cell) Is Not In Table" error when attempting to create a Relative cell reference, inside of an outlook table, when using a formula. I've tested the formula functions and they seem to work as long as I use an Absolute reference…
Man_Over_Game
  • 128
  • 1
  • 10
4
votes
0 answers

In LibreOffice Calc, how can I change the cell selection black ring to something lighter for dark backgrounds?

In LibreOffice Calc, how can I change the cell selection black ring to something lighter so it can be easier to see for dark backgrounds? I will attach an image to show what I mean. It would be nice if it could auto-detect if a background is dark…
PJS1987
  • 257
  • 4
  • 11
3
votes
4 answers

Excel - Lock cells based on color?

I have this excel sheet where i want to protect some cells from formating and editing. All these cells are colored with a specific color. The sheet is very big and therefor i am looking for a way to lock all these cells in a go and then be able to…
Behedwin
  • 65
  • 1
  • 2
  • 6
1
2 3
…
14 15