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
0 answers
10 views

puling information from multiple cells based on number entered

I am trying to make a spreadsheet that based on a number I enter into a certain cell, pulls from other cells. I thought the "if" would work, but I can not get it too. IE: if I type 7 into ...
user avatar
  • 1
0 votes
1 answer
32 views

the arabic content in the cell excel is not shown correctly

The Text is in the cell is well written and when you click on it is is correct as shown in the upper view, On the cell itself it is not shown correctly For an example: Cell view: حمدا upper view : ...
user avatar
0 votes
0 answers
27 views

Excell Cell Drop Down Menu randomly lose data when attaching to an email or uploading to Google docs. How to fix?

My employer uses an excel spreadsheet with drop-down menus in some of the cells to keep track of student attendance. When I send the doc via email and upload the doc via Google Drive, sometimes a ...
user avatar
0 votes
0 answers
17 views

What's (if any) the formula to get multiple matching values in LibreOffice Calc? [duplicate]

Suppose I have the following data: A B 1 idx1 VAL1 2 idx2 VAL2 3 idx3 VAL3 4 idx4 VAL1 5 idx5 VAL4 6 idx6 VAL1 7 idx7 VAL1 8 idx8 VAL2 9 idx9 VAL5 10 idx10 VAL3 Is there a LibreOffice Calc ...
user avatar
  • 167
0 votes
0 answers
28 views

How do I use the information in a cell as the name of the sheet where an index formula is looking up the information from?

Ok I am creating a tracker of information and need to quickly copy and paste formulas since the criteria will be the same but the sheet as to which to look for the results will be different. in cell ...
user avatar
0 votes
1 answer
36 views

How to copy paste cells using formulas

I want the excell to recognize if it is electrical or civil or plumbing and re-arrange the value in order
user avatar
  • 1
0 votes
1 answer
23 views

Excel - Selecting Random Cell followed by Filling

I am trying to select a random cell from an array AND then fill down, fixing the column but letting the row remain relative. For example, I am trying to select the contents of a random cell from A1:...
user avatar
  • 3
0 votes
3 answers
588 views

Why does Excel add leading apostrophes to some of my text cells?

I have a worksheet containing, among other things, a table object. All data in the worksheet was added by me manually, including the data and column headers in the table. I just noticed that in 13 of ...
user avatar
0 votes
2 answers
169 views

Use Excel cell value in body of mailto hyperlink

In excel I have some cells that contain input for a e-mail form. A B E-mail me@myemail.com Subject Input form Name John Country Poland Body Hello,%0D%0A My name is : B3 %0D%0A I'm from : B4 ...
user avatar
-1 votes
2 answers
46 views

I need software to help know the number cells present in my battery [closed]

Is there any software I can use to get a comprehensive information about my battery ie the number of cells because I read somewhere that the more cells the battery has the longer the charge lasts, I ...
user avatar
0 votes
3 answers
711 views

Prevent Excel to automatically "Wrap text" in a cell

Let's say we have a spreadsheet with all rows having the same default height. In a cell, let's write Hello ALT+ENTER World. I indeed sometimes need to enter multi-line text in a cell, to write some ...
user avatar
  • 1,636
0 votes
0 answers
12 views

Disable Excel link cell follow click [duplicate]

This is probably the worst design choice I've seen in my life, and it drives me mad. I need to edit some excel spreadsheets which contain links and move some cells around, and each time I click on a ...
user avatar
0 votes
1 answer
95 views

A Function That Is Self-Aware of Its Own Cell Address?

I would like to write a function that is self-aware of its own cell address. For instance, I would like to be able to place an argumentless function in any cell, and when called, that function will ...
user avatar
  • 1
0 votes
0 answers
21 views

Data Validation cells referenced changed after Data is refreshed

I created a scorecard in excel that imports data for a data source. A dropdown list is on created of different employee names through Data Validation from this imported data. Most days everything is ...
user avatar
0 votes
5 answers
296 views

Excel: Sum all numbers separated by new line within cell

How do I create a new cell that equals the sum all numbers in a cell separated by a new line? I may not use text to columns as that is messy and there's no new line separator delimiter in text to ...
user avatar
  • 131
0 votes
0 answers
35 views

If cell in one column matches cell in another then copy data

I've got two separate sheets with a few hundred rows of data. I'm trying to see if any cell in Column C (Sheet 1) matches with a cell in column A (Sheet 2) then copy over the adjacent cell in column ...
user avatar
  • 1
0 votes
4 answers
224 views

excel formula of sum with error and cells not in range

I want a sum formula that will ignore errors. For example something like: =sum(c3+f3+h3+j3+n3) however, some of these cells may contain an error. Between these cells there is data which I do not want ...
user avatar
1 vote
1 answer
125 views

Copy sheet with protected cell

I have an excel worksheet that I protected certain cells with a password. AM afraid it could be touched by another person. How would it be done to COPY A SHEET TO A NEW FILE AND RETAIN THE PROTECTED ...
user avatar
2 votes
2 answers
1k views

