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
2
votes
2answers
717 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 ...
-2
votes
0answers
8 views

Can't enter data in cell

Opened doc with several sheets. 1 of the sheets will not let me enter data-jumps me to another cell several rows down. Other sheets work fine. When I go back to the problem worksheet, I can type a ...
0
votes
0answers
11 views

Filling 2 cells using a drop down list

in need to help! I’m trying to make a new roster where I can click on a drop down list and the times auto fill into the 2 cells & I'm unsure how to do this? [below picture is what I’m trying to ...
0
votes
0answers
16 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 ...
0
votes
0answers
12 views

Copying data from one table to cell to another in Word 365

We used Word 2013 up until yesterday. Now we've been "upgraded" to Word 365. Up until yesterday, I had many documents with columns of figures that have tabs in the cells. Copying the data, ...
0
votes
1answer
29 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/...
0
votes
1answer
52 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 ...
0
votes
1answer
16 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 ...
0
votes
0answers
18 views

Excel: How to get address of a refered cell automatically, even after changing it's absolute address?

is ther any way (i.e. function) to show the address of a certain cell in Excel sheet, even after the user inserts or deletes rows or columns or sorts the sheet? For instance, if a cell address is G10, ...
1
vote
2answers
69 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 ...
1
vote
0answers
10 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 ...
1
vote
0answers
59 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....
1
vote
0answers
36 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 ...
0
votes
0answers
17 views

Excel cell formatting not working for some cells when trying to write in paragraphs

I have an excel sheet and I want to write content in a cell. There are around 2-3 paragraphs and bullet points. When I using the cell formatting feature, it works properly. But once I closed that file,...
0
votes
1answer
25 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.
0
votes
0answers
74 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" ...
0
votes
3answers
633 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] ... ...
0
votes
1answer
25 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 ...
2
votes
2answers
158 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 ...
0
votes
0answers
65 views

Can you remove verbose form information from an excel cell but keep the first bit which I need in there?

I have to pull work reports monthly on the tickets we work in my office. I have been able to customize the output generated by the ticketing system to a point, but the notes section is verbose and so ...
0
votes
1answer
63 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
4answers
130 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
0answers
13 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
1answer
147 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
1answer
187 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
0answers
35 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
1answer
3k 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
1answer
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
3answers
5k 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
1answer
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
1answer
44 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
1answer
155 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
0answers
3k 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
2answers
199 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
1answer
35 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
1answer
180 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
65 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
0answers
72 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
1answer
28 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
1answer
251 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
0answers
254 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
152 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
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 ...
2
votes
2answers
432 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
289 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
44 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
44 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
2answers
46 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
1answer
31 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
109 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 ...