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.

68 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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 ...
1
vote
0answers
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,...
1
vote
0answers
251 views

Excel: VLOOKUP with cell containing multiple references

I have a table which contains multiple references per cell separated by a blank space. In an other table that contains one line per reference, I want to use VLOOKUP to retrieve the name of the ...
1
vote
0answers
349 views

Fade all the un-selected cells in excel 2013

I have a long table in Excel 2013 and it is very hard to read and focus on a specific cell. I want to know if there is any way to automatically fade all the un-selected cells? By fade, I mean when I ...
1
vote
1answer
1k views

Word: Make cells independent

I'm trying to make those cells (Title5 & Title6) separate from each other so I can resize one of them without moving second one, but I fail, whatever I do and apply to those cells. This is what I ...
1
vote
1answer
387 views

Cell with 2 options and I want to add a third

So I have this excel file where when I select a particular cell a little box with an upside down triangle appears to the right of the cell. When I click on this there is a small list of options to ...
1
vote
0answers
837 views

If Data Allready Exists In A Cell Overwrite It With New Data

I have an excel sheet with IDs beside cases. When I work the case and get a reply I want the excel spreadsheet to work out its the same case and update the original without adding a new case onto the ...
1
vote
0answers
185 views

Trying to combine 3 of 4 cells in a square in a table in word

I am trying to merge specific cells in a table. The table is setup like this: 1 2 3 4 I am trying to merge cells 3, 4, and 2. However, it will not allow me to do that. If I wanted to combine ...
1
vote
0answers
147 views

How to copy and paste between cells without overwriting what would be in between in excel?

The wording is a bit complicated, but essentially the problem I am having is I have something like: A| blank cell |C B| blank cell |D and I want it to be A|B|C|D all in one row. Doing it manually ...
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" ...
1
vote
1answer
1k views

How can I protect and hide the data in a single excel cell using password?

My professor want me to send out an excel sheet which contains grades of all students. And of course every student can only see his own grade. So he want me to set passwords for the grade cells. Each ...
1
vote
1answer
50 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
1k 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
361 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
727 views

Excel custom function with IF and cell color

I need help with maybe custom function for excel. Everything is in the picture: (Yes, I know that COLOR=YELLOW is nonsense, but its just example of what I think it could solve it). Basically ...
0
votes
1answer
28 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
25 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
0answers
61 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
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
17 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 ...
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
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 ...
0
votes
0answers
67 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
0answers
31 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 ...
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
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
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
68 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
1answer
66 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 ...
0
votes
1answer
44 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 ...
0
votes
1answer
67 views

How can I use the same filter in Excel (for Mac) twice on the same sheet?

I am working with a basic filter in an Excel sheet that I have on page layout. Both pages will have to have the exact same filter (it's separate as one page serves as a purchase order and the ...
0
votes
0answers
57 views

LibreOffice Calc: when copying an empty cell, it turns into a zero?

In a LibreOffice spreadsheet, when I want to duplicate a cell's content, I use =<source coords>. For example if I want cell A2 to contain a duplicate of whatever is in A1, I fill in =A1 in A2. ...
0
votes
1answer
140 views

Image Hyperlink to WWW using local cell referencing

The scenario: Manual input data in local excel file. I then click an adjacent image to run a preset hyperlink, to a specific web page, with part data captured from a specific cell. this is 100% ...
0
votes
0answers
445 views

Excel custom concatenate with color condition

I have this custom VBA function Public Function concatenatespecial(rng As Range) As String Dim rng1 As Range concatenatespecial = "" For Each rng1 In rng If (Not Rows(rng1.Row).Hidden) ...
0
votes
1answer
137 views

Find a text cell in a range dynamically

I am trying to find a cell in excel using a formula from a range. The range will be as such: ╔═══╦═══╦═══╦═══╦═══╦═══╦═══╦═══╗ ║ ║ A ║ B ║ C ║ D ║ E ║ F ║ G ║ ╠═══╬═══╬═══╬═══╬═══╬═══╬═══╬═══╣ ║ ...
0
votes
1answer
73 views

Using a cell value as address to access another cell (which maybe in the another worksheet)

i have one question, i have one cell (R1) which contains the address of the other cell (R2). now i want to access the content of the cell (R2) using the address which is stored in first cell (R1)
0
votes
1answer
466 views

How do I calculate the ratio for a range of cells in excel?

I'm trying to calculate the number of females per 100 males in each state and display the result using cell arrays. If the data for any state is unavailable or producing an error, then empty cell ...
0
votes
1answer
86 views

If I know the Row and I calculate the column, how do I make this a cell reference?

Here's my scenario: I find the row in a table using the "match" function. Can I use this value to reference a cell in the row I've found. For example, if, in cell B7, the match function returns a ...
0
votes
1answer
209 views

Excel - display as percentage, but keep properties as general or custom

Based on the image below that is how I want numbers to be displayed - as a percentage. But I don't want the properties to be listed as a percentage I want it to be listed as general "no specific ...
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
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 ...
0
votes
1answer
2k views

Formula or VBA for cell formatting using value based on a cell but formatting from an other cell

I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E. If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell. For example, ...
0
votes
1answer
29 views

Show a duplicate value on seperate excel spreadsheet

I have an two excel spreadsheets. One of the sheets is a summation of what is on the other sheet. I need to have a cell on the summation sheet that will tell me if i have a duplicate (more than 3 ...
0
votes
1answer
104 views

How does the user make a selection in MSExcel that contains only those cells that contain data?

Got an MSExcel question for you. he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem. And the version I am using is MSExcel 2003. My question has to do ...
0
votes
1answer
394 views

different colors in cells as value increases

The conditional formatting that I am using right now is .. if cell equals 1 then this color .. if cell equals 2 then this color and so on. Is there a way I can format it for more than just the 3 ...
0
votes
0answers
573 views

LibreOffice calc; is it possible to automatically make cells coloured according to the HTML code entered into them?

I am creating a LibreOffice calc spreadsheet designed to be basically be a customized version of the table entitled "Default element colors, by atomic number:" on this page http://jmol.sourceforge.net/...