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
0
votes
1answer
3k views

Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule: If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. Both ...
0
votes
1answer
3k views

How to add prefix or suffix to range of cells in Excel?

I have cell A in excel full of images name without the extension I want to add ".jpg" as a suffix to these ranges of cells however I need to skip non text cells by not adding anything. Any help to ...
4
votes
2answers
113 views
+50

Outlook Table Relative Cell Reference Error

I'm getting a "!(cell) Is Not In Table" error when attempting to create a Relative cell reference, inside of an outlook table, when using a formula. I've tested the formula functions and they seem ...
0
votes
0answers
32 views

Excel 2016: All cells dark by default

I have a very weird and annoying problem. Cells in my Excel 2016 are dark by default. Every new document is dark. Every opened document is dark (sometimes with some exceptions). I tried removing ...
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 ...
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 ...
0
votes
1answer
29 views

Have blank cell for formula answer if no data in origianl cell

I have a long formula showing if an invoice is paid, late or outstanding. =IF(K26="",IF(J26 Can I do anything so that when I copy this down my Excel page, if I have no invoices listed it shows a ...
0
votes
0answers
9 views

Libre Calc: how to create a special cell so that I could reference to it from other sheets?

I am trying to create a monthly budget sheet. It consists of 2 sheets. The first sheet (Sheet1) consists of 2 columns - column EXPENSE_TYPE and column AMOUNT. Its purpose is to display a total amount ...
0
votes
1answer
4k views

Updating another Excel spreadsheet from current spreadsheet

I used the VBA code in "How do you write an Excel formula that will paste a specific value in a different cell?" posted here in May 2013 and it works well to populate/fill another cell in the same ...
0
votes
0answers
62 views

Dragging and dropping cells in Excel causes unwanted shading to be applied

When I drag and drop cells, shading sometimes gets applied to the original location of the moved cells. How can I prevent this happening? The shading is often grey but can be any colour. It's ...
1
vote
1answer
5k views

Align header with cells whose text is oriented at an angle

Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle? This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" ...
0
votes
1answer
45 views

convert Date to Julian day in Excel

How to calculate the fourth column based on the first three columns in Excel? Date cell to Julian day for example: year month day **Julian day** 2000 1 1 1 2000 1 2 ...
0
votes
1answer
27 views

simple sum in Excel but replacing one of the addends in its own cell

Am an Excel novice and have looked in several MS office books I got from the library but none say how to do the following, and I've performed a couple of general internet searches to no avail as well ...
0
votes
1answer
2k views

vba excel macro Creating a macro to compare cell values and then insert a row between sets

I believe that the pictures will show all. The first is the source where the macro should insert a row between sets and calculate the sum of sets. One set is build by column "I"/Subject. For example ...
0
votes
0answers
26 views

How to protect a worksheet in excel but auto resize columns and rows?

I created an Excel workbook with a large amount of data on two different worksheets. I have a 3rd worksheet that I'm using to display a clean summary of the data based on User Input. I protected the ...
0
votes
0answers
9 views

openpyxl strange cells references

cells debug: excel file: Hi, using openpyxl in python3 and I don't understand why it is referencing cells with missing gaps in the column references. Please see the images. Please help.
0
votes
1answer
18 views

How to convert names created with Excel's Name Box from workbook-scoped to worksheet-scoped?

I created A LOT of names of cells in an Excel worksheet using the Name Box (to the left of the Formula Bar). Then, I decided to make a different version of the worksheet in the same workbook. And then ...
-6
votes
1answer
93 views

Merge button NOT greyed out, but can't merge cells

I see a lot of issues with the button being grey and not working. But what about when the button is not grey, the button centers text, but the cells do not merge. I have unlocked the cells.
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 ...
0
votes
0answers
17 views

Storing the history of cells in multiple sheets

I am trying to store the history of a number of cells in a worksheet. I created a macro to do this, which works by clicking a button, runs the macro and stores the data in a different part of the ...
0
votes
0answers
41 views

Excel 2010 - CELL function not returning Worksheet

All over the INTERNET I found that CELL function returns the full file path, the Drive letter, Workbook and Sheet name in a format of C:\Folder\[workbook.xlsm] sheetname more or less by entering the ...
0
votes
1answer
41 views

How to set value of height or width of cell precisely? - ms excel Office 365

I'm going to make labels for pasting in MS Excel Microsoft Business 365. I have version 1903 (compilation 11425.20228). But they should made precisely and perfectly. Now when I begin editing the ...
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 ...
0
votes
0answers
22 views

Comparing Two Excel Sheets

I Have Two Excel Sheets wherein one is a copy of the other. I had updated Data in both Sheets quiet sometime back but since they had the same name, I am now confused which one was updated later with ...
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
0answers
70 views

How to insert chapter(textbox) in PPT using think cell add in vba?

I need to automate think cell agenda slide through VBA. Manual process to insert agenda slide starting a new chapter is that we used to click on the Chapter shape available in think cell add in.
0
votes
7answers
115k 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
0answers
32 views

Libreoffice calc all spaces disappeared in between words

I have an issue with Design Mode/Edit Mode and Cell Edit Mode. I am new to this and I have made a mistake. The result being that all the spaces between words have been lost. I was copying a pasting ...
1
vote
2answers
321 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 ...
0
votes
1answer
54 views

How do I get a cell to dynamically move and update?

I have a workbook that has multiple sheets. The content that gets entered into a sheet changes monthly. For instance, sometimes I will have 5 entries, and sometimes I will have 400 enteries in a sheet....
0
votes
0answers
23 views

Case sensitive formula in excel

I’ve been playing with this formula because I couldn’t get the original syntax to work and it’s nearly doing what I would like. Please can you help me make it case insensitive? Here is the data and ...
0
votes
1answer
38 views

Match 2 sets of numbers in 2 cells

I have 2 cells with similar data extracted from 2 different websites. Data in D6 is supposedly shorter version of H6. I want to put "Match" or "No Match" in E6. For "Match" either 2 sets of numbers ...
-1
votes
1answer
36k views

Excel vba code for adding a value to existing cell of sheet

I have this code to add value of a cell to an existing value of the other cell: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Not (Intersect(Target, Range("E3")) Is Nothing) Then ...
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 ...
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@...
0
votes
0answers
38 views

Link two tables in MS Word doc

I have a Microsoft Word document that has two somewhat redundant tables, let's say tab1 and tab2 (these tables are disjoint, in different parts of the document and have the same number of rows). I ...
0
votes
1answer
26 views

Not using a cell as variable, whilst inserting a (excel-)formula in several cells

I'm facing a small, basic little problem, for which I can't find the solution: I'd like to insert the same formula in several cells at once. Quickly googling this problem provides a solution: Either ...
0
votes
2answers
65 views

How to step up cell reference in function by numeric values based on known number of rows

This is in reference to the formula I need for cell F2 in the below image. F2 shows the result I WANT: I NEED: The Concat Formula to concatenate the data in Column B for each variant of whatever is ...
0
votes
2answers
1k views

How to move partial text from one cell to another

I have a dilemma I am hoping someone might be able to help me with! I have exported a PDF file into excel that has a lot of information that populates into one cell. I need to split this information ...
0
votes
1answer
1k views

Excel - Find duplicate values in two rows with two conditions

Could someone guide me to find the correct formula for this case of conditional formatting in Excel? 1- Highlight the two adjacent cells in orange only if their values are the same on the same line ...
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 ...
0
votes
1answer
58 views

How do I create a ''droplet'' script in Win7 that runs a Notepad++ task on a CSV file

I have recently asked a question on how to perform a neat little 'Find & Replace' task on my CSV media database files (a task i have to do at work on a daily basis). The question was answered here ...
1
vote
2answers
73 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 ...
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 ...
0
votes
1answer
29 views

Two related cells

In A1 I have price, for example 1000. In A2 fill percentage, for example 10%. Then in B2, calculate A1*A2 = value. I would like when i fill percentage in A2, in B2 calculate value and vice versa - If ...
0
votes
1answer
35 views

Looking for the same value in two cells

=IF((JANUARY!D6=K3),JANUARY!B6,"") This is the formula I'm using to try and pull information from the January tab, and place additional information on a different tab. This formula works, however, I ...
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 ...
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 ...
0
votes
2answers
579 views

Increment number with letter in cell

I have a column of random numbers that all begin with 'B*****' where the stars are numbers. I need a formula to add 1 (+1) to the cell on the right of the number and take away 1 (-1) to the left of ...
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 ...