# 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.

183
questions

**0**

votes

**1**answer

50 views

### I have cells at the beginning of a spreadsheet that appear blank

I have a spreadsheet that was sent me that has blank columns on cols a-h.
However these are not blank as towards the end of the spreadsheet formulas refer to these.
How do I see the contents of cells ...

**0**

votes

**4**answers

117 views

### Add a text comment in a numeric cell with Excel

Is there a way with Excel, to put a comment with a numeric cell, like the cell A3 here:
such that formulas like =SUM(A1:A5) still work?
Here the wanted result would be 19.
Here it doesn't work ...

**1**

vote

**0**answers

8 views

### How do I turn off autoformat OpenCalc / OpenOffice Spreadsheets

Without context and background: Read the title, How do I turn off AutoCorrect in OpenCalc, specifically time, preferably turn off all AutoFormat.
I am using a spreadsheet to track how fast my online ...

**1**

vote

**1**answer

104 views

### How to shift cells to the left without affecting its “own column” in Excel (i.e. via VBA)?

COLS : NO | | B | C | | D
01 : 1 | | 8 | 3 | | 2
02 : | | | 4 | |
03 : | | | | |
04 : 2 | | 5 | 2 | | 6
How can I shift the values to the left and delete ...

**2**

votes

**1**answer

67 views

### Two-way connection between multiple cells and across multiple worksheets

I am looking to make a 2-way connection across 2 worksheets so that I only have to change the entry on one sheet for it to be changed on the other and vice versa.
I found a good explanation here (I ...

**0**

votes

**0**answers

34 views

### Removing blank data from cells in Excel

I have a file with 50000 rows and 500 columns approx. with data populated. Though half of the cells in the sheet seem blank but the file looks heavier (50mb) which should not be. When I count the ...

**0**

votes

**1**answer

313 views

### Excel: How to create a list of values in one cell for curent and previous values?

I have data that corresponds to "usage" of a product. I can manually update the value as it increases and save the previous values somewhere else.
However, I would like to have the previous value ...

**0**

votes

**1**answer

29 views

### Summing cells in a row up to a given column number

This has been puzzling me and I hope you lot can help me out.
I have a table of numbers, and I wish to sum all the values in a row up to a specified column number. Idea being I can change the 'sum up ...

**0**

votes

**3**answers

317 views

### VBA to check if all cells in a range are empty before proceeding further

I would like to apply a check before executing next lines of code.
I wrote a simple structure like this, but it checks the first cell in range and if that cell is empty it goes to executing next step ...

**-1**

votes

**1**answer

19 views

### Changing from an excel spreadsheet to another always going to same cell ref

can anyone help with hint of how to move from an excel spreadsheet by selecting another tab, and going to a predetermined cell ref?
For certain kinds of excel works, with business models for instance, ...

**0**

votes

**1**answer

38 views

### Changing VALUE in a cell on entering specific text with VBA

I tried to modify this code but I've got some issues with it. Every time I try to enter my text on the cell it's changing the previous cell.
Private Sub Worksheet_Change(ByVal Target As Range)
If ...

**0**

votes

**1**answer

26 views

### Highlight a cell Based on a range on cells

I'm trying to highlight a cell based on the following conditions:
For example:
I want to give the colour red to A1 cell if in a range between A2 until A30 at least one cell has colour blue.
I ...

**0**

votes

**0**answers

793 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 ...

**4**

votes

**2**answers

140 views

### 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

**1**answer

32 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

**0**answers

18 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

**1**answer

80 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

**1**answer

42 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 ...

**1**

vote

**0**answers

71 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 ...

**0**

votes

**0**answers

32 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

**0**answers

10 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

**1**answer

25 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 ...

**-5**

votes

**1**answer

174 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.

**0**

votes

**0**answers

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

**0**answers

104 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

**1**answer

50 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 ...

**0**

votes

**0**answers

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 ...

**1**

vote

**2**answers

377 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

**1**answer

144 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

**0**answers

32 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

**1**answer

42 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**

vote

**2**answers

44 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 ...

**0**

votes

**1**answer

29 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

**2**answers

73 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

**2**answers

4k 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

**1**answer

61 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

**2**answers

156 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 ...

**0**

votes

**1**answer

30 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

**1**answer

36 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

**0**answers

150 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

**2**answers

92 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

**2**answers

831 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 ...

**1**

vote

**1**answer

99 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 ...

**0**

votes

**2**answers

14k views

### Limit Excel cell entry to a certain number of digits

How can one fix the number of digits entered in a cell. For instance, I want only 9 digits to be entered in a cell and if it's more or less it should be flagged or not accepted. I want to make sure ...

**1**

vote

**0**answers

53 views

### Cell reference in formula

I have the following formula in A2 of my worksheet:
=SUMPRODUCT((SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$2,'[Master.xlsx]Composite Assets'!L:L)*(SUMIF('[Master.xlsx]CompositeAssets'!$C:$C,$W$1,...

**0**

votes

**1**answer

184 views

### Libre Office Writer crashes when merging table cells

This time I know for sure: I created a new document, a table, added some data in the table cells, but I want to merge 2 cells on a column.
I can merge 2 cells on a column, but if I want to merge the ...

**0**

votes

**1**answer

75 views

### In Excel, can I create a name that refers to cells that aren't tied to one worksheet?

This isn't a question about the scope of names. It's a question about specifying the cells in a name.
Imagine I've created a name =A1+B2.
That gets hard-coded by Excel into Sheet1!A1+Sheet1!B2. But ...

**0**

votes

**1**answer

68 views

### Excel: Data across multiple columns and rows

Currently have a table like this:
How can I consolidate and count the hours per person spent on each day. Need to be on seperate lines due to working on different tasks but want to bring in all ...

**3**

votes

**0**answers

156 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 ...

**0**

votes

**1**answer

67 views

### Excel deletes cell content of cells I try to edit in a protected work sheet

I have "inherited" an excel workbook I need to fix and the original creator has - of course - gone years before I received the task that I have to fix this file.
The sheets of the file are all ...