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.
6
votes
3answers
5k 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?
5
votes
3answers
3k 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 ...
4
votes
4answers
430 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?
4
votes
3answers
4k 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 ...
3
votes
1answer
855 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 ...
3
votes
1answer
87 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. ...
3
votes
2answers
64 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 ...
2
votes
1answer
5k 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 ...
2
votes
2answers
2k 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 ...
2
votes
1answer
42 views
How do I copy the results of a calculation without copying the formula behind it? Open Office Calc
How do I copy and paste only the results of a calculation without copying the formula behind it? I'm learning to use Open Office Calc. I remember other spreadsheets that had a values function, or ...
2
votes
1answer
211 views
How to check if cell contains a value of another cell
Here is the scenario:
On column A each cell has random text within it (names, address, account numbers, etc). Column A extends down to over 40 thousand rows.
On column B I have a list of (account) ...
1
vote
3answers
1k 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 ...
1
vote
2answers
94 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 ...
1
vote
1answer
36 views
Call on a cell in Excel up to the first semi-colon
I am using the =CONCATENATE function, and one of the cells I'm calling on I only want to take the value in the cell up to the first semi-colon. Is this possible, and if so how?
1
vote
3answers
372 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
2k 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 ...
1
vote
3answers
530 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 ...
1
vote
1answer
1k 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?
1
vote
2answers
455 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?
1
vote
4answers
3k 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, ...
1
vote
2answers
34 views
Excel: if duplicate cell value found in another column then highlight green
Can someone help me, I'm not sure what formula to use.
I have highlighted the cell in the picture to show an example of what I mean.
What I want to do is highlight the cell in column A where the ...
1
vote
1answer
2k views
Make some cells in an Excel sheet read-only?
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 ...
1
vote
3answers
173 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
1answer
1k 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
1answer
12 views
MS Excel: custom money format
Need to represent decimal number as "## hrn. ## kop.".
Example:
1.2 => 1 hrn. 20 kop.
3 => 3 hrn. 00 kop.
I've created custom cell format:
0," hrn. "#0" kop."
Result is:
1.2 => 1, hrn. ...
1
vote
1answer
41 views
Make Excel Row Height Stay when Sorted
I have an Excel 2007 spreadsheet and need to make some rows bigger than others so there is vertical space for a signature.
These cells are colored differently, but the height doesn't stick with the ...
1
vote
1answer
145 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
1answer
481 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
5answers
2k 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 ...
0
votes
3answers
3k 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
3answers
74 views
How do you add extra value to a cell that already has an existing number in it
I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...
0
votes
1answer
40 views
How to edit a formula for a range of cells in Excel?
I have linked two excel worksheets together so whatever data I input into worksheet 1, will appear in the proper cells of worksheet 2. Next month, I will receive a new worksheet which will have a new ...
0
votes
1answer
155 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 ...
0
votes
1answer
30 views
Excel: Select all that are not in a set of values (and delete)
I have a list of zip codes, but only a handful of them are needed.
In Excel, how do you select all rows which do not meet (or inversely meet) a set of criteria?
0
votes
1answer
57 views
I need to know how to swap the contents of two adjacent cells in Excel based on the content of a third cell
I am trying to swap the content between two cells in Excel based on the content of a third cell. So, I have a column in Excel - say Column C. I want to swap the values of the corresponding cells in ...
0
votes
1answer
52 views
Can I get the properties of the color of a Microsoft Excel cell in numbers/text?
I want to count the yellow, red and white (no color) cells in a column (range) within a Microsoft Excell sheet.
The colors are equal (i.e. only one RGB value of yellow is used, not light/dark yellow ...
0
votes
1answer
1k 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. ...
0
votes
4answers
1k 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
...
0
votes
1answer
283 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 ...
0
votes
1answer
43 views
Formating my Excel Cell Formulas
What formula can I format my cells to so that when I input a number it will have a u after it (I have it set to ###,###u now) and if it is blank it will have "N/A" in the cell? Thank you in advance.
0
votes
2answers
57 views
Changing the format of cells
I have an Excel worksheet where one of the cells has the string "\xab\xcd\xef" etc. It seems as if Excel is taking this as the ASCII string "\xab\xcd\xef". How do I make Excel treat it as a binary ...
0
votes
1answer
67 views
Adding Subsequent Cell Values For Each Row in Excel
I'm new to excel so this might be a simple question. I have around 100 rows with 7 columns. Out of those, 4 column needs to have the value computed by 3rd and 2nd columns' value of the same row.
I ...
0
votes
1answer
43 views
cell array of strings to matlab structure
I need to create a matlab structure as such ds=struct('name',{{'my_name_is'},{'matlab_thining_hair'}}) which stores as a 1x2 structure array with a field name. A call to ds.name generates the output:
...
0
votes
2answers
98 views
I need to arrange my data cells in excel in a way that rows are rearranged as shown
1 2 3 4 5 6 7 8 9 10
(this is my initial data)
my output
1 2 3 4 5
6 7 8 9 10
is there anyway i can do this? i have around 400 rows of similar data
many thanks
0
votes
1answer
47 views
Excel Formula For Re-arranging Numbers
I have got a bit stuck with trying to make a formula in Excel, and last time I asked a question here I got great help, I have come back again. At the moment I have column A with sets of product id's. ...
0
votes
1answer
23 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
307 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 |
...
0
votes
1answer
171 views
How can I take a picture with the built-in web cam on my laptop Windows-7 & easily store it in a specific cell of a specific excel spreadsheet? [closed]
How can I take a picture with the built-in web cam on my Windows-7 laptop & easily store it in a specific cell of a specific excel spreadsheet?
0
votes
1answer
401 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 ...