In Excel, how can I round or display numbers to 2 significant figures (the two leading non-zero digits of a decimal number)?

In Excel 2016 I need to show zeros out to the leading non-zero digits and then just the two digits after that. For example: 0.00002423 should read 0.000024, 0.242 should read 0.24, 0.0032255 ...
user avatar
0 votes
0 answers
19 views

Refilling cells without exceeding a certain amount, by a given percentage

I am sorry if this question might sound quite complicated, I will try to be the more clear possible. I need that the amount in H13 (18,70€ in this case, if positive of course) refill the negative ...
user avatar
0 votes
1 answer
44 views

Get cells from another sheet based on criteria

I'm trying to build a simple helper to control my expenses. One sheet has a list of all financial movements (income and payments), with these details: Date Amount Reason 02/02/21 -1000.00 Rent 02/...
user avatar
0 votes
1 answer
217 views

Excel - Use Formula In Different Cell From Referencing In If Statement

I am currently working on a listing template that uses different things like a title generator. This generator uses a ton of if statements based on the data that it is given. I have broken this ...
user avatar
0 votes
1 answer
68 views

Display (or get at least) certain cell last modification date in Excel 2003 file (file extension is *.xls)

I have some Excel table which I filled with values since 2004. To sad I didn't include each row add date in extra cell. Now I want to know that... Maybe it still possible? Maybe *.xls file store that ...
user avatar
  • 187
1 vote
2 answers
74 views

Inserting a cell in Word table, that shifts the last cell onto the next row ... Can it be done?

I have a Word document in which I have a succession of cells, arranged in alphabetical order reading across. It is six cells wide by however long it goes down. What I want to be able to do, is add ...
user avatar
  • 11
1 vote
0 answers
12 views

Need help formatting dates and text in a range of cell

I've got a spreadsheet with certificates that expire at different dates. All of these have two columns. In one column is the date the certificate expires in which is usually every 3-5 years. The next ...
user avatar
1 vote
0 answers
63 views

i would like to add data from one document into other cell on a daily basis, is this possible?

i want to import data from this sheet into another. where i can add the number of time 'cardboard' appears in the column 'stillage reference' in column D based on the date in column G on a daily basis....
user avatar
  • 11
1 vote
0 answers
84 views

How do I keep the cell blank when the formula outputs nothing, so that the text from the previous adjacent cell can overflow in it?

I have a basic Excel IF function that shows a computation result if the condition is TRUE. What I am trying to figure out how is, in case the condition is FALSE, how to keep the cell blank so that ...
user avatar
  • 3,007
0 votes
1 answer
31 views

I want to add a text in a cell if a number is below or above a value

emphasized text i want to add the text 'FULL Delivery'' or ''Not Full'' to a cell that is either below 48 or equal to 48. can anyone help me.
user avatar
  • 11
0 votes
0 answers
162 views

Excel: Fake Blank Cell (cell has no content, nothing in the function box, but not recognized as a blank cell)

I have an Excel file with plenty of "blank" cells, these cells are not showing any content in the cell itself nor in the function box. And I'm trying to replace all these "blank" ...
user avatar
0 votes
3 answers
3k views

How to do hex calculations across multiple cells in excel?

I'm working on a spread sheet and I have a table or grid of [256]x[256] that looks like this: B c D E F G IY 3 Address: [byte][byte][byte][byte] ... ...
user avatar
0 votes
1 answer
28 views

Prevent User to fill in a specified value into a cell before another cell is filled

Since I am not that well versed in Excel I have stumbled upon the following Problem: I have the two cells: A1 and B1 I want A1 not to be able to be filled with the value "1" before B2 is ...
user avatar
  • 1
3 votes
2 answers
387 views

Libre Office - Single Column Pie Chart

I want to create a pie chart, for a single column that looks like this: I tried to select the range, click on Insert -> Chart -> Pie-Chart, but regardless of what I try, I always get an empty ...
user avatar
  • 127
0 votes
1 answer
72 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 ...
user avatar
  • 1
0 votes
4 answers
313 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 ...
user avatar
  • 1,636
1 vote
0 answers
19 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 ...
user avatar
1 vote
1 answer
300 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 ...
user avatar
2 votes
1 answer
413 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 ...
user avatar
  • 23
0 votes
0 answers
39 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 ...
user avatar
  • 53
0 votes
1 answer
4k 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 ...
user avatar
0 votes
1 answer
48 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 ...
user avatar
0 votes
3 answers
9k 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 ...
user avatar
  • 173
-1 votes
1 answer
20 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, ...
user avatar
0 votes
1 answer
141 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 ...
user avatar
  • 3
0 votes
1 answer
360 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 ...
user avatar
0 votes
0 answers
4k 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 ...
user avatar
  • 1
4 votes
2 answers
242 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 ...
user avatar
0 votes
1 answer
39 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 ...
user avatar
0 votes
1 answer
305 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 ...
user avatar
  • 3
0 votes
1 answer
119 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 ...
user avatar
1 vote
0 answers
84 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 ...
user avatar

1
2 3 4 5