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
2answers
670 views

Excel function for calculating total spent time

I have an excel sheet, where in some columns I have cells of the type "integer,integerM" or "integer,integerH", for instance "1,30m" or "5,2H". For all the column I would like to get an expression ...
1
vote
3answers
43k views

VBA code to hide or unhide rows based on a cell value

Heres my code, but its not really doing anything, I dont see anything wrong with it: Private Sub PG1(ByVal Target As Range) If .Range("E50").Value = "Passed" Then ...
0
votes
3answers
250 views

Excel - Referring to a certain cell based off of data in another

I have a spreadsheet where there is one table with the headings: Coordinate, Lat, Long Another with headings Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area What this is for, is taking ...
0
votes
1answer
29 views

Delete only lateral edge in MS-excel?

Is it possible to delete only the lateral edges in a excel matrix? In the attacched image you can see tha matrix and you can notice that is almost impossible to delete left/right formatted edges ...
2
votes
3answers
95 views

Adjacent cells replicate format of previous cell

I have a basic spreadsheet set up to monitor my outgoings. When something clears my account I color the relevant cell in so I know its accounted for. However since I upgraded my Office, whenever I ...
1
vote
1answer
2k views

How to bulk replace links that are embed to words in Excel cells

I have a huge list of words that have links. All the URLs have text that repeats. I want to mass replace this text with another. Right now, "Replace all" only searches between words, not through the ...
3
votes
2answers
148 views

Excel 2010: Find duplicate entries in one cell

I have data imported from a literature database (.txt format) into Excel. Unfortunately, in most cases, the authors are listed double in one cell, e.g.: "Smith, Miller, Patty, Smith, Patty, Miller" ...
0
votes
1answer
45 views

I've deleted some cells and cleared everything out and it keeps reverting back to DATE format

I've never changed formatting to date: I always keep it in General unless I need to make it different. Since my last Update, everything now changes to date when I either copy, paste, or when I ...
0
votes
1answer
633 views

Excel - compare names in two cells in different order

I need to compare the following Cell 1 John Peter henderson Cell 2 peter John Henderson Result Match Cell 1 Anne jolie ...
0
votes
1answer
36 views

Display time difference - Formatting

I have a table of times and a formula that works out the difference between the times but having some difficulties formatting the output. For example I would like: # Time Gap 1 ...
0
votes
2answers
647 views

VLOOKUP when VLookup Value is a cell populated via another formula

I keep getting a return of NA when trying to accomplish the following: formula: =vlookup(left(Q2,3),A2:C20,3,false) Definitions: Q2 is a cell that is populated from a formula. Its calculated value ...
0
votes
1answer
959 views

excel 2010 how to identify if a word is present in a group of cells or a row [duplicate]

I would like to use a formula to identify if a cell in a group of cell contains a specific word. Example, I'd like to search if a cell has the content X The formula's response could be 1 if found, 0 ...
0
votes
2answers
51k views

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 ...
1
vote
2answers
8k 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
37 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. ...
0
votes
6answers
18k 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
493 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
59 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
88 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 ...
1
vote
1answer
680 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?
0
votes
1answer
143 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 ...
1
vote
1answer
360 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 ...
0
votes
1answer
823 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
139 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 ...
1
vote
1answer
670 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
505 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
2
votes
1answer
4k 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) ...
8
votes
1answer
59k views

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 ...
0
votes
1answer
78 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
40 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
828 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
7answers
21k 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 ...
2
votes
3answers
17k 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
126 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
260 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 ...
0
votes
3answers
2k 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
172 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
4k 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
9k 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
6k 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.
18
votes
4answers
11k 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
517 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
5k 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
864 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
747 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
105 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. ...
11
votes
4answers
29k 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
565 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
3k 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
248 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 ...