The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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.

Filter by
Sorted by
Tagged with
3
votes
2answers
337 views

Can I insert rows next to a locked column in Excel?

If I lock cells A1:A3000, is there a way to insert rows in columns B-Z? I highlight them and I don't get the option to insert even though it is selected in the lock options. (Bottom line is that I ...
1
vote
1answer
361 views

Delete cell content in Libre (Open) Office based on the cell value

I have a huge csv file (tens of thousands of rows) that I need to filter based on different criteria. After trying to find a proper CSV editor, I decided to use LibreOffice Calc. CSVed is great, but ...
1
vote
4answers
7k views

Create a hyperlink from URL and title in Excel

I'm trying to construct a hyperlink from a URL and a name in different cells. a1 = http://www.example.com/ b1 = example c1 = <a href="http://www.example.com/">example</a> What I want ...
1
vote
2answers
223 views

How to keep Excel from using absolute addresses when clicking a cell while in a “range selection” window?

In any version of Excel (since 2000, at least), you can enter = into a cell to indicate that a formula is about to be entered and then click cell A1 so that the formula says =A1. This is a relative ...
0
votes
1answer
8k views

Excel - Displaying a value in a cell dependent on another cell having text

I have an excel file with 2 sheets. The first sheet is a user input sheet with cells that are properly formatted for us. The second sheet pulls the raw data into table format so that we can inport ...
1
vote
3answers
22k views

Remove data from a cell in Excel

I want to remove data from multiple cells in a spreadsheet using Excel 2010, so I only have the email address left. They are in the current format: M: 04545 545 545 e: test@email.com h: 01187 475 ...
0
votes
3answers
7k views

Sum only if any one of six cells have a value

I would like a cell (total) to sum 6 other cells only if one of those 6 cells have a value. If none of the six have a value i do not want anything to appear.
36
votes
5answers
26k views

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 ...
0
votes
1answer
582 views

excel time difference if a cell is not formatted as time

I just can't solve this! Excel 2010, I have a timesheet where I write day by day the entry time, exit time, lunch time. A cell computes the worked hours, say: A B C D entry ...
3
votes
2answers
7k views

Make Excel cell save formula results and not the actual formula?

I have C1 that needs to combine C2 and C3. The problem with this is that is that if I'm importing with SQL it doesn't combine C2 and C3, but instead imports nothing or the actual formula. Is there a ...
1
vote
3answers
2k views

Methods to clear a cell in Excel 2010

I'm taking a certification course for Microsoft Excel 2010. I'm taking a class that goes over it and we all just got hit with this question: 61. In Excel 2010, which of the following can you use ...
4
votes
4answers
814 views

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?
3
votes
1answer
128 views

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. ...
26
votes
6answers
112k views

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?
0
votes
3answers
677 views

Select the value of a cell above an empty cell

How would I select a cell that is above an empty cell? I have a feeling it is going to be something super simple, but I haven't done any excel since 2004. Here is a simple single column sheet. data1 ...
10
votes
1answer
8k views

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 ...
0
votes
1answer
302 views

Excel: while merging column contents using ampersand I “lose” zeros

I need to merge different columns like: AB 0054 00000137 I do it this way =A1&B1&C1 It works but my Zeroes get lost. The text in my columns has been formatted in "personal" with zeroes ...
1
vote
2answers
1k views

A way to call someone from PC via a cellphone

Is there a way to use a cell phone as a modem and then use a phone software like Classic PhoneTools to call another (cell) phone?
0
votes
3answers
1k views

PC outgoing sound to a cellphone input

Instead of putting a cell phone near a PC speaker : Is there a way to stream outgoing sound from PC (the so called Stereo Mix in Windows) to a cell phone input (an iPhone for example) and then to a ...
3
votes
5answers
18k views

Comma separated values (literally, not csv) in the same cell in excel, put in individual cells

I have a column of cells in excel which contain mails, some only contain one mail as they should but others, have more than one email per cell in this format: one@example.com, two@example.com, three@...
6
votes
3answers
13k views

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 ...
5
votes
1answer
2k views

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 ...
1
vote
3answers
226 views

cut text into excel and preserve cells

I'm writing a program that emails some data to a few of my employee's One of them tracks the data in excel so I added a purely data line in text to the bottom of the email so he can just copy and ...
1
vote
3answers
2k views

How can I detect if a range of cells contains only identical values or not in Excel?

I have a range of cells and I want a formula that says if all these contains the same values or not. Usually for two cells I would use if but I want a solution that would work for ranges. I don't ...