Super User
Super User

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.

226 questions
45
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,427
43
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,863
24
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,746
16
votes
6 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
  • 2,143
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
  • 665
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
9
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
  • 567
9
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
  • 111
7
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
  • 255
  • 1
  • 7
  • 15
7
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,784
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,953
4
votes
9 answers

Microsoft Excel 2007 - Cannot Fit All Text Into Cell

Is it possible to fit a large amount of text within a cell in Excel 2007? I have 1,890 words - consisting of 10,110 characters (without spaces) - that I need to put into a single cell in Excel. I have set the cell to the maximum size (column width…
SnookerFan
  • 1,184
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
4
votes
1 answer

Excel find cells by formatting?

The countif function has a criteria argument – how do I specify a criteria based on the formatting of cells? I have a list of math homework questions containing per-page the questions numbers (e.g. on the row for page 12 the row will contain the…
Avi
  • 1,058
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
2 3
…
15 16