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
35
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 ...
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?
10
votes
1answer
89k 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 ...
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 ...
9
votes
7answers
40k views

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 ...
7
votes
3answers
162k 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 ...
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
4answers
45k 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?
5
votes
1answer
16k views

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 ...
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 ...
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?
4
votes
0answers
123 views

In LibreOffice Calc, how can I change the cell selection black ring to something lighter for dark backgrounds?

In LibreOffice Calc, how can I change the cell selection black ring to something lighter so it can be easier to see for dark backgrounds? I will attach an image to show what I mean. It would be nice ...
3
votes
4answers
11k views

Excel - Lock cells based on color?

I have this excel sheet where i want to protect some cells from formating and editing. All these cells are colored with a specific color. The sheet is very big and therefor i am looking for a way to ...
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@...
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 ...
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. ...
3
votes
0answers
106 views

Formulas Changed to Reference Last Row When I Close and Open Excel File

I have no idea what is causing this issue, but when I reopen an Excel file, formulas that reference cells will change the reference cells at the very end of the sheet. Example: Super simple spread ...
3
votes
2answers
336 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
3answers
158k 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 Rows("51").EntireRow....
2
votes
3answers
58 views

Hide cell from being computed in the formula

I have two cells in the same column adjacent to each other (Q7, Q8). They are used in multiple formulas as range. eg: 1. SUM(Q1:Q10) 2. SUM(E6:N13)-SUM(P6:AJ13) How do i skip those two cells from ...
2
votes
3answers
5k views

Why does Excel allow me to select the same cell multiple times?

I was selecting cells in Excel, and accidentally selected a cell twice. With a cell selected twice I am no longer able to copy the selection, and I have to cancel the selection and do it again. Why ...
2
votes
4answers
272 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 ...
2
votes
1answer
88 views

Shortcut to move to next new content (Excel)

I'd like to know if there is a shortcut to move to and select the last cell in a row or coumn with the same content as the current cell. I.e. ctrl + arrow moves to the edge of the data array, but I'd ...
2
votes
1answer
6k 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) ...
2
votes
1answer
209 views

Excel - Exclude Cells from Computation

Say I have 5 columns of data with 100 rows (so from A1 to E100). For each row I want to compute the averages of the 5 entries while I always exlude one of the entries. E.g. for the first row I would ...
2
votes
1answer
2k views

Excel: extracting a number from mixed content cell [duplicate]

How would one extract a number starting with a "£" sign from a cell containing alphanumeric characters? Example: extracting £450,000 from A1 and placing in B1. See image for example text
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 ...
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
3answers
225 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
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 ...
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 ...
1
vote
2answers
318 views

How do I turn my CSV formatting into a automatic “drag & drop” BAT file?

I'm outputting raw EDL files from Avid Media Composer which is essentially just text that needs re-formatting into the appropriate columns so it's easy to digest for the person receiving it. For ...
1
vote
2answers
43 views

Sum cells based on the value of other cell

I am facing a problem that seems trivial in Excel. What I need to do is simply this: In short, I have a large file of prices linked to a few people and I need to know how much each person paid. I've ...
1
vote
1answer
1k 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
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 ...
1
vote
2answers
329 views

Determine if first visible cell equal to last

please how to determine in vba if first visible (after using filter) cell equals to the last visible cell? If I have: A5 = a, B5 = 1 A6 = b, B6 = 2 A7 = c, B7 = 1 A8 = a, B8 = 1 A9 = b, B9 = 2 ...
1
vote
1answer
566 views

Excel merge cells, keep values, collapsing chart

Imagine a chart that looks like this (rows 1,2,3 are merged in columns B,C,D): A B C D 1 th 2 in ## ## ## 3 g1 4 th 5 in ## ## ## 6 g2 I want a chart that looks like this:...
1
vote
1answer
90 views

Formatting date from decimal in Excel [closed]

How do I format a decimal value like 1.30 as "1 year & 3 months" in Excel? The value needs to remain the same but just needs to be displayed as 1 year & 3 months. I need to do this just ...
1
vote
2answers
26k views

How to copy and paste a cell in a table in Word without losing the formatting?

I have a table in a document, in Word 2010. How can I copy and paste a cell? The whole cell, not its content. I copy a cell, it has a grey background with hatching ("shading"). Then I paste it over ...
1
vote
1answer
2k views

Dragging a cell reference in intervals

I have data as follows (simplified) in two worksheets on a document: Sheet 1 data: A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3 ... Sheet 2 data: A1='Stage Plan'!...
1
vote
1answer
7k 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 ...
1
vote
9answers
37k 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
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?
1
vote
2answers
72 views

How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?

I have to download media file databases on a daily basis and modify metadata from a csv file so that the unique numerical prefix in column B is added as a suffix to the cells in column C. Is there a ...
1
vote
2answers
80 views

Robust linking of cells Excel

Is there a way to link cells so that not only content updates automatically, but also format (fill, border, font, etc.)? Also, is there a way, other than doing each cell individually, to avoid blank ...
1
vote
1answer
88 views

How to copy in Excel 2016 a cell with hyperlink from one sheet to another using formula?

I am automating an excel based report and need a formula that will take cell A2 with its hyperlink from Sheet2 and copy it to another column in Sheet 1. Hyperlink points to external web address. When ...
1
vote
1answer
4k views

click on a cell change the value of another cell

I can not achieve to do what looks like an easy process... I would like to give a value ("Hello") to a cell (named "ClInfo") in sheet named "Hardware" by a click on a cell (C47) in sheet named "1". I ...
1
vote
1answer
101 views

How do I create a summary of the same few cells on many different sheets in Excel 2013?

I have an Excel workbook with 140 sheets. I'm trying to summarize the same 3 cells in each sheet on a summary sheet. How do I grab the value of the respective cells on each sheet without manually ...
1
vote
2answers
517 views

Excel 2010 Array Formula (CSE) Dynamic cell range/reference; index? offset?

This might be an easy question to some but I am completely lost so I would really appreciate any help out there! A 1 10 2 20 3 30 4 40 5 50 6 60 7 70 ...
1
vote
1answer
2k views

How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100). In cell G2 is criteria from column A. With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...