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
0answers
448 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) ...
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
1k views

Excel: Let Users Click, but Not Edit, Locked Cells

Is there a way to allow users to click on, but not edit, the contents of a cell? I know I can tinker in the settings in Review->Protect Sheet with the "Select Locked Cells" option. But here's the ...
0
votes
1answer
90 views

refernce a cell that is a reference to another cell excel

I need to create a "double reference" in an excel sheet. What I need to do is enter a date on the first sheet, then reference that date on another sheet and (heres the part I dont get), reference the ...
0
votes
1answer
430 views

Dynamic range with absolute start cell in an excel table

In a column headed "Fred Count" I have the formula =COUNTIF(L$2:L10,"Fred") in row 10 where column L is headed "Person" and contains various names, so as I drag the formula down the "Fred Count" ...
1
vote
1answer
97 views

Is there a way to set Excel up so it will skip over the cells containing formulas and jump right to the cells requiring direct data entries?

I have a sheet with multiple columns that I need to enter numerical data in certain cells. Some of the rows contains formulas for totals and percentage results. Is there a way as I enter data and ...
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
50 views

How to apply a fomula multiple times at different intervals to entire column? OO Calc

I am using Open Office Calc on windows 8.1 Pro I have the following data already sorted nicely. A B C --+----------------------- 1 | Bmw Gold £80 2 | Bmw Silver £60 3 | ...
0
votes
1answer
220 views

Unexpected Behaviour using VLOOKUP in OpenOffice Calc

I am using VLOOKUP in OpenOffice Calc on Windows and trying to use a lookup table to populate some other cells. My Lookup table ranging A1:B6 is Car 4 Wheels Florida No Bus 8 ...
1
vote
1answer
57 views

Continous cell range in a filtered cells on another sheet or same sheet

I have a data source where I want to assign continuous cell range to the filtered cells only. For example, if I have filtered cell A1,A40,A79,A118,A157 and so on have a gap of 39 cells/rows and I want ...
0
votes
1answer
467 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 ...
1
vote
0answers
252 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 ...
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 ...
1
vote
1answer
568 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:...
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 ...
-1
votes
1answer
1k views

Lock Drop Down Cells and Enable Use - Excel 2013

I would like a drop down list in a cell. I would like to lock the cell so it cannot be moved or altered but changes other than selecting from the drop down menu.
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
2answers
87k views

What is the difference between 3 cells, 4 cells and 6 cells battery

I am going to buy new laptop but there is some confusion in battery capacity. I found that 3 cells battery backup is good than 4 cells battery laptop but I read somewhere that more cells means that ...
0
votes
1answer
575 views

Multiplication of cells containing words

I'm making a finance plan, where I have the columns 'Quantity', 'Cost' and 'Total'. The quantity column will contain how many of the item I buy. The Cost column will have the individual cost of the ...
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
2answers
101 views

How to use a button to clear multiple cells in excel? [closed]

How can I clear many cells at once. If I want to clear A1, A10, B10, B20 by just using one button or link. Only clearing those 4 specific cells in my example. I want to have a button that will ...
1
vote
0answers
350 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 ...
0
votes
2answers
67 views

Excel counting “A”'s with cell values of “A,B” “R,A” etc

Trying to count the number of individual variable in Excel but Countif doesn't seem to fit my needs For example individual cells have "A","A,B", "A,J", etc and I want to count the number of "A"s - is ...
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 ...
0
votes
1answer
1k views

excel: how to place rows at the bottom of list in sort and filter options?

Here is what I have at the moment: Click on home ribbon button click sort & filter drop down box I have a sort option as follows: As you can see the rows have been commanded to go to the top of ...
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 ...
1
vote
0answers
838 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 ...
0
votes
1answer
234 views

Count based on multiple alternate conditions in Excel

I need a formula to count any trailers that are due in but do not have a cell that says "yard" or have a date next to that trailer. Please see screenshot. I tried the COUNTIFS formula and was ...
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 ...
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 ...
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
25 views

Excel changes typed formula

Why does excel change cell entrys Example: Initial entry +20+20 Next time I click on cell the contents of cell now is 40 It is not consistent on all cells
0
votes
1answer
56 views

Excel 2010 Array (CSE) Formula: How to remove a part of contiguous (adjacent) range

I would really appreciate help on the following question: Is there a way to write a formula that removes a segment from a contiguous range? For example, say there is a formula =COUNTIF((A1:A100),">1"...
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
518 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
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
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 ...
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 ...
0
votes
2answers
569 views

In excel, I want the word “Name” to display but not print

I have a census sheet in excel that has to list peoples name in a specified area. There are a set number of rooms that can contain people, but they are not all full at all times. I would like to have ...
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
2answers
189 views

How do I create an excel formula to pick out differences in 2 cell values?

I have a column of company names (column A), a column of the 2014 revenue (column B) and a row of the 2015 revenue (column C). I want to somehow pick out which companies had zero revenue in 2014 and ...
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
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/...
0
votes
1answer
7k views

How to Mirror cells in excel 2013 [closed]

I want to make an excel file for sales management of my company. the excel I have created has 4 sheets and every sheet is handled by different persons. I want to dedicate the first column of these ...