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.

learn more… | top users | synonyms (1)

0
votes
1answer
31 views

Printing data in Excel ver 14.0 in a maxed cell

I have set the cell to the maximum size (column width of 255 and row height of 409.5). In order to view all of the data in the cell, I have to use up/down arrows. I don't need to necessarily view all ...
0
votes
1answer
470 views

Excel - Mirror Specific Cell Range

Is it possible to mirror or replicate a cell range from one worksheet to another? For example: ---------------------------------------------- | CELL01 | CELL02 | CELL03 | CELL04 | CELL05 | ...
1
vote
5answers
10k views

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 ...
1
vote
1answer
4k views

How to make a color gradient in a Word 2010 table cell

I would like to make a gradient background in a Word 2010 table cell. Unfortunately, Word only provides solid color filling and premade patterns. There does not seem to be an easy way of doing this. ...
1
vote
2answers
8k views

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?
3
votes
2answers
95 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
206 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
3answers
905 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
147 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
1k 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
4k 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
5k 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.
0
votes
4answers
2k views

Excel - Smooth a curve by calculating / interpolating source missing values

I have a table of values like this one : 18 18 18 46 46 46 46 46 57 57 57 57 57 57 69 69 69 69 69 69 64 64 64 64 64 64 56 56 56 48 48 48 44 or if you prefer : 18 0 0 46 0 0 0 0 57 0 0 0 0 0 69 0 0 ...
11
votes
4answers
6k 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 ...
0
votes
1answer
418 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 ...
2
votes
2answers
3k 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
645 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
633 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
98 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. ...
7
votes
4answers
13k 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
496 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 ...
4
votes
1answer
2k 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
202 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
1answer
2k views

Convert from seconds to minutes in Open Office

I have several cells with a time value in seconds e.g (23, 102, 543, ...) I am not very familiar with the formula functions in Open Office. How do I address the same Cell-Box with the value in it? I ...
1
vote
2answers
709 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
725 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 ...
1
vote
4answers
5k 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, ...
5
votes
3answers
7k 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 ...
4
votes
1answer
1k 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
1answer
711 views

Copy & paste a cell along with its name in Excel

Is there a way to copy a cell that also has a "name", and paste it somewhere else so that the new cell also has the same "name"?
1
vote
1answer
3k views

Excel cell references not updating when referenced cells are sorted

There are two tables, each with 75 entries. Each entry in the 2nd table calls an entry in the first table a parent. One of my 2nd table columns contains the "Parent Price", referencing the Price ...
2
votes
1answer
8k views

Using Excel, How do I Make a Column of Cells Equal One Other Cell?

I have a column of cells, all of which I want to equal the value in another cell. I highlight the cell and type = and then do that again below, and then I highlight the cells and drag down but the ...
1
vote
3answers
741 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 ...